Shell Programming and Scripting

Hi Guys,

I have a File like below.

Now, i am able to separate using multiple Delimiters in Awk. So,now when i search for FTOP, i need to retrieve the next column.

In the above case,

Can somebody help as how to retrieve it.

Following is the code i have achieved till now.

Code:

awk -F[,|] '/FTOP/<dont  knw what to do now>' Filename

Thanks for your help in advance.

Cheers!!

Code:

awk -F'[,|]' '{for (i=1; i<=NF; i++){if($i=="FTOP"){print $(i+1);next}}}' file

---------- Post updated at 10:03 AM ---------- Previous update was at 09:49 AM ----------

Maybe a different approach.

Code:

perl -nle '/FTOP,(\d)/ and print $1' file

another way

Code:

awk -F"FTOP," '/FTOP/{ split($2,a,"|"); print a[1]}' file