lines are deleted because of extra delimiters

[Abdelrahmanmahdy]

Hi All,

I have a CSV file from SAP with | delimiter and When I insert it there are two lines are deleted because of the extra delimiters.

see below three lines, two are affected and the middle one are correct.

| Z5 |Ind. Not. NCC |B10-3|K25|Z00 Alux final account | 927.629,00 |40PO-60028.P.01.03.10|03.10 Main Steelstructure |EUR

| Z5 |Ind. Not. NCC |Due to bad performance Alux NPP | 124.504,00 |40PO-60028.P.01.03.10|03.10 Main Steelstructure |EUR

| Z5 |Ind. Not. NCC |B10-3|K25|Z00 Alux final account | 124.504,00-|40PO-60028.P.01.03.10|03.10 Main Steelstructure |EUR

You can see in the attached image the result from Browse.

[messi007]

@Abdelrahmanmahdy ,

I used the configuration below and it works fine.

Could you share a sample data instead of a screenshot?

Best regards,

[Abdelrahmanmahdy]

You can find a sample of the file.

[messi007]

@Abdelrahmanmahdy,

Below how you do that :

Attached the workflow.

Regards,

[Qiu]

@Abdelrahmanmahdy 
I use the \t (tab) as delimeter and I think I have pulled the data in just ok.
The number of record seems to be correct also.

[Abdelrahmanmahdy]

the two required lines are shifted from the other lines. see the attached image 

@messi007