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 like
12345
04567
12134
Please advice!!
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 like
12345
04567
12134
Please advice!!
awk -F[,\.] '{ print $2}' oldfile > newfile
One option using awk:
awk -F'[.|,]' '{print $3}' file
Thanks...working....:)-