String Function

[NavinReddy]

Hello Dear Experts,

i just want to exclude LOB with below listed files on listbox

please help me to get exact syntax

Thanks,

Niranjan

[swuehl · Accepted solution]

Maybe

=If( not FIELD like 'LOB*', FIELD)

or

=Mid(FIELD,5 )

depending on what you are trying to achieve

edit:

Or

=If(Left(FIELD,3)='LOB', Mid(FIELD,5 ), FIELD)

[#3]

Try with Replace function:

Trim(Replace(FieldName,'LOB ',''))

or you can use Sub Field function as well

Trim(sunfield(Fieldname,'LOB',2))

[Kushal_Chawda]

If( not wildmatch(Field, 'LOB*'),Field) as Field

[Anonymous]

Hi

Why not use purgechar(Field,'LOB') this will remove LOB and leave the rest of the string in tact.

Kindest Regards

Brian

[NavinReddy]

Hi Stefan,

Thanks for your reply its works for me

Best Regards,

Niranjan