Delimiter to be Used

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Delimiter to be Used

Post by manu0521 »

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,
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Delimiter to be Used

Post by declanr »

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.
Declan Rodger
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Re: Delimiter to be Used

Post by manu0521 »

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