Delimiter to be Used

Post Reply
manu0521
Posts: 39
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Delimiter to be Used

Post by manu0521 » Wed Mar 06, 2019 9:49 pm

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: 1608
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 » Wed Mar 06, 2019 10:31 pm

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.

manu0521
Posts: 39
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Re: Delimiter to be Used

Post by manu0521 » Thu Mar 07, 2019 1:07 pm

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

Post Reply