Hi Svetlana,
The file is a text file containing pipe or vertical bar, ascii character 124. The fields are fine but where the record contains a CR or LF in the record, the record is split in multiple parts as TM1 sees these as record terminators.
Product description field below shows issue:

Essentially TI would need to ignore CR or LF inside quotes, much the same way SQL, Excel etc. does otherwise I need a way to specify the record terminator i.e. CRLF or LF only or something else.
------------------------------
George Tonkin
------------------------------
Original Message:
Sent: Fri February 04, 2022 10:23 AM
From: Svetlana Pestsova
Subject: Change record terminator in TI
Hi George,
To understand this issue better what did you setup as youe source separator?
Best regards,
------------------------------
Svetlana Pestsova
IBM Planning Analytics Product Manager
Original Message:
Sent: Fri February 04, 2022 09:03 AM
From: George Tonkin
Subject: Change record terminator in TI
A left-field one today. I have not seen a way to change the record terminator in TI when dealing with flat files but hoping there is a way.
I have an issue where some of my data contains a Linefeed, Char 10 (Hex 0A).
Probably from an upload someone did from Excel where Alt+Enter was used to split the value across multiple rows for readability.
TI seems to pick up any of Hex 0A, 0D or 0D0A as a valid row terminator thus splitting the record into two and creating havoc.
Yes, this needs to be sorted in master data, at source but curious to know if there is a way to trap for this in TI or specify that 0D alone is the record terminator.
Short-term solution may be to use SED or Python to strip 0A's
Anyone have any ideas on how to change the row terminator?
------------------------------
George Tonkin
------------------------------
#PlanningAnalyticswithWatson