You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Integration: How to escape ";" in SPLIT() Function

edited Sep 13, 2025 12:00AM in EPM Platform and Freeform 3 comments

Dear Experts,

We have configured Data Integration that loads a CSV file with transaction data into FCC. The CSV file uses a semi-colon (;) as a column delimiter - semi-colon is defined as Delimiter within the File Import File options.

CSV file contents:

Year;Period;Account;TP;PC;CC;Amount

2025;11;A1111;15;P1010;;10.0

2025;11;A2222;16,P2020;;11.1

2025;11;A3333;;;C1010;12.1

2025;11;A4444;;;C2020;13.1

For the import into Source Custom2, we need to check against the CC and PC columns. If CC is present in the CSV file, then import it; otherwise, check if a PC exists. If PC is present, then import it. If neither is present, write N/A in Source Custom2.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!