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 mahipalc over 8 years ago

As per my understanding, making particular excel column as text type will work.
Before formatting the excel column to text type, make sure excel is empty(before you type the numbers in the cells), then enter data.
OR
Try: Format Cells--> Custom --> choose the option 0 ( i.e. under 'General'), then enter data into excel and read with smart service.

Another approach can be,
Instead of entering multiple phone numbers in a single column, create two or three columns in excel say "phone no1", "phone no2", "phone no3" and parse that excel. In process model before saving them in to table concatenate these 3 columns by some separator and save it in DB. This way we are restricting each column to have max 10 digits only.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mahipalc over 8 years ago

As per my understanding, making particular excel column as text type will work.
Before formatting the excel column to text type, make sure excel is empty(before you type the numbers in the cells), then enter data.
OR
Try: Format Cells--> Custom --> choose the option 0 ( i.e. under 'General'), then enter data into excel and read with smart service.

Another approach can be,
Instead of entering multiple phone numbers in a single column, create two or three columns in excel say "phone no1", "phone no2", "phone no3" and parse that excel. In process model before saving them in to table concatenate these 3 columns by some separator and save it in DB. This way we are restricting each column to have max 10 digits only.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data