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
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.
Hi,At the moment, I have asked the person who generates the file to check it, but do you have any other solutions? I tried using the readlinesfromtextfile function, which has been deprecated. Unfortunately, it does not recognise accents and apostrophes. Do you have any other solutions?