Search Results

Thankyou :) nawk worked for me. Thanks for the help.

I'm using Solaris 5.10.
Where to put ; ?
I don't see ; in your script

---------- Post updated at 03:05 AM ---------- Previous update was at 03:02 AM ----------

awk -F',' '
> FNR>1 ...

Sorry, corrected row 2 now.

---------- Post updated at 02:47 AM ---------- Previous update was at 02:35 AM ----------

cat file
RXOCF-101,BTS INTERNAL,FAULT CODES CLASS 2A,53,58
RXOCF-101,BTS...

In line 2, "2B" is the substring of column 3 and "24" comes from column 4.
It's the concatenation of substring of column 1, substring of column 3 and with code in column 4

Don't have $6 in original file. Corrected it. Printing till $5 now

I am printing Col1,Col2,Partof(Col1)_Partof(Col2)Col4

if Col4 is null then the output is just like as above in my row 3,4 and 5 (last columns with no code)

2A53 comes from:

2A is part of...

I am working on a file with several columns as below

MO_NAME,FAULT_TYPE,CLASS,CODE1,CODE2,CODE3
RXOCF-101,BTS INTERNAL,FAULT CODES CLASS 2A,53,58
RXOCF-101,BTS INTERNAL,FAULT CODES CLASS 2B,24...