• State Not Answered
  • Replies 7 replies
  • Subscribers 7 subscribers
  • Views 7065 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

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

siddharthm

#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..

OriginalPostID-178323

OriginalPostID-178323

  Discussion posts and replies are publicly visible

Parents
  • 0
    Yes..I have gone through the forum where some of the users have faced a similar issue. I have seen a few posts where the function called fixed has been recommended. Even I have tried using the same function ,but I am not getting the desired output. For example if I use the expression : fixed(todecimal(ri!value),0,true), the input ri!value is getting passed as 9.165432e+09 (which is the output obtained from the smart service). The output of the above expression gives me the value 9165432000 which is not the actual phone number (9165432101) provided by the user in the excel sheet.

    Is there any alternate function/expression which will solve this problem ?
Reply
  • 0
    Yes..I have gone through the forum where some of the users have faced a similar issue. I have seen a few posts where the function called fixed has been recommended. Even I have tried using the same function ,but I am not getting the desired output. For example if I use the expression : fixed(todecimal(ri!value),0,true), the input ri!value is getting passed as 9.165432e+09 (which is the output obtained from the smart service). The output of the above expression gives me the value 9165432000 which is not the actual phone number (9165432101) provided by the user in the excel sheet.

    Is there any alternate function/expression which will solve this problem ?
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.