SQL Loader - Newline characters
Hi,
I have data file coming from a bank and I think it's having new line characters because the address field in the data is getting truncated when loaded into table the 86 record is loaded as
"/PT/FT/PY/8922615821MAY2012/BI/709991043/BN/ABC LIMIT " instead of my whole string.
And also my substr for column is also not populating, i think because of this new line character.
Data File:
:61:123456,35NTRFABC//12345
/CTC/MSC/FT INTERNAL
:86:/PT/FT/PY/8922615821MAY2012/BI/709991043/BN/ABC LIMIT
ED 10 XYZ ROAD,#03-01 CITY XYZ
01234
:61:123456,26NTRFABC//12345
CTL FILE:
-- Record Type 86: Information to Account Owner
INTO TABLE ce_stmt_int_tmp
I have data file coming from a bank and I think it's having new line characters because the address field in the data is getting truncated when loaded into table the 86 record is loaded as
"/PT/FT/PY/8922615821MAY2012/BI/709991043/BN/ABC LIMIT " instead of my whole string.
And also my substr for column is also not populating, i think because of this new line character.
Data File:
:61:123456,35NTRFABC//12345
/CTC/MSC/FT INTERNAL
:86:/PT/FT/PY/8922615821MAY2012/BI/709991043/BN/ABC LIMIT
ED 10 XYZ ROAD,#03-01 CITY XYZ
01234
:61:123456,26NTRFABC//12345
CTL FILE:
-- Record Type 86: Information to Account Owner
INTO TABLE ce_stmt_int_tmp
0