every fields make "-" delimited using awk

jone kim · 09-19-2014, 11:00 AM

I've to make a space seperated data information to "-" delimited. If the fields were fixed I can use:

Code:

awk '{print $1"-"$2"-"$3"-"$4"-"}' final.txt

having four fields.

but how can I do the same when the fields are variable in every rows.
Suppose:

Quote:

AAA BBB CCC

UUU TTT III OOO

RRR SSS PPP GGG HHH

BBB MMM

required o/p:

Quote:

AAA-BBB-CCC

UUU-TTT-III-OOO

RRR-SSS-PPP-GGG-HHH

BBB-MMM

firstfire · 09-19-2014, 11:08 AM

Hi.

How about this:

Code:

$ cat infile
AAA BBB CCC

UUU TTT III OOO

RRR SSS PPP GGG HHH

BBB MMM 
$ sed 's/ \+\b/-/g' infile
AAA-BBB-CCC

UUU-TTT-III-OOO

RRR-SSS-PPP-GGG-HHH

BBB-MMM

suicidaleggroll · 09-19-2014, 11:12 AM

How about this

Code:

awk '{printf $1}{for(i=2;i<=NF;i++)printf "-"$i}{printf "\n"}'

Code:

$ cat final.txt
AAA BBB CCC

UUU TTT III OOO

RRR SSS PPP GGG HHH

BBB MMM
$ awk '{printf $1}{for(i=2;i<=NF;i++)printf "-"$i}{printf "\n"}' final.txt
AAA-BBB-CCC

UUU-TTT-III-OOO

RRR-SSS-PPP-GGG-HHH

BBB-MMM

edit: beat by the sed...

metaschima · 09-19-2014, 11:38 AM

Assuming one space:

Code:

bash-4.2$ cat tt
AAA BBB CCC

UUU TTT III OOO

RRR SSS PPP GGG HHH

BBB MMM
bash-4.2$ tr ' ' '-' < tt
AAA-BBB-CCC

UUU-TTT-III-OOO

RRR-SSS-PPP-GGG-HHH

BBB-MMM

If you have more than one space in between you can use the 'tr -s' option to squeeze repeats.

Code:

bash-4.2$ cat tt
AAA BBB CCC

UUU TTT   III OOO

RRR SSS PPP GGG HHH

BBB   MMM
bash-4.2$ tr -s ' ' '-' < tt
AAA-BBB-CCC

UUU-TTT-III-OOO

RRR-SSS-PPP-GGG-HHH

BBB-MMM

grail · 09-20-2014, 01:58 AM

Code:

awk '$1=$1' OFS="-" file