Search Results

Thank you so much! Both RudiC and Aia's solutions work, howeverwith the awk solution, the second line prints

,0,0

and with the perl solution the last line prints

,0,0
Can someone explain...

its not working correctly, in the middle of the file it prints the header in one of the rows, and the first line is ,0,0

my csv file has headers so i added NR==1

still no luck

Hi, I am new to awk and unix programming and trying to manipulate a csv file.

My current csv file looks like this:

col1,col2,col3,col4,col5,col4,col5,col6,col7,col8
223,V,c,2,4,f,r,,y,z...

@Chubler_XL, I tried dos2unix file2.csv and sed -i 's/[[:space:]]*$//' file2.csv but still receiving the same output..

---------- Post updated at 09:46 AM ---------- Previous update was at 09:22...

@Franklin52 and @Chubler_XL thanks for your replies!

File 1 currently does not have a ID column. This ID column has to be inserted. @Franklin52, when I try tried your approach, the outout is...

I tried to do something like this:

awk -F, 'FNR==NR{a[$2]=$1;next}$1 in a {$7=a[$1]}1' OFS="," FS="," file2.csv file1.csv

The output is completely wrong though :(

Have not written any awk...

Hi,

I am new to awk/unix and am trying to put together an awk script to perform an action similar to vlookup between the two csv files.

Here are the contents of the two files:

File 1:
...

That worked perfectly!! Thank you so much!! :)

Hi,

I am new to awk/unix and am trying to put together a script to manipulate the date column in a csv file.

I have file1.csv with the following contents:

Date,ID,Number,Amount,Volume,Size...