Phone numbers converted to scientific notation with Parse Excel Spreadsheet to CDT

siddharthm over 8 years ago

#Plug-ins

Hi All,
I am using Parse Excel Spreadsheet to CDT smart service . I have a CDT that has a column 'Phn_Number' (type : string). In the excel I have a column 'Phn_Number'. In this column I am entering numbers whose length can be upto 20(say 9165432101,918012013298). While reading these values in the process model using the Parse Excel Spreadsheet to CDT smart node, the numbers are getting converted to exponential values (9.165432e+09, 9.18012e+11) . I am formatting the cells in the excel to Number(with Decimal places 0). How do I overcome this ? I need to retain the same values that are being uploaded in the excel sheet.
Thanks..

Discussion posts and replies are publicly visible

Parents

0 Jaggu over 8 years ago

Hi All,
I tried
1. "Format Cells--> Custom --> choose the option 0 ( i.e. under 'General'), then enter data into excel and read with smart service."
2. "fixed(todecimal(ri!value),0,true)" , but none of them are working for my requirement. And its not possible to split number as its coming directly from system and manually splitting string (like 5454874-864578) will consume much time.
DO we have any alternatives?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jaggu over 8 years ago

Hi All,
I tried
1. "Format Cells--> Custom --> choose the option 0 ( i.e. under 'General'), then enter data into excel and read with smart service."
2. "fixed(todecimal(ri!value),0,true)" , but none of them are working for my requirement. And its not possible to split number as its coming directly from system and manually splitting string (like 5454874-864578) will consume much time.
DO we have any alternatives?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data