Load qvd file with filtered values

[shani]

Hi,

I have a data where i need to load a filtered values , the file has more than 1 million rows. 

The file have values in this format

1234

12345

1234-123-12

12335-123-12

i want to import all values with this format 1234-123-12 and 12345-123-12 

How do i do that?

[sunny_talwar]

May be like this

LOAD ...,
FROM ....
Where SubStringCount(FieldName, '-') = 2;

[Colin-Albert · Accepted solution]

This looks for data with the format xxxxx-xxx-xx or xxxx-xxx-xx
If the number of characters doesn't matter then you can use  wildmatch(FieldName, '*-*-*') > 0

LOAD ..., 
FROM .... 
Where wildmatch(FieldName, '?????-???-??') > 0 or wildmatch(FieldName, '????-???-??') > 0;

[shani]

this statement fixed the issue

where wildmatch(fieldname, '*-*-*') > 0;

Thanks alot for help.