Hi,
I am trying to import a CSV file, but I receive this error "java.lang.IllegalStateException: (line 76) invalid char between encapsulated token and delimiter". The CSV file has an open quotation mark but no closing quotation mark, and my separator is ‘##’. How can I get around this problem? Is it possible to insert some escape characters?
Discussion posts and replies are publicly visible
Trying to work with a malformed CSV file is a problem in general. Can you try to convince the generating party to correct this mistake?
I would recommend asking the source to fix this problem if importing CSV files is a recurring activity in Appian. Otherwise, you need to consider implementing a preprocessing activity.