how to parse data with || as delimeter 1

[vuakhobo]

Hello expert,

I have file with || as delimeter
I need help how to parse data with || as delimeter

cat test1|cut -d'||' -f1 <- is not working.
is there a way to get it done?

 

[feherke]

Hi

Complex field separators are better handled by script interpreters :

awk -F '[i]|[/i]|' '{print $1}' test1

[gray]# or[/gray]

perl -aF'\|\|' -ne 'print $F[0]' test1

[gray]# or[/gray]

ruby -aF'\|\|' -ne 'print $F[0]' test1

Feherke.

http://free.rootshell.be/~feherke/

 

[vuakhobo]

Thank you for feherke for helping me but I still have problem getting individual value.

I have a test file with contains the content as follow

aaa||bbb||cccddd333||111

when I run

awk -F '||' '{print $1}' test2.dat

it gave entire string back. How can I get individual value?

 

[feherke]

Hi

Sorry, an issue made its way into the [tt]awk[/tt] code.

awk -F '\\|\\|' '{print $1}' test1

Feherke.

http://free.rootshell.be/~feherke/

 

[vuakhobo]

Thank you Feherke, it works great.