UNIX for Dummies Questions & Answers

Hello Sir/Madam,

I'm new to UNIX and wondering if I can process a find & add using AWK command in UNIX?

requirements: I have to find *.JPG field for each line in the input file and add it as a separate field for each line.. for ex:

0000684631,E,3088017,7 ,NXA114398114,A,,/usr/GLS/AMI/Pepco/748f4460-37de-468e-a9e3-000bd401e38a_C000684631_InstallMtr1-0002.JPG,07-09-2012,11:35,-76.90694,38.8761366666,

When it is done this is how it should look like:
0000684631,E,3088017,7 ,NXA114398114,A,,C000684631_InstallMtr1-0002.JPG,/usr/GLS/AMI/Pepco/748f4460-37de-468e-a9e3-000bd401e38a_C000684631_InstallMtr1-0002.JPG,07-09-2012,11:35,-76.90694,38.8761366666,

My file has 100000 records and I have to process this for each line.

Please suggest how I can do this..
Thank you in advance for you help..

Regards,
Vani

You said find JPG field.. Does it move? Or do you want the substring after the first underscore in field 8? This does the latter:

Code:

awk -F, '{$8=substr($8,1+index($8,"_")) OFS $8}1' infile

Thank you for the quick reply..

Does it move?
No.

Do you want the substring after the first underscore in field 8?
Yes.. I would like determine the "*.JPG" name after the first underscore and copy that as field in each line after double commas..

I might be doing some thing worng.. when I tried your code this is what is prompting..

perseus.gasleak(/usr/GLS/AMI/Pepco)% awk -F, '{$8=substr($8,1+index($8,"_")) OFS $8}1' phi_pep.bk
awk: syntax error near line 1
awk: bailing out near line 1


---------- Post updated at 11:59 AM ---------- Previous update was at 09:33 AM ----------

awk '{print $2=substr($2,1+index($2,"_"))}' phi_pep.txt

output text is:
C000684631_InstallMtr1-0002.JPG,07-09-2012,11:35,M,-76.90694,38.8761366666,


How can chop off the data after "C000684631_InstallMtr1-0002.JPG," field using your example?

Is this Solaris? use nawk and see that output is as desired?

Code:

$ cat input
0000684631,E,3088017,7 ,NXA114398114,A,,/usr/GLS/AMI/Pepco/748f4460-37de-468e-a9e3-000bd401e38a_C000684631_InstallMtr1-0002.JPG,07-09-2012,11:35,-76.90694,38.8761366666,
$ nawk -F, '{$8=substr($8,1+index($8,"_")) OFS $8}1' OFS=, input
0000684631,E,3088017,7 ,NXA114398114,A,,C000684631_InstallMtr1-0002.JPG,/usr/GLS/AMI/Pepco/748f4460-37de-468e-a9e3-000bd401e38a_C000684631_InstallMtr1-0002.JPG,07-09-2012,11:35,-76.90694,38.8761366666,

it is a UNIX server

"What operating system are you running?"
"UNIX"

"What model is your car?"
"Blue"

Both very vague answers to the question.

If you don't know what your system is, uname -a

All I know is my test server is a UNIX server, but here an appropriate answer for ur qes:

SunOS perseus 5.10 Generic_144500-19 sun4v sparc SUNW,Sun-Blade-T6320

---------- Post updated at 02:37 PM ---------- Previous update was at 12:38 PM ----------

Scott,
Appriciate your prompt help..

nawk worked..

since my file has about 100000 records, would it be safe to write to a different output file instead of printing to screen? if so, please tell me how I can do that?


if you have time, please help me understand below two questions..

Two questions..
1) when I used AWK to print first column


perseus.gasleak(/usr/GLS/AMI/Pepco/Portable)% awk '{print $1}' phi_pep.txt

output is:
0000684631,E,3088017,7

perseus.gasleak(/usr/GLS/AMI/Pepco/Portable)% awk '{print $2}' phi_pep.txt

Why it is displaying like this?

2) if "-F" is used for comma delimited record file, why didn't is print just the first column?



output is:
,NXA114398114,A,,/usr/GLS/AMI/Pepco/Portable/748f4460-37de-468e-a9e3-000bd401e38a_C000684631_InstallMtr1-0002.JPG,07-09-2012,11:35,M,-76.90694,38.8761366666,