topic Re: Replace in QlikView

Replace

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts

I have data like below format, here my requirement is i want replace the '_' (last underscore) with '-' (hi-fen).

stalwar1‌omarbensalem‌youssefbelloum‌

My data like

Input

LUNG_GI_ATEZO

LUNG_GI_GI

LUNG_GI_LUNGA

LYT_STD

LYTHSM_STD

OCREView

O/P:-

LUNG_GI-ATEZO

LUNG_GI-GI

LUNG_GI-LUNGA

LYT-STD

LYTHSM-STD

OCREView

Regards

Mahesh

Re: Replace

YoussefBelloum — Thu, 22 Feb 2018 15:03:54 GMT

Hi,

try this:

Replace(Input,'_','-')

Re: Replace

sunny_talwar — Thu, 22 Feb 2018 15:07:14 GMT

This

Table:

LOAD *,

If(Index(Input, '_', -1), Left(Input, Index(Input, '_', -1) - 1) & '-' & Right(Input, Len(Input) - Index(Input, '_', -1) - 1), Input) as Output;

LOAD * INLINE [

Input

LUNG_GI_ATEZO

LUNG_GI_GI

LUNG_GI_LUNGA

LYT_STD

LYTHSM_STD

OCREView

];

Re: Replace

qlikview979 — Thu, 22 Feb 2018 15:08:44 GMT

Hi,

It will not give correct output.

here i want to replace only last underscore not all.

Re: Replace

qlikview979 — Thu, 22 Feb 2018 15:12:09 GMT

Hi Bro,

here after last _ first is missing its giving like

LYTHSM_TD

but i need LYTHSM_STD

Re: Replace

qlikview979 — Thu, 22 Feb 2018 15:13:57 GMT

may be it will work right

If(Index(Input, '_', -1), Left(Input, Index(Input, '_', -1) - 1) & '-' & Right(Input, Len(Input) - Index(Input, '_', -1) ), Input) as Output;

Re: Replace

Digvijay_Singh — Thu, 22 Feb 2018 15:15:48 GMT

Try this as well -

=Left('LUNG_GI_ATEZO',index('LUNG_GI_ATEZO','_',-1)-1)&'-'&Subfield('LUNG_GI_ATEZO','_',-1)

Replace string with the field name.

Re: Replace

sunny_talwar — Thu, 22 Feb 2018 15:16:47 GMT

Yes, you are right... this should work

Table:

LOAD *,

If(Index(Input, '_', -1), Left(Input, Index(Input, '_', -1) - 1) & '-' & Right(Input, Len(Input) - Index(Input, '_', -1)), Input) as Output;

LOAD * INLINE [

Input

LUNG_GI_ATEZO

LUNG_GI_GI

LUNG_GI_LUNGA

LYT_STD

LYTHSM_STD

OCREView

];

Re: Replace

qlikview979 — Thu, 22 Feb 2018 15:21:14 GMT

Yes bro, its perfectly working

you are master of Qlik

Regards

Mahesh