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,
Delimiter to be Used
-
- 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
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
-
- 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
what if a column value has quotes in it , will this still work .