Cut string value - start from forth position.

[retko1985]

Hello,

I have values like this:

99915986

999547

9998655

I need to cut first three positions, so my values will be:

15986

547

8655

Can someone help me with the code?

Thank you.

[kaushiknsolanki]

Try this,

Load Field as Original, Right(Field,Len(Field)-3) as Newfield

From xyz;

Update:

You can als0 use the Mid function.

Mid(Field,4,Len(Field)-3)

Regards,

Kaushik Solanki

[tresesco]

Or simply:

Mid(String, 4)

[shiveshsingh]

=mid(999547,4)

[qlik4asif]

Mid(Fieldname,4,Len(Fieldname)-3)