OFS in awk

MIA651 · #1 10-23-2012

Hello,

I have an issue with adding commas as delimiters in this scenario:

Code:

cat xtr3.rpl|head -5|awk 'BEGIN {OFS=","} {print $1,$2,$3,$4}'

itkamaraj · #2 10-23-2012

can you post the output of

Code:

head -5 xtr3.rpl

MIA651 · #3 10-23-2012

Yes, sorry I should've done that from the beginning but here is the output:

Code:

head -5 xtr3.rpl

itkamaraj · #4 10-23-2012

try this... (with some assumption)

Code:

awk -v OFS=, 'NR>5{exit}{gsub("-"," -");print $1,$2,$3,$4}' xtr3.rpl

elixir_sinari · #5 10-23-2012

If the input records are having fields of fixed length, you are better off using substr in awk .

MIA651 · #6 10-23-2012

You're a genius, itkamaraj!

---------- Post updated at 01:05 PM ---------- Previous update was at 01:03 PM ----------

Elixir, the length will be ultimately shortened with the leading zeros trimmed in the 3rd and 4th column.

itkamaraj · #7 10-23-2012

By adding zero, you can shortend the 3rd and 4th column

Code:

$ awk -v OFS=, 'NR>4{exit}{gsub("-"," -");print $1,$2,$3+0,$4+0}' input
00530083,0000000471,0,0
00530085,0000000471,0,0
00550002,0000000471,0,15
00550030,0000000471,0,-7.99

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

The Following User Says Thank You to itkamaraj For This Useful Post:
MIA651 (10-23-2012)