Script Num format help!

[hopkinsc]

Hi all,

i have the attached script, the period field is coming through ina  text format, so i am trying to change it to a num format in the script (so it links to other data correctly) but when i do that it doesnt load any values for the field.

I have commented out lines 72-80 which does the NUM change so you can see the text format working.

Any chance someone could take a look to see what i am doing wrong please?

[tresesco]

Try using trim() like:

Num(trim(Period))  as Period

[tresesco · Accepted solution]

In fact trim() alone should work, like :

trim(Period)  as Period

[hopkinsc]

nice one! thanks!