Question

Import CSV to Database Smart Service

Forum|Forum|11 months ago
August 18, 2025
7 replies
0 views

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?

stefanhelzle0001

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?

M

marcom0706Author

Hi Stefan,
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?

stefanhelzle0001

Trying to parse any kind of malformed data is just guesswork. Doing so will create edge case where your guessing fails. Then business will make you responsible for the failures.

If this is what you want, I can provide some ideas.

shubhama926776

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.

M

marcom0706Author

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?

Sign up

Login with SSO

Login to the community

Login with SSO