This content has been marked as final. Show 2 replies
Your requirement is very unclear.
Is this your INPUT ?
Is this your OUTPUT?
--record 1 32 grand street ~NY~NY --record 2 42 riverdrive, --"NL" apt 1B ~PL~TX --record 3 Richardson road --"NL" apt 32~ SF ~CA
Are you using Linux or Windows platform?
ADDRESS CITY STATE 32 grand street NY NY 42 riverdrive, null null apt 1B PL TX Richardson road null null apt 32 SF CA
You should have only one record terminator character.
*\r\n* is Windows The End of Line character (The Carriage Return + The Line Feed).
"STR '\r\n'" = "str X'0D0A'"
If there is no data after \r\n, columns will be null.