Format/Reduce a Number

[harjedalskok]

Hi,

I wonder how i can format/reduce a "number" in load script.

PersonalID Has the format for example 7788991010 i would like in the script to reduce it to 778899

ive tries like

num(PersonIID, 'XXXXXX' ) as PID,

but it doesent work.

since my sollution didnt work, i would like to know how to reduce a values numbers within script.

Could anyone plz enlight me

Thx in advance.

[sunny_talwar · Accepted solution]

May be this

Floor(PersonIID/10000) as PID

or this

Left(PersonIID, 6) as PID

[Anil_Babu_Samineni]

May be do this?

Left(PersonID, 6) as PersonID_Copy

[harjedalskok]

Thx for fast reply.

This is now solved. I couldnt mark both answers as "solution".