topic removing string in QlikView

removing string

Vishnu_murthy — Tue, 15 Feb 2022 11:16:09 GMT

input of table1:

abc.ltd,

xyz.limited,

asd.hsc,

ghj.mnc,

qwe.ltd,

lkj.oc

i need Resulting out like:-

abc,

ghj,

lkj,

xyz like ......

Marijn — Tue, 15 Feb 2022 12:30:18 GMT

Depending on whether you know exactly which strings you would like to remove, you can use a nested replace. You can formulate is like this:

replace(replace(Replace(input_field,string_A,’’),string_B,''),string_C,'')

This effectively replaces the strings by nothing. In your case this would look something like:

replace(replace(Replace(input_field,'.ltd',’’),'.limited',''),'.hsc','') etc...

MarcoWedel — Tue, 15 Feb 2022 20:23:42 GMT

table1: Load SubField(input,'.',1) as input From ...