This content has been marked as final. Show 4 replies
I'm guessing that this is a delimited file with | as the delimiter. If the 2~, 3~, etc are the amounts, they will not read as they are not numeric.
Without knowing exactly what your source file is and your import format it's difficult to answer.
Is the file delimited or fixed format
Can the source file be saved without the ~
You could write a script to pull only the number when importing.
If you were to completely review the 'Import Log' you will notice a legend/key at the top of the screen.
It states that TC was a Type Conversion done on your behalf... but the result was 'NN' (Non-Numeric)
What ever you told the 'amount' field to be, was not an integer.
I would perceive that it is related to your delimiter of ~| as FDM only supports as part of the pre-defined import formats, a single character delimiter.
You will probably need to use some alternative forms of scripting at the import stage to retrieve what is needed.
Did you find a solution to your problem??
I have the same one. The format is delimited/comma. And the file format is CSV (comma delimited). I do not understand the reason of the problem.
Thanks in advance for your cooperations.
If your file is CSV delimited, then you should not have the same issue if everything is setup appropriately.
The issue for the person above is related to a two-character delimiter when FDM is a one-character delimiter. Meaning the ~ of the | but not the combination of the both ~|