fab23a5f-5f0b-41fd-a29a-2567279b123d.jpg

UiPath MVP/ RPA Solution Architect

0e2db6ec-8ade-4ce8-afbd-dbcbb0e2a0bc.nupkg

Different countries use different number formatting standards. In order to convert numbers to these formats, finding the best suitable method would be time consuming. Additionally, for calculation purposes, these formatted numbers should be converted into software supported data types such as Double or Int for processing. Such conversion would usually take place by either replacing thousand separators and decimal separators or by following a different approach such as the use of CDBL function of vb.net. However, these approaches do not support all the world recognized number formats and would require some amount of error handling to convert the numbers accurately when handling multiple number formats.

  

This package is formed of two activities:

*   Activity that allows the user to seamlessly convert any number to any world recognized number format.
*   Activity that converts any formatted number to software supported number format such as Double.  
    

The supported number formats are as follows:

*   fr-FR - # ### ###,00
*   en-US - #,###.##
*   en-IN - #,##,##,###.00
*   de-DE - #.###.###,00
*   ja-JP - #,###,###.00  
    

The activity that converts the number to this format would require two inputs. The number to be converted and the format that the number should be converted to. The required format should be mentioned as listed above. For example: format should be given as "en-US". By default, it converts the number to "en-US" format. If the user wishes to convert to a different format, the required format should be provided.

  

The activity that converts any formatted number to software friendly Double format accepts any format. This includes formats that are not listed above as well. The activity that converts formatted numbers to Double require two inputs. The formatted number and the decimal separator that is used in the format. Since different countries use different decimal and thousand separators, it is important that we provide the decimal separator so that the code behind knows how to accurately convert the number. The code behind handles this conversion through a series of error checkings to make sure the final output is accurate.

  

Error messages to know of for removing formatting:

*   The provided Decimal Separator does not exist in the current number format.
*   The provided Decimal Separator does not match with the current numeric format.
*   Failed to convert the formatted number to Double (Critical error).  
    

If either of the first two error messages pops up, make sure you have provided the correct inputs for the activity that converts the formatted number to Double.

  

No prerequisites are needed to use this activity.

Two activities that support the conversion of numbers to any internationally recognized format and remove the formatting of any formatted number.

c8e9b3a1-a1c8-4238-b41f-d78ee8a16ef3.PNG

6d224af7-a18e-455c-939d-4098f10cb54c.PNG

e63d174b-d795-4f64-8938-ee4d6dbdc823.PNG

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Number Formatting