Conditional load

[volakakis]

Hi guys

I have a problem. I have to load an weird excel file in which the column A has got some unique ID codes (either 2 digits or 7 digits).

Is there a way to load only the rows that have got 7 digits?????? (or to ignore the lines with 2digit ID)

Thank you in advance and wishing you a happy new year

[MK_QSL · Accepted solution]

Load * From

FileName

Where Len(ID) = 7;

[volakakis]

Thank you very much. quick answer and spot on !!!