Compare text variables with whitespaces

wittgenstein

Hi,

is there something like a LIKE operator in C/AL?

I want to do this:

'ABCDEFG' LIKE 'ABCD*' => true
'ABCDEFG' LIKE 'AB?DEFG' => true
'Test' LIKE 'Test*ing' => false
'Testing' LIKE 'Test*ing' => true
'Teststring' LIKE 'Test*ing' => true
'Tasting' LIKE 'Test*ing' => false
...

Any ideas on how to do this?

Thanks in advance.

Slawek_Guzek

Hi,

C/AL way (works in all NAV versions):

You can define in memory table variable, any table which includes Text250 column (T15 G/L Account having Totalling Text250 column will do), insert your text into that field, insert the record, set the 'like' filter on the text field and use any of FIND* functions.

TempGLAcc."Totalling" := MyText;
TempGLAcc.INSERT;
TempGLAcc.SETFILER("Totalling", 'Test*ing');
result := TempGLAcc.FINDFIRST;

The limitation is obvious - you can only compare texts up to 250 character long

'Non C/AL':

Use the .NET System.Text.RegularExpressions.Regex ? (Never tried it myself)

Slawek

Slawek_Guzek

Hi,

C/AL way (works in all NAV versions):

You can define in memory table variable, any table which includes Text250 column (T15 G/L Account having Totalling Text250 column will do), insert your text into that field, insert the record, set the 'like' filter on the text field and use any of FIND* functions.

TempGLAcc."Totalling" := MyText;
TempGLAcc.INSERT;
TempGLAcc.SETFILER("Totalling", 'Test*ing');
result := TempGLAcc.FINDFIRST;

The limitation is obvious - you can only compare texts up to 250 character long

'Non C/AL':

Use the .NET System.Text.RegularExpressions.Regex ? (Never tried it myself)

Slawek

wittgenstein

Hi Slawek,

thanks. I will try it with RegEx as I dislike the 250 character limitation on the other solution.