topic Re: Split the Numbers from String value in QlikView

Split the Numbers from String value

Anonymous — Mon, 23 Oct 2017 17:19:16 GMT

Hi Team,

I have data set like as below, I want to exclude the First position of my "Actual Value" if it is Character and store the remaining Numbers in a another Column(Output Value).

Actual Value	Output Value
A123487978	123487978
A124750067	124750067
A124750067	124750067
H041348923	041348923
H041348923	041348923
R041348923	041348923
A41350698	41350698
A41350698	41350698
Z041350698	041350698
R041348923	041348923
H015599554	015599554
H015599554	015599554
A123487978	123487978
Z041350698	041350698

Can any 1 suggest me the solution for that.

Regards,

Shakila D

Re: Split the Numbers from String value

sunny_talwar — Mon, 23 Oct 2017 17:23:22 GMT

May be this

Text(Mid(ActualValue, 2)) as OutputValue

Re: Split the Numbers from String value

sunny_talwar — Mon, 23 Oct 2017 17:26:16 GMT

Sample attached

Table:

LOAD RowNo() as RowNum,

Text(Mid(ActualValue, 2)) as OutputValue;

LOAD * INLINE [

ActualValue

A123487978

A124750067

H041348923

R041348923

A41350698

Z041350698

R041348923

H015599554

A123487978

Z041350698

];

Re: Split the Numbers from String value

Anonymous — Mon, 23 Oct 2017 17:27:07 GMT

Thank you. It's working.

Re: Split the Numbers from String value

devarasu07 — Mon, 23 Oct 2017 17:33:54 GMT

Hi,

try like this

Data:

load *,Left(Right(ActualValue,Len(ActualValue)-1),Len(ActualValue)-2) as Revised;

LOAD * INLINE [

ActualValue

A123487978

A124750067

H041348923

R041348923

A41350698

Z041350698

R041348923

H015599554

A123487978

Z041350698

];