Error in "Split delimited text into rows" with space separator

Support
1

Hello,

When I try to use a Split delimited text into rows" transformation with space separator I have this error "
Error: Object reference not set to an instance of an object.
Source: action “Split delimited text into rows”, module “Main”, table “id-uri de filtrat(2)”
"
(see attach)

11
Screenshot 2019-10-03 at 16.35.11.png943×872 25.6 KB

I use in several projects this transformation and not in all I receides this error but with input data attached I got the error.
test split.csv (830.5 KB)

I get this error in EasyMorph 3.9.4.10 and also in 3.9.9.35.

What can I do ?

Best regards,
Radu.

2

@sradum, can you please send the project and the file to our support? Thanks.

3

@sradum, this error is caused by a double quote in line #11277:

TESTAMENTUL LUI VASILE POSTEUC?? NICU IANCU 1997 SUA MISCAREA LEGIONARA "OMUL NOU

It seems like a bug from our side. We are planning to investigate it further and fix it.

For now, the possible workarounds are:

  • Turn on "Ignore quoting" option
  • Filter out lines that have only one double quote (or even number of double quotes?) or add a single double quote to the end of such lines
1 Like
4

Hi @sradum,

The bug has been fixed. Please get the updated Desktop and Server versions from our download page.

Have in mind, that all the separators between double quotes or between a double quote and text end will be treated as common characters and imported as text.