cut with multiple character delimeter

krock923 · 12-21-2004, 06:06 PM

For a script I'm writing, I need to use cut and " / " as the delimeter. [space,slash,space]. Obviously, this won't work with the cut command so is there any other command that is better suited for something like this?

mjrich · 12-21-2004, 06:26 PM

I'd use Awk, personally...

Cheers,

mj

krock923 · 12-21-2004, 06:36 PM

I don't know enough about awk to know how to do that. If that's the way to go, could you please post some example code or seome general guidelines?

jlliagre · 12-21-2004, 06:50 PM

Or you can use sed then cut ...

Tinkster · 12-21-2004, 06:57 PM

Quote:

Originally posted by krock923
I don't know enough about awk to know how to do that. If that's the way to go, could you please post some example code or seome general guidelines?

How's that:

You post sample data, I post sample awk usage :}

Cheers,
Tink

mjrich · 12-21-2004, 07:05 PM

Following on from jlliagre's suggestion, you could use something along the lines of

Code:

cat test | tr -s '[:space:]/[:space:]' '@'| cut -d @ -f <field_no>

...assuming you don't have any spare @'s in your datafile.

krock923 · 12-21-2004, 07:09 PM

here is the original line

DTITLE=Various Artists / Kohl's - Songs Of The Season 2000

this is what i have so far

grep DTITLE cdinfo.txt | cut -d '=' -f 2

which produces this line:

Various Artists / Kohl's - Songs Of The Season 2000

Tinkster · 12-21-2004, 07:18 PM

Quote:

Originally posted by krock923
here is the original line

DTITLE=Various Artists / Kohl's - Songs Of The Season 2000

this is what i have so far

grep DTITLE cdinfo.txt | cut -d '=' -f 2

which produces this line:

Various Artists / Kohl's - Songs Of The Season 2000

Code:

FIELD1=`grep DTITLE cdinfo.txt | cut -d '=' -f 2 | awk 'BEGIN{ FS=" / "}{print $1}'`
FIELD2=`grep DTITLE cdinfo.txt | cut -d '=' -f 2 | awk 'BEGIN{ FS=" / "}{print $2}'`

Cheers,
Tink

krock923 · 12-21-2004, 07:27 PM

Thank you very much. That worked great.

Tinkster · 12-21-2004, 07:38 PM

Pleasure ;)

Cheers,
Tink