topic Re: Separating feild in QlikView

Separating feild

Anonymous — Tue, 18 Jun 2013 13:46:47 GMT

hi,

i have feild like this 015821 for exm.

i need to make a new feild with the 5 position from left, in the exm the feild will show the num 2.

how do i make it ?

thanks'

yarin.

shree909 — Tue, 18 Jun 2013 13:50:54 GMT

Hi u can use the Left, right or mid functions to create a new field.

if u want 5 postions from the left u can use Left(fieldname,5)

jvitantonio — Tue, 18 Jun 2013 13:51:14 GMT

Hi, use this:

MID(Field, 5,1)

I hope this helps.

Anonymous — Tue, 18 Jun 2013 14:51:13 GMT

Hi,

TRY THIS

mid('015821',5,1 ) returns '2'.

Should work fine.