jimmymac
Reputable Poster
We are on E1 9.0, tools 8.98.42.
We have a new table conversion that reads in a comma delimited file and writes entries to the F0411Z1 and F0911Z1. We do this alot, but this particular new TC is having an issue.
Its set up to receive a comma delimited file. The csv file is saved by another process and the values in the file are comma delimited but also have double quotes around most of the values. If we save the file and force it not to have quotes the TC works. But if we leave the quotes in, the TC errors out with the error - Value "1103 of column Vendor Number exceeds length in colunn definition.
The vendor number in this case is 1103704, and in the incoming file is actually "1103704". There is an option in the TC Textual Qualifier to choose Double Quotation which I thought would allow it to recognize these quotes and ignore them but it still fails.
Any suggestions or anyone with experience dealing with quote marks coming in through a TC using comma delimited?
We have a new table conversion that reads in a comma delimited file and writes entries to the F0411Z1 and F0911Z1. We do this alot, but this particular new TC is having an issue.
Its set up to receive a comma delimited file. The csv file is saved by another process and the values in the file are comma delimited but also have double quotes around most of the values. If we save the file and force it not to have quotes the TC works. But if we leave the quotes in, the TC errors out with the error - Value "1103 of column Vendor Number exceeds length in colunn definition.
The vendor number in this case is 1103704, and in the incoming file is actually "1103704". There is an option in the TC Textual Qualifier to choose Double Quotation which I thought would allow it to recognize these quotes and ignore them but it still fails.
Any suggestions or anyone with experience dealing with quote marks coming in through a TC using comma delimited?