Search Results

THANKS a lot DON!! The code works perfect & gives the expected result.

In the below file you can see the 5th field (red color) is having the funny characters & that is splitted in multiple lines.

Input File:
"ID1" "ID2" "ID3" "RD" "NUM" "DATE" ...

Hi Don,

Please find the answers for your queries below:

Are input lines starting with Record supposed to be copied to the output?
Can <newline> characters appear in any field other than...

Hi DON,

Thanks for you reply. It helped me a lot. But that is not working for one scenario. If that corrupted records is splitted into 3 lines (as mentioned in example) then it is removing the...

Hi DON,

We need to remove the entire field if it contains any funny characters. we dont need to maintain the numeric characters in that field if it contains funny characters. So the output of the...

Thank you for 4 looking this post.

We have a tab delimited file where we are facing problem in a lot of funny character. I have tried using awk but failed that is not working.
In the 5th field...