Remove

[smilingjohn]

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

[marcus_sommer]

Try: mid(YourField, 2) as YourField.

- Marcus

[MayilVahanan]

Hi

Try like this

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

or

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

[kaushiknsolanki]

Hi,

Other option is

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

Regards,

Kaushik Solanki

[HirisH_V7]

Hi,

Check this,

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

HTH,

Hirish

[engishfaque]

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

[jagan]

Hi,

Try like this in script

LOAD

*,

Mid(Product, 2) AS Product_New

FROM DataSource;

Regards,

jagan.