Remove first character if Alphabet

[malimohammed]

Hi guys,

I have a requirement in which I need to purge character of a field value if the first character is an Alphabet.

Input	Desired Output
E02-02-NEW	02-02-NEW
E02-32-E	02-32-E
E05	05
07	07

[sunny_talwar · Accepted solution]

May be this

If(IsText(Left(Input, 1)), Mid(Input, 2), Input)

[sunny_talwar]

Got this

Using

Table:

LOAD *,

If(IsText(Left(Input, 1)), Mid(Input, 2), Input) as DesiredOutput;

LOAD * INLINE [

    Input

    E02-02-NEW

    E02-32-E

    E05

    07

];

[malimohammed]

Thank you.. Works Perfectly.