Split the Numbers from String value

[Anonymous]

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

[sunny_talwar]

May be this

Text(Mid(ActualValue, 2)) as OutputValue

[sunny_talwar · Accepted solution]

Sample attached

Table:

LOAD RowNo() as RowNum,

*,

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

LOAD * INLINE [

    ActualValue

    A123487978

    A124750067

    A124750067

    H041348923

    H041348923

    R041348923

    A41350698

    A41350698

    Z041350698

    R041348923

    H015599554

    H015599554

    A123487978

    Z041350698

];

[Anonymous]

Thank you. It's working.

[devarasu07]

Hi,

try like this

Data:

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

LOAD * INLINE [

    ActualValue

    A123487978

    A124750067

    A124750067

    H041348923

    H041348923

    R041348923

    A41350698

    A41350698

    Z041350698

    R041348923

    H015599554

    H015599554

    A123487978

    Z041350698

];