Awk Question 1

[HIB049]

Hi Guys,

What is the quickest way to do the following?

Name Address Tel No email website Fax No

to

Name#Address#Tel No#email#website#Fax No


Your comments would be kindly appreciated.

Thanks

Ed

 

[Annihilannic]

Fancy that... an "Awk Question" in the AWK forum. Please consider giving your threads more descriptive titles...

Are the fields just separated by spaces... i.e. no tabs? If so, I'd suggest replacing the spaces with hashes, and then replace "#No" with " No".

awk '{[b]gsub[/b]([red]"[/red][purple] [/purple][red]"[/red],[red]"[/red][purple]#[/purple][red]"[/red],[blue]$0[/blue]); [b]gsub[/b]([red]"[/red][purple]#No[/purple][red]"[/red],[red]"[/red][purple] No[/purple][red]"[/red],[blue]$0[/blue]); [b]print[/b]}' inputfile > outputfile

However I'd recommend using sed instead for that job:

sed 's/ /#/g;s/#No/ No/g' inputfile > outputfile

Annihilannic.

 

[p5wizard]

or even [tt]tr[/tt]

tr ' ' '#' <inputfile >outputfile

HTH,

p5wizard

 

[HIB049]

Thanks guys for getting back on this one, sorry it was late in the night when I was typing, so could think of a descritive subject. But thats absolutly wonderful. Thanks once again for the response.