I am writing text to a text file and I need it in a precise format so that it can be read in by another tool. Here is my script:
Table:
LOAD * INLINE [
ID, FullName
ID1, FullName1
ID2, FullName2
];
Table2:
LOAD * INLINE [
NewField
];
for a = 0 to NoOfRows('Table')-1
CONCATENATE (Table2) LOAD
Replace(Replace(Add,'*',peek('ID',$(a),'Table')),'%',peek('FullName',$(a),'Table')) as NewField
FROM AddTemplate.txt (txt, codepage is 1252, embedded labels, delimiter is '~', msq);
next
store Table2 into sampleOutput.txt(txt);
I need to store the values in Table in the somewhat complicated format outlined in the AddTemplate file. I have replaced the * in the template with the ID in Table, and the % in the template with FullName in Table. That's what that double replace line does.
If you run this script, you'll see I get the correct output if you go to the data model and Preview Table2. However, if you go to the sampleOutput.txt you'll see that we got double quotations around one of the lines. This probably has to do with '=' or ',' signs in that line of the template.
I need those quotations to go away in the text file... Does anyone have any ideas?
