Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

May be this

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

View solution in original post

3 Replies
Highlighted

May be this

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

View solution in original post

Highlighted

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

];

Highlighted
Partner
Partner

Thank you.. Works Perfectly.