awk -F"$$$": Get column 1 with delimiter having multiple characters having "$" char

[Sangal-Arun]

Suppose I have the following lines in a file:

/vob/efs/class.tcl@@/main/pub-int/arne-dev/1$$$c098302$$$Allow to routes.
/vob/efs/abc.pl@@/main/pub-int/arne-dev/1$$$qabuild$$$Rebase done
/vob/efs/travel.pl@@/main/pub-int/arne-dev/10$$$e027485$$$FSN3972
/vob/efs/travel.pl@@/main/pub-int/arne-dev/3$$$qabuild$$$Rebase
/vob/efs/baggage.pl@@/main/pub-int/arne-dev/19$$$qabuild$$$Rebase done

Now, how can get the 1st column with using "awk" (Note: Using awk only....) if I assume to delimit it by using "$$$" characters. i.e. multiple $ character should be treated as 1 delimiter in a line.

Kindly help.

[bhaslinux]

cat <> | awk -F'\$\$\$' '{print $1}'

[Sangal-Arun]

Nopes, it didn't work. Tried it both using " " and ' '

Can anybody help us in this????

A

[drl]

Hi.
1) Restricting the solution set to awk may cause better solutions to be lost, ignored, etc. Why are you doing that?

... (Note: Using awk only....) ...

2) What part of a line are you considering the "first column"? ... cheers, drl

( edit 1: typo )

[Sangal-Arun]

Hi Drl,

Hope you are doing fine..

Actually the file I'm going to change uses awk very much in its coding...mostly. That's why I asked to get the 1st column with using awk...

Yups.. I want only the 1st part....and that can be picked up using various methods...but I'm restricted to change the whole script.

If required, I will try change the script as a whole.


Any helps!

Arun Sangal

Hi.
1) Restricting the solution set to awk may cause better solutions to be lost, ignored, etc. Why are you doing that?

2) What part of a line are you considering the "first column"? ... cheers, drl

( edit 1: typo )

[drl]

Hi, Sangal-Arun.

Here is one solution:

#!/bin/sh

# @(*) s5       Demonstrate awk field splitting with regular expression.

FILE=${1-data1}

gawk '
BEGIN   { FS = "[$]+"; print " Field separator is ", FS }
        { print "NF =",NF,"field 1 =",$1 }
' $FILE

Which produces:

% ./s5
 Field separator is  [$]+
NF = 3 field 1 = /vob/efs/class.tcl@@/main/pub-int/arne-dev/1
NF = 3 field 1 = /vob/efs/abc.pl@@/main/pub-int/arne-dev/1
NF = 3 field 1 = /vob/efs/travel.pl@@/main/pub-int/arne-dev/10
NF = 3 field 1 = /vob/efs/travel.pl@@/main/pub-int/arne-dev/3
NF = 3 field 1 = /vob/efs/baggage.pl@@/main/pub-int/arne-dev/19

cheers, drl

( edit 1: typo )

[Franklin52]

Try:

awk -F '\$\$\$' '{ print $1 }' filename

Dont cat the file to awk because the shell expands the $$$ characters to something unexpectable.

Regards

[Sangal-Arun]

You are GREAT.

I used the same funda with awk and it worked.. Thanks for your help.

[/E*Fare/Users/qabuild/aksutil/P/pawan] $ head -2 arne; echo -e "\n\n" ; head -2 arne|awk -F"[$]+" '{print $1}'
/vob/efs/EFare/meta-inf/AFarepf3Form.class.tcl@@/main/pub-int/arne-dev/1$$$c098302$$$Allow for follow to routes.
/vob/efs/EFare/Server/acctravel.pl@@/main/pub-int/arne-dev/1$$$qabuild$$$Rebase done from to arne by Pankaj Agarwal -- on Mon Feb 5 16:12:54 GMT 2007



/vob/efs/EFare/meta-inf/AFarepf3Form.class.tcl@@/main/pub-int/arne-dev/1
/vob/efs/EFare/Server/acctravel.pl@@/main/pub-int/arne-dev/1


Brgds,
Arun Sangal

Hi, Sangal-Arun.

Here is one solution:

#!/bin/sh

# @(*) s5       Demonstrate awk field splitting with regular expression.

FILE=${1-data1}

gawk '
BEGIN   { FS = "[$]+"; print " Field separator is ", FS }
        { print "NF =",NF,"field 1 =",$1 }
' $FILE

Which produces:

% ./s5
 Field separator is  [$]+
NF = 3 field 1 = /vob/efs/class.tcl@@/main/pub-int/arne-dev/1
NF = 3 field 1 = /vob/efs/abc.pl@@/main/pub-int/arne-dev/1
NF = 3 field 1 = /vob/efs/travel.pl@@/main/pub-int/arne-dev/10
NF = 3 field 1 = /vob/efs/travel.pl@@/main/pub-int/arne-dev/3
NF = 3 field 1 = /vob/efs/baggage.pl@@/main/pub-int/arne-dev/19

cheers, drl

( edit 1: typo )

[Sangal-Arun]

No Franklin... It didn't work.

I used:

awk -F"[$]+" '{print $1}' filename

Thanks to Drl.
Arun Sangal

Try:

awk -F '\$\$\$' '{ print $1 }' filename

Dont cat the file to awk because the shell expands the $$$ characters to something unexpectable.

Regards

[Franklin52]

No Franklin... It didn't work.

On my box it works well.

Regards