Hello,

Did you try checking these fields?

Regards.

Yes, I have tried these. And as far as I can test, these only affect the values or empty spaces within specific columns. It doesn’t allow me to disregard or remove the entire row.

Function removes empty spaces either in the beginning of the column - or all empty spaces anywhere within the column.

The string ‘One string with space’ would give the result ‘Onestringwithspace’ using the ‘Skip All’ parameter.

Hello @GISANCAR 

You can use satisfy option to achieve this.

In my case, I have in first column the company ID and I have made the setting in following way.

Then imported the voucher and it is processed without problem

Another option using Skip with column separator. I am using comma (,) as separator and I made setup as below. This also process the upload without problem. You can enter semicolon (;) in your case and this should work.

Hope this helps 

@Furkan Zengin, thank you for the suggestion. I think I can make something like this work.

Reporting back that the suggestion to remove line based on position and character ‘,’ or ‘;’ works perfectly.

Import is now running smoothly for all users using the function.

@Furkan Zengin - Thanks for this!  I’ve tried every which way in the past to skip these blanks rows, unsuccessfully.  It took me a few tries to notice that it is leaving the Column No blank that did the trick, but once I finally saw that it works great.