topic Re: awk question in Operating System - HP-UX

awk question

Aashish Raj — Wed, 10 Apr 2002 06:24:19 GMT

Hi,
I have a file where fields are seprated by ** .
I need to use awk with -F option to select the second field.
If the fields are seprated by *, i am able to select by using -F'*' but for **, i have tried different combinations but nothing is working.I tried -F"**" , -F'**' , -F\*\* but no luck.

Thanks
AR

Re: awk question

Thierry Poels_1 — Wed, 10 Apr 2002 06:36:25 GMT

Hi,

the field separator is supposed to be one character only. So if "**" is used in the input file, use "*" as field separator, and skip those empty fields between the double "*".

good luck,
Thierry.

Re: awk question

Robin Wakefield — Wed, 10 Apr 2002 06:38:27 GMT

Hi,

I'd probably set FS in this instance:

awk 'BEGIN{FS="\*\*"}{print $3}' filename

Rgds, Robin

Re: awk question

Steve Steel — Wed, 10 Apr 2002 06:45:03 GMT

Hi

This worked as a quick test

echo 1**2|awk -F "[*][*]" '{print $2}'

Steve Steel

Re: awk question

Deepak Extross — Wed, 10 Apr 2002 06:47:02 GMT

First run
sed 's/\*\*/\|/g'
to replace the "**" delimiter with "|".
Then run awk using -F\|

HTH.

Re: awk question

Carlos Fernandez Riera — Wed, 10 Apr 2002 07:38:19 GMT

awk -F '\\\*\\\*' ' { print $1}' file1

Re: awk question

Ceesjan van Hattum — Wed, 10 Apr 2002 08:52:16 GMT

I go with Robin:

$> cat testfile
11**22**33
44**55**66
$> awk '{FS="\*\*"}{print $2}'testfile
22
55

Regards,
Ceesjan

Re: awk question

Heiner E. Lennackers — Wed, 10 Apr 2002 11:42:43 GMT

Hi,

awk expects as -F argument a regular expression. Because * is a multiplier in a regex, you have to define it as a character class.
e.g:
echo 1**2 | awk -F '[*][*]' '{print $2}'

echo 1**2 | awk -F '[*]{2}' '{print $2}'

Heiner

Re: awk question

SHABU KHAN — Wed, 10 Apr 2002 17:21:09 GMT

Hi Aashish,

You tried F"**" , -F'**' , -F\*\* but you didn't try -F'\\**'

Try two backslashes for two ** like this

ON HP's
echo "1**2**3**4" | awk -F'\\**' '{print $3,$4}'

use nawk on Sun's with the same syntax
Thanks,
Shabu