TM1 Forum

Hi ,
We have daily load files from SAP BW which the TI uses to load the data .

SAP BW send us a file with semicolon delimited and if there are any columns having semicolon in the value itself we have an issue putting it in right place .

We plan the file from BW to be '^' delimited to avoid this issue.

Have anyone faced similar issue and what was the solution .

Thanks,

Like you are suggesting, there are characters that are unlikely to be used in text fields and can be used as your separators but if you have free entry text fields you can’t guarantee a character won’t be used. You can enclose all fields in quotes and specify the quote character for the TI using datasourceasciiquotecharacter.

what if a column value has quotes in it , will this still work .