execute failed: new line in quoted string (or closing quote missing)

I need to read several files that contain either a single quote (‘) or double quotes(’) as part of the information in its lines, but when trying to do so, I get the error “execute failed: new line in quoted string (or closing quote missing)”. This makes sense because the information in the lines it’s not meant to be “quoted”, instead, is something like this:


What I’ve been doing so far is to open each file and remove all quotes (single and double). Is there a way to read all those txt files without manually preparing them first?

Thank you KNIME community!

Could you share the lines of text as per the image in a workable format? For me lines with single and double quotes in the same file load fine in the complex file reader.

The Quote support page under Advanced might help you out here:

2 Likes

Hi ArjenEX, here’s a few lines as example:

FK37433S-3743374-3745I AS33SC 374.374299" CR-SI VSQW SUPERCLEAN YANK R VCS 153.316 272.97254 41,851.3746
FK37433S-37435-374374I AS-33SC .374354"Cr-Si VSQW Superclean YANK R VCS 13746.596 227.48727 24,249.23
FK37433S-37454-3745P AS-33SC .37454 CR-SI VSW SUPER CLEAN YANK R VCS 12.374374374 237.4374446 2,848.85
FK37433S-37463-3745P AS-33SC .374625 CR-SI VSW SUPER CLEAN YANK R VCS 546.587 227.21223 124,191.25
FK37433S-37469-2374P AS-33SC .37469" CrSi Valve TOING Wire HLDX R VCS 12374.374374374 115.47152 13,856.58

Let me know if this is enough and thank you for your help

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.