Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
malimohammed
Partner - Contributor
Partner - Contributor

Remove first character if Alphabet

Hi guys,

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

  

InputDesired Output
E02-02-NEW02-02-NEW
E02-32-E02-32-E
E0505
0707
1 Solution

Accepted Solutions
sunny_talwar

May be this

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

View solution in original post

3 Replies
sunny_talwar

May be this

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

sunny_talwar

Got this

Capture.PNG

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
Partner - Contributor
Partner - Contributor
Author

Thank you.. Works Perfectly.