Search Results

I have a delimited file (,) containing Name, Amount,Type,Address,zip,Tel and Extn. If any of this column information is missing (except TYPE and Extn),
I need to print that a spefic column value is...

That is true. it works... thanks for your help...

Thanks once again.. but this hungs

Thanks . it works for the data initially I provided.

But it doesn't work for the following since we "" not always at the end

input

123|""|789|654|""
987|786|"GRT
"|345|""...

Thats true. we may keep counting for 4 pipes and concatenate the broken line . but not sure how to code this in unix

---------- Post updated at 01:41 PM ---------- Previous update was at 01:38 PM...

Joeyg,

Lets assume a line should contain 4 pipe "|" characters

123|456|789|654|""
987|786|"GRT
"|345|""
3455|896|654|456|""
457|234|"RT"|"PR
TY"|""


123|456|789|654|""...

I need to concatenate the rows that are broken (because of carriage return and line feed) in unix.

Input

123|456|789|""
987|786|"GRT
"|""
3455|896|654|456|""
457|234|"RT"|"PR
TY"|""
...

I need to break the line after every 3rd semi colon(;) using Unix shell scripting

Input.txt
ABC;DEF;JHY;LKU;QWE;BVF;RGHY;

Output.txt
ABC;DEF;JHY;
LKU;QWE;BVF;
RGHY;