Source file contains double quote that results in error

[harrytm1]

Hi all,

I have a TI process that creates elements in the Material dimension. The source file is tab delimited.

The order of the columns are:
- Material Code
- Description
- Type

The TI was executed successfully and created more than 10,000 elements. However, on closer inspection, those Materials with a double quote in the Description such as " Diameter 3/8" " will get cause the rest of the fields (i.e. Type) and the subsequent roles to be joined together. Since Description is an alias attribute that is set up in Material dimension, the whole Description becomes very long since it is a concatenation of a few lines.

This long concatenation will only stop when it next encounters another double-quote.

I tried to define the delimiter by using the following in Prolog:
cTab = Char(9);
DatasourceASCIIDelimiter= cTab;

But the problem still persists. I'm using both TM1 10.1 and 9.5.2 FP2 and both are giving the same issue.

Please advise. Thanks!

harry

[Steve Rowe]

Have you tried setting the DatasourceASCIIQuoteCharacter=''; (ie null) and then managing the stripping out of the quotes yourself.

Can't see another way myself. The TI is always going to mess up if you have double quotes in a description
Cheers

[harrytm1]

Thanks, Steve! It works!