Export Field Column Possible?

[FrankBradley]

we are currently reading a standard CSV file which contains records that are to be loaded into a client screen and the some fields taken from the entry screen and export back into a transaction file with the original record and the added captured fields.

below is a section of code that is constructing the information to be exported back out.


Start Loop "38" Times
If $Counter$ Equal To "1" Then
Variable Operation : $Filedata Column($Counter$)$ To $Clipboard$
Else
Variable Operation : $Clipboard$,$Filedata Column($Counter$)$ To $Clipboard$
End If
End Loop

Variable Operation : $Clipboard$,=====,$CustomerNumber$,$SalesOrder$,$P ONumber$ To $Clipboard$
Log to File: $Clipboard$ in "c:\csp\lead_$SalesOrder$.txt"

Now the above could appears to work except that no string information is exported into the log file.

The read portion that appears at the top of the script is a simple

Read From CSV file : '$InImportFileName$' Delimiter: 'Comma' Header: 'No'

which is followed by

Start Loop " Each row in a CSV/Text file"
Variable Operation : $Filedata Column(1)$ To $InCustomerEmail$
.......
End Loop


and we move the $Filedata Column()$ into specific variable names for processing further down in the script.


So any ideas why the build process would not provide the string values

[forumsupport]

Hello,

Unfortunately, you cannot use variable for Filedata Column index, $Filedata Column($Counter$)$. However, if you can upload your task then we can look into it and suggest the viable work around.

You can locate your task by selecting your task from Task List, right clicking that particular task and selecting 'Locate on disk' from context menu. Otherwise, you can also send text format of task. For that, open your task in a Task Editor, go to Tools->Save as text file and send this text file.

It would help us investigate further.