topic Re: String Function in QlikView

String Function

NavinReddy — Thu, 19 May 2016 12:15:32 GMT

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 — Thu, 19 May 2016 12:20:14 GMT

Maybe

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

=Mid(FIELD,5 )

depending on what you are trying to achieve

edit:

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

Thu, 19 May 2016 12:20:42 GMT

Try with Replace function:

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

or you can use Sub Field function as well

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

Kushal_Chawda — Thu, 19 May 2016 12:23:54 GMT

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

Anonymous — Thu, 19 May 2016 12:24:43 GMT

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

Kindest Regards

Brian

NavinReddy — Thu, 19 May 2016 12:55:21 GMT

Hi Stefan,

Thanks for your reply its works for me

Best Regards,

Niranjan