Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be this
If(IsText(Left(Input, 1)), Mid(Input, 2), Input)
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
];
Thank you.. Works Perfectly.