topic Re: Scripting help required please in QlikView

Scripting help required please

samvile18 — Tue, 23 Apr 2013 12:47:45 GMT

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.

Re: Scripting help required please

Gysbert_Wassenaar — Tue, 23 Apr 2013 13:04:46 GMT

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

Re: Scripting help required please

Tue, 23 Apr 2013 13:06:35 GMT

it can be something like this ...

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

Re: Scripting help required please

Tue, 23 Apr 2013 13:07:15 GMT

^5 Gysbert

Re: Scripting help required please

samvile18 — Tue, 23 Apr 2013 13:09:03 GMT

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