Mdthbs

Does the universe have a fixed centre of mass?

What is "Lambda" in Heston's original paper on stochastic volatility models?

Do i imagine the linear (straight line) homotopy in a correct way?

Statistical analysis applied to methods coming out of Machine Learning

Why does BitLocker not use RSA?

Is it OK to use the testing sample to compare algorithms?

How to resize main filesystem

How to achieve cat-like agility?

What is the proper term for etching or digging of wall to hide conduit of cables

What are some likely causes to domain member PC losing contact to domain controller?

French equivalents of おしゃれは足元から (Every good outfit starts with the shoes)

Why do C and C++ allow the expression (int) + 4*5?

Random body shuffle every night—can we still function?

Understanding piped commands in GNU/Linux

How does TikZ render an arc?

Determine whether an integer is a palindrome

Did pre-Columbian Americans know the spherical shape of the Earth?

Is there a spell that can create a permanent fire?

Improvising over quartal voicings

Table formatting with tabularx?

Google .dev domain strangely redirects to https

Russian equivalents of おしゃれは足元から (Every good outfit starts with the shoes)

The test team as an enemy of development? And how can this be avoided?

How do you cope with tons of web fonts when copying and pasting from web pages?

AWK fields filtering misses the first field

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I'm writing AWK code to pick some fields from an input file, and trim columns with pre-defined fields to pick, etc.

The input file looks like:

    stop_id,stop_code,stop_name,stop_lat,stop_lon,location_type,parent_station,wheelchair_boarding,platform_code

"228055","228055","Pacific Hwy After Murray St","-33.0036096083102","151.685565693411","","","0",""



"228054","228054","Pacific Hwy Opp Ntaba Rd","-33.0061947514409","151.684612196188","","","0",""



"287146","287146","Flint St At Oxford St","-33.3923728991621","148.014977179488","","","0",""



"228056","228056","Pacific Hwy At South St","-32.9998469180446","151.685494632801","","","0",""

And my simplified code to exercise the problem I have:

#! /usr/bin/awk -f

BEGIN {

# 0. AWK init

    FS = ","

    OFS = ","

}



NR == 1 {

    for (i = 1; i <= NF; i++) {

        # headerIdx["stop_id"] = 1, etc

        headerIdx[$i] = i

        print "key: " $i ", value: " headerIdx[$i]

    }

    print "stop_id - " headerIdx["stop_id"] "stop_code - " headerIdx["stop_code"] ", stop_name - " headerIdx["stop_name"] ", stop_lat - " headerIdx["stop_lat"]

}

When I run the script like (for example): "./awk-test.awk stops.txt" (where the data file name is stops.txt and the script file name is awk-test.awk), I got an output:

key: stop_id, value: 1
key: stop_code, value: 2
key: stop_name, value: 3
key: stop_lat, value: 4
key: stop_lon, value: 5
key: location_type, value: 6
key: parent_station, value: 7
key: wheelchair_boarding, value: 8
key: platform_code, value: 9

stop_id - stop_code - 2, stop_name - 3, stop_lat - 4

I would expect the stop_id in the last line has a value 1, but it has nothing.

Why my expectation is not reasonable and how to make it spit out the missing value 1? (GNU Awk 4.1.4, API: 1.1 (GNU MPFR 4.0.1, GNU MP 6.1.2)
, and I can switch to gawk if it fixes this problem)

awk

share|improve this question

asked 53 mins ago

oz.stigoz.stig

1

New contributor

oz.stig is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you make sure that first line doesn't have spaces at the beginning?
  
  – Prvt_Yadv
  16 mins ago
  

  
  
  
  

add a comment | 

0

I'm writing AWK code to pick some fields from an input file, and trim columns with pre-defined fields to pick, etc.

The input file looks like:

    stop_id,stop_code,stop_name,stop_lat,stop_lon,location_type,parent_station,wheelchair_boarding,platform_code

"228055","228055","Pacific Hwy After Murray St","-33.0036096083102","151.685565693411","","","0",""



"228054","228054","Pacific Hwy Opp Ntaba Rd","-33.0061947514409","151.684612196188","","","0",""



"287146","287146","Flint St At Oxford St","-33.3923728991621","148.014977179488","","","0",""



"228056","228056","Pacific Hwy At South St","-32.9998469180446","151.685494632801","","","0",""

And my simplified code to exercise the problem I have:

#! /usr/bin/awk -f

BEGIN {

# 0. AWK init

    FS = ","

    OFS = ","

}



NR == 1 {

    for (i = 1; i <= NF; i++) {

        # headerIdx["stop_id"] = 1, etc

        headerIdx[$i] = i

        print "key: " $i ", value: " headerIdx[$i]

    }

    print "stop_id - " headerIdx["stop_id"] "stop_code - " headerIdx["stop_code"] ", stop_name - " headerIdx["stop_name"] ", stop_lat - " headerIdx["stop_lat"]

}

When I run the script like (for example): "./awk-test.awk stops.txt" (where the data file name is stops.txt and the script file name is awk-test.awk), I got an output:

key: stop_id, value: 1
key: stop_code, value: 2
key: stop_name, value: 3
key: stop_lat, value: 4
key: stop_lon, value: 5
key: location_type, value: 6
key: parent_station, value: 7
key: wheelchair_boarding, value: 8
key: platform_code, value: 9

stop_id - stop_code - 2, stop_name - 3, stop_lat - 4

I would expect the stop_id in the last line has a value 1, but it has nothing.

Why my expectation is not reasonable and how to make it spit out the missing value 1? (GNU Awk 4.1.4, API: 1.1 (GNU MPFR 4.0.1, GNU MP 6.1.2)
, and I can switch to gawk if it fixes this problem)

awk

share|improve this question

asked 53 mins ago

oz.stigoz.stig

1

New contributor

oz.stig is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you make sure that first line doesn't have spaces at the beginning?
  
  – Prvt_Yadv
  16 mins ago
  

  
  
  
  

add a comment | 

I'm writing AWK code to pick some fields from an input file, and trim columns with pre-defined fields to pick, etc.

The input file looks like:

    stop_id,stop_code,stop_name,stop_lat,stop_lon,location_type,parent_station,wheelchair_boarding,platform_code

"228055","228055","Pacific Hwy After Murray St","-33.0036096083102","151.685565693411","","","0",""



"228054","228054","Pacific Hwy Opp Ntaba Rd","-33.0061947514409","151.684612196188","","","0",""



"287146","287146","Flint St At Oxford St","-33.3923728991621","148.014977179488","","","0",""



"228056","228056","Pacific Hwy At South St","-32.9998469180446","151.685494632801","","","0",""

And my simplified code to exercise the problem I have:

#! /usr/bin/awk -f

BEGIN {

# 0. AWK init

    FS = ","

    OFS = ","

}



NR == 1 {

    for (i = 1; i <= NF; i++) {

        # headerIdx["stop_id"] = 1, etc

        headerIdx[$i] = i

        print "key: " $i ", value: " headerIdx[$i]

    }

    print "stop_id - " headerIdx["stop_id"] "stop_code - " headerIdx["stop_code"] ", stop_name - " headerIdx["stop_name"] ", stop_lat - " headerIdx["stop_lat"]

}

When I run the script like (for example): "./awk-test.awk stops.txt" (where the data file name is stops.txt and the script file name is awk-test.awk), I got an output:

key: stop_id, value: 1
key: stop_code, value: 2
key: stop_name, value: 3
key: stop_lat, value: 4
key: stop_lon, value: 5
key: location_type, value: 6
key: parent_station, value: 7
key: wheelchair_boarding, value: 8
key: platform_code, value: 9

stop_id - stop_code - 2, stop_name - 3, stop_lat - 4

I would expect the stop_id in the last line has a value 1, but it has nothing.

Why my expectation is not reasonable and how to make it spit out the missing value 1? (GNU Awk 4.1.4, API: 1.1 (GNU MPFR 4.0.1, GNU MP 6.1.2)
, and I can switch to gawk if it fixes this problem)

awk

share|improve this question

asked 53 mins ago

oz.stigoz.stig

1

New contributor

oz.stig is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

    stop_id,stop_code,stop_name,stop_lat,stop_lon,location_type,parent_station,wheelchair_boarding,platform_code

"228055","228055","Pacific Hwy After Murray St","-33.0036096083102","151.685565693411","","","0",""



"228054","228054","Pacific Hwy Opp Ntaba Rd","-33.0061947514409","151.684612196188","","","0",""



"287146","287146","Flint St At Oxford St","-33.3923728991621","148.014977179488","","","0",""



"228056","228056","Pacific Hwy At South St","-32.9998469180446","151.685494632801","","","0",""

#! /usr/bin/awk -f

BEGIN {

# 0. AWK init

    FS = ","

    OFS = ","

}



NR == 1 {

    for (i = 1; i <= NF; i++) {

        # headerIdx["stop_id"] = 1, etc

        headerIdx[$i] = i

        print "key: " $i ", value: " headerIdx[$i]

    }

    print "stop_id - " headerIdx["stop_id"] "stop_code - " headerIdx["stop_code"] ", stop_name - " headerIdx["stop_name"] ", stop_lat - " headerIdx["stop_lat"]

}

share|improve this question

asked 53 mins ago

oz.stigoz.stig

1

New contributor

oz.stig is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 53 mins ago

oz.stigoz.stig

1

New contributor

oz.stig is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 53 mins ago

oz.stigoz.stig

1

New contributor

oz.stig is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 53 mins ago

oz.stigoz.stig

1