Concatenating values in a File

amitkhiare · #1 (**permalink**) 10-08-2007

Hi All,

I have a ',' delimited file and i would like concatenate a new value at a specific column.

Example :-
xXXX,XYZ,20071005,ABC,DEF,123
xXXX,XYZ,20071005,ABC,DEF,123
xXXX,XYZ,20071005,ABC,DEF,123

The output that i want is
xXXX,XYZ,20071005001,ABC,DEF,123
xXXX,XYZ,20071005002,ABC,DEF,123
xXXX,XYZ,20071005003,ABC,DEF,123
........
xXXX,XYZ,20071005010,ABC,DEF,123
xXXX,XYZ,20071005011,ABC,DEF,123
and so .... on....

As you see the only difference is in the Column # 3 where i want to add 001, 002, 003 .... till the end of file [ in the above example there are 11 records so last updated value is 20071005011 ], however all other values should remain the same.

Please let me know if you have any doubts about the query.

and thanks for your time.

Amit

ghostdog74 · #2 (**permalink**) 10-08-2007

Code:

#assumption: only till 999
awk 'BEGIN{OFS=FS=",";c=1}
    { 
     n=sprintf("%03d",c++)
     $3=$3n     
    }
    1' "file"

amitkhiare · #3 (**permalink**) 10-08-2007

Quote:

Originally Posted by ghostdog74

Code:

#assumption: only till 999
awk 'BEGIN{OFS=FS=",";c=1}
    { 
     n=sprintf("%03d",c++)
     $3=$3n     
    }
    1' "file"

Hi, can you explain how it work i am not able to understand and also not able to us it... Please help
Thanks for your time.
Amit

ghostdog74 · #4 (**permalink**) 10-08-2007

Quote:

Originally Posted by amitkhiare

Hi, can you explain how it work i am not able to understand and also not able to us it... Please help
Thanks for your time.
Amit

1) 'BEGIN{OFS=FS=",";c=1} #set output and input field separator to ",", initialize c variable to 1. this will be used for counting up
2) n=sprintf("%03d",c++) # string formatting. precede the number by 0's and fix it at length 3. Then assign the value to n eg 001, 002, till 999
3)$3=$3n #append 001 , 002 etc to field 3, which is the field with date, eg 20071005

which platform are you in? i am using GNU awk.

summer_cherry · #5 (**permalink**) 10-08-2007

Hi,
This should be also ok.

code:

Code:

awk 'BEGIN{FS=","}
{
print $1","$2","$3*1000+NR","$4","$5","$6
}' filename

amitkhiare · #6 (**permalink**) 10-09-2007

Quote:

Originally Posted by ghostdog74

1) 'BEGIN{OFS=FS=",";c=1} #set output and input field separator to ",", initialize c variable to 1. this will be used for counting up
2) n=sprintf("%03d",c++) # string formatting. precede the number by 0's and fix it at length 3. Then assign the value to n eg 001, 002, till 999
3)$3=$3n #append 001 , 002 etc to field 3, which is the field with date, eg 20071005

which platform are you in? i am using GNU awk.

Hi,

I am using this on Solaris Box and i tried your solution how ever the output is different and it is adding the 001 in the front side, not sure why. So the output is 00171005 for "20071005".

Will this be case of different platform...

reborg · #7 (**permalink**) 10-09-2007

try nawk on Solaris

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Concatenating the two lines in a file	srivsn	Shell Programming and Scripting	6	07-17-2008 09:03 PM
Converting Binary decimal coded values to Ascii Values	gaur.deepti	UNIX for Advanced & Expert Users	3	04-02-2008 12:33 PM
Extract values from log file	wdympcf	Shell Programming and Scripting	5	08-10-2007 03:52 AM
Change the Values in a file	rudoraj	Shell Programming and Scripting	6	09-18-2006 11:58 AM
concatenating static string to records in data file	gillbates	Shell Programming and Scripting	5	06-22-2006 06:22 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by