how i can use a WORD for seperator

qrshat · #1 (**permalink**) 02-09-2006

hi,

i want to use A WORD for seperator in awk or especially in cut. how i can perform this. is there any way to use a word for seperator.

For example: i want to list all word after FROM and the files name contains this word.

chatnorollback.svc: delete from info where nick
chatnorollback.svc: delete from webbilling where
chatnorollback.svc: delete from webbilling where
chatnorollback.svc: sql {delete from login where
chatnorollback.svc: sql {delete from odablack
chatnorollback.svc: sql {delete from blacklist
chatnorollback.svc: sql {delete from info where
chatnorollback.svc: sql {delete from register

thanks in advance,

reborg · #2 (**permalink**) 02-09-2006

Not really, but this might help.

Code:

sed -n 's/^\([^ ][^ ]*\).*from/\1/p' file.txt

Ygor · #3 (**permalink**) 02-09-2006

Set the awk built-in variable FS (Field Separator) to the value you want...

Code:

awk -v FS=from '{print $2}' file.txt

The details are in the awk manual: Specifying how Fields are Separated

reborg · #4 (**permalink**) 02-10-2006

Ygor, of course you're correct. I had some strange notion in my head about only being able to use on char as the FS.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to change field seperator	onthetopo	Shell Programming and Scripting	2	05-11-2007 01:11 PM
Can a shell script pull the first word (or nth word) off each line of a text file?	tricky	Shell Programming and Scripting	5	08-17-2006 07:29 AM
Using \| as a seperator in join	firvin	UNIX for Dummies Questions & Answers	5	03-28-2006 12:23 PM
Comma seperator	premar	Shell Programming and Scripting	6	02-17-2006 04:16 AM
Awk Field Seperator Help	insania	Shell Programming and Scripting	3	11-11-2005 04:29 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by