Shell Programming and Scripting

Hi Friends,

I have a file with the following values..

xyz.txt,12345.xml
abc.txt,04567.xml
cde.txt,12134.xml

I would like to extract all the 2nd column values twice as shown in the example like
12345,12345.xml
04567,04567.xml
12134,12134.xml

Please advice!!

In the formus one of our friends adviced me in fetching the 2nd column values

awk -F'[.|,]' '{print $3}' oldfile > newfile

Well, that awk script answers your question for the most part.

Play around a bit with that script (it doesn't bite), and you'll find the solution.

For example, check the token values - $1, $2, etc. Also see if you can print the same token value twice.

tyler_durden

Or if you use perl, just use the split.

Code:

split ($col1,$col2) ",", $line;

To keep the forums high quality for all users, please take the time to format your posts correctly.
Thank You.

The UNIX and Linux Forums
Reply With Quote

Code:

awk -F, '{split($NF,a,".");print a[1]FS$NF}' file

If you don't try to solve the problems yourself you'll never learn

if its hard to follow split you can follow this..

Code:

awk -F"[,.]" '{print $3","$3"."$4}' filename

Code:

echo "xyz.txt,12345.xml" | sed 's/[^,]*,\([0-9][0-9]*\)/\1,\1/'

What is \1 used for , Just want to know, I am new to sed