Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
May be like this
LOAD ..., FROM .... Where SubStringCount(FieldName, '-') = 2;
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;
this statement fixed the issue
where wildmatch(fieldname, '*-*-*') > 0;
Thanks alot for help.