Flat File Importer Error - Number of Columns Doesnt Match

0
Hi – I’ve downloaded and am trying the flat file delimited import from the app store https://appstore.home.mendix.com/link/app/429/. I load the file to Queue and keep getting the error, “Number of columns does not match defined columns” … I’ve double-checked my import definition and actual file, and they both have the same number of columns. Anywhere else I can check?
asked
4 answers
0

Hello SL,

Have you opened the file in notepad? 

Sometimes you might have a comma at the end of each row which turns the empty space at the end of a row into an additional column.

Hope this helps

answered
0

Thanks for that idea; unfortunately, I don’t see an extra character at the end of the row. My delimiter by the way is ^

answered
0

As a regex is used for the splitting of columns you’ll need to escape the ^ character with a backslash.

So make sure to use the following delimiter: \^ in stead of only ^

answered
0

Is there any other solution besides /^? Thanks

answered