Wildmatch during Data Load

[kavieweg]

Hi Guys,

I have a table and only will load specific Data.

ATABC123456789 - do not load

DE123456789969 - do not load

DEABC123456789 - load: any DE [A-Z] *

DEBGW38393838 - load: any DE [A-Z] *

Can anyone help me with the WildMatch ?

Regards

Mathias

[tresesco]

Try like:

Where Left(Field,2)='DE' and FindOneof(Mid(Field,3,1), 'ABCD...Z')

Fill up the dots and try.

[kavieweg]

Hi,

i will try this, but is there no option with Wildmatch? Can I als say "any Character" instead of ABC....Z ?

[tresesco]

'any character' - is '*' . But you perhaps need 'any alphabet' instead, and that can't be referred directly.

[kavieweg]

Yes, any alphabet or no numbers 🙂

[tm_burgers]

could also try:

the cases where the character in question is a letter would return null, whereas if it is a number it will be not null?

Where Left(Field,2)='DE' and ISNULL(Mid(Field,3,1)*2)