Question
Accenture
IN
Last activity: 19 Sep 2019 16:13 EDT
Convert Amount into continuous Numeric value
Hi All,
I have a requirement to convert Amount associated with Currency($) and Comma(,) into continuous numeric value.
For Ex:
Input - $150,000 Output - 150000
Input - $12,000,000 Output -12000000
Is there any OOTB function to achieve above requirement? Appreciate your help
Thanks in advance
Pegasystems Inc.
US
Can you provide some context for this problem? This post is tagged as Reporting, are you trying to retrieve a text value representing a currency amount as a numerical value in a report?
Pegasystems Inc.
US
You can use OOTB - replaceAll,pxReplaceAllViaRegex functions, but you need to first convert the input type to string since these methods expect input as String.
Pegasystems Inc.
US
If this is a string stored in a database column, and you are trying to convert it for a report, you can define an SQL Function Alias using the SQL REPLACE function:
REPLACE( REPLACE( column_name, ',', '' ), '$', '' )