Scenario
When importing CSV Bank Statement files using the default parsers, users receive an Unexpected Error. This might be due to the Memo column having commas, semicolons or underscores.
Solution
A Microsoft Excel CLEAN function can help to efficiently check and remove all the nonprintable characters from string in the Memo column.
-
Open the Statement Files on CSV format.
-
On the file, since F2 is the first cell in the table that contains Memo, the formula should be =TRIM(CLEAN(F2))
-
Add this formula =TRIM(CLEAN(F2)) on an empty column.
-
Repeat the formula for the populated cells in Column F. Then copy the formula results and paste the special values to the populated cells in the column F.
-
Save the file and try to re-upload.