DSXchange

Thank you for your suggestions.
As this file comes to us from vendor via sFTP from mainframe I inserted additional step on mainframe to reformat input file and make it having the same record layout for all rows before sending to server for datastage.
toly

Hello, my incoming .csv file has embedded line breaks surrounded by double quotes. It looks like: Account|User ID|Notes 1234567|123456|"This is a test note on account 1234567." 2345678|123456|"Hello, this is Toly from ABC company. I am calling to let you know that we have registered t...

thank you so much, it resolves the issue

Hello,
I have the name formatted as Taylor,Kim and need to have it in the format Kim.Taylor.
I can use the field function to get the value (last name) before the comma, but I cannot figure out how I can get first name, i.e. substring after the comma.
Your help is appreciated very much.
Toly