Text Format(Number To Number Format

[aveeeeeee7en]

Hi Community

I am not able to convert Text Format(Number To Number Format

Kindly see the Attachment.

Regards

Aviral Nag

[its_anandrjs]

Try Num function like

LOAD

NUM([Amount in local cur.])  as [New Num Field]

From Location;

[aveeeeeee7en]

Thanks for the Reply.

If it's that easy to crack than i would done this earlier.

NUM([Amount in local cur.])  Not working.

The data is some Text & some Number.

Sir, See the Attachment

[Anonymous]

Nag

I think it is as easy as to just do what  anand chouhan suggested.

Tab :

LOAD

num( [Amount in local cur.] )

FROM

[Num Problem.xlsx]

(ooxml, embedded labels, table is [April 2014 again]);

I have tested it against your *.xlsx using the script above and it works perfectly.  What kind of 'Not working' do you encounter ?

Best Regards,     Bill

[MK_QSL]

Use Evaluate function...

[aveeeeeee7en]

Total Records = 11426

When using num() function, i am getting 8221 Records

I want all 11426 to be in Number Format.

[Anonymous · Accepted solution]

Hi

I think I can see the joker, as in the large numbers have commas for lakh & crore as opposed to thousands and millions.  Removing the commas with purgechar() sorts this.

     num( purgechar ([Amount in local cur.] , ',' ) ) as NN ,

[aveeeeeee7en]

Thank You Bill Sir.

Sir I have tried with '1E100' for large numbers bu had no Luck with it.

I also like to to thank others who gave suggestions and their valuable time.