Search Results

So much thanks Chubler_XL !!!!

---------- Post updated at 07:56 PM ---------- Previous update was at 07:29 PM ----------

Can I use printf in this awk to pad my variable 'n' counter???

...

Need help. I tried using an awk command to pad zeroes. Unfortunately, the "|" pipe delimited character is gone when I tried to write the records to another file.


awk -F \| ' {$1=sprintf("%06s",...

This is my desired output and I cannot get it to work.


"KEYRECORD"|"SA ID"|"PER ID"|"SP ID"|"ACCT ID"|"PREM ID"|"PHONE"|"NA
1|" "|" "|"3197691605"|" "|"3197691657"|"...

Thanks for the reply! Everything worked!

This time I have to check first if $4 is blank or not. Then create a new record key if $5 does not match the previous value.


My problem right now is...

I am a newbie to shell programming and maybe somebody can help me out a little. Here's my problem:

I got a PIPE delimited file with header record. I need to add a new column name as RECORDKEY. I...