Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Scripting help required please

Good afternoon everyone,

I'm currently stuck on an issue with some data within a field in one of my tables. The field is named INDXFLD and is currently formatted to look like this:

  • 000047398F

The issue I have is I need to reformat it so the 'F' is at the beginning and the preceeding zero's are removed, it should end up looking like this:

  • F47398

Can anyone help me please, the number of zero's can change but it will always start with the first digit which isn't a zero.

Thanks is advance.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

something like this maybe: right('000047398F',1)&num(left('000047398F',9),'0')


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

something like this maybe: right('000047398F',1)&num(left('000047398F',9),'0')


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

it can be something like this ...

=right('000047398F',1)&''&num(left('000047398F',9))

Not applicable

^5 Gysbert

samvile18
Creator III
Creator III
Author

Excellent, thanks chaps...I appreciate the irony of two separate answers being the same!!