topic Remove in QlikView

Remove

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

HI All

How to remove a word from the field

That is There is a field (cloumn name ) "Product " in which the conetect is like

D5400

D23Mto

DMk344

I want to take out the first letter that is "D" and want to display the alphabets after D ?

and the result should be like this :

5400

23Mto

MK344... and so on

Re: Remove

marcus_sommer — Mon, 07 Mar 2016 06:40:08 GMT

Try: mid(YourField, 2) as YourField.

- Marcus

Re: Remove

MayilVahanan — Mon, 07 Mar 2016 06:40:45 GMT

Try like this

=If(Left(Product, 1) = 'D', PurgeChar(Product, 'D'), Product )

=If(Left(Product, 1) = 'D',Mid(Product, 2), Product )

Re: Remove

kaushiknsolanki — Mon, 07 Mar 2016 06:46:40 GMT

Hi,

Other option is

Right(YourField,len(Yourfield)-1) as NewField.

Regards,

Kaushik Solanki

Re: Remove

HirisH_V7 — Mon, 07 Mar 2016 07:45:17 GMT

Hi,

Check this,

SubField(Colo,'D',2) as Column

HTH,

Hirish

Re: Remove

engishfaque — Mon, 07 Mar 2016 07:49:56 GMT

Dear John,

Here is a Dynamic Data model,

ASCII Code

65 = A

90 = Z

97 = a

122= z

Table1:

LOAD *, If((Left(OldFieldValue, 1) >= Chr(65) and Left(OldFieldValue, 1) <= Chr(90)) or (Left(OldFieldValue, 1) >= Chr(97) and Left(OldFieldValue, 1) <= Chr(122)), Text(PurgeChar(OldFieldValue, Left(OldFieldValue, 1)))) as NewFieldValue Inline [

OldFieldValue

D5400

D23Mto

DMk344

D10

A1010

Z561

];

Kindly find attached QlikView App.

Kind regards,

Ishfaque Ahmed

Re: Remove

jagan — Mon, 07 Mar 2016 08:06:10 GMT

Hi,

Try like this in script

LOAD

Mid(Product, 2) AS Product_New

FROM DataSource;

Regards,

jagan.