question how to get currency2 value without including the currency symbol in SPM forum

how to get currency2 value without including the currency symbol

daikhi haithem — Mon, 05 Feb 2024 10:40:24 GMT

Hello

i want to know how to get currency2 value without including the currency symbol

"EUR;10"

Re: how to get currency2 value without including the currency symbol

Weird — Mon, 05 Feb 2024 10:47:06 GMT

Depending on the context you could do some other things, but just for that example lets say your currency is stored in variable "currency".
You could just try something like this

var currency = "EUR;10"; var price = currency.split(";")[1]; gs.info(price);

Here we have the currency value stored in a variable and we use split(";") to create an array or currency where each value is separated by the semicolon. This results in an array like ["EUR","10"]. By adding [1] we tell that we want the value in second index, which would be the actual numerical price.

If you have a currency symbol in the resulting value, you can also use .substring(1) to remove the first character.
So for example €10 would become 10.

Re: how to get currency2 value without including the currency symbol

daikhi haithem — Mon, 05 Feb 2024 12:14:57 GMT

I thought there was a JavaScript method to do it directly because I'm looking for the best practice to build my code

Re: how to get currency2 value without including the currency symbol

Weird — Mon, 05 Feb 2024 13:12:56 GMT

Well, it depends on how you're getting the price. I assumed you had the currency as a string, but if you have the currency field, then there are few things you can do.
Below's a list of scripts and their results.

Price 88USD and script run as user who sees euros. current.price: 80.86 current.price.getReferenceCurrencyCode(): USD current.price.getReferenceDisplayValue(): USD88.00 current.price.getReferenceValue(): 88 current.price.getSessionCurrencyCode(): EUR current.price.getSessionDisplayValue(): €80.86 current.price.getSessionValue(): 80.86 current.price.getCurrencyCode(): USD current.price.getCurrencyDisplayValue(): USD88.00 current.price.getCurrencyString(): EUR;80.86 current.price.getCurrencyValue(): 88

Re: how to get currency2 value without including the currency symbol

daikhi haithem — Mon, 05 Feb 2024 15:01:52 GMT

Great, thank you! 😉

And for setting a field, like I have in this example,

For the first field, this is working correctly for me:

current.fieldName.setDisplayValue('EUR;'+Variable);

Is it the same thing for the second field?

Re: how to get currency2 value without including the currency symbol

Weird — Tue, 06 Feb 2024 07:00:06 GMT

The price is set based on your currency if you say, for example, current.price = 1000; and you're using euros it would become 1000€.
If you need to set it based on some other currency, you can say current.price = "USD;1000";

So in your case I'd assume using "USD;1000" in a script would set the field to 1000 USD and show it as some amount of EUR in your session.

Re: how to get currency2 value without including the currency symbol

yuvrajsharrma — Mon, 12 Aug 2024 11:01:26 GMT

Hello....

can you elaborate on this method, like i have a table accounts with a field 1-30 which is a 'FX CURRENCY' type and contains values like $157,000 ...... etc , now i want to display this value in a vertical bar component but cant pass this value to it.......i tried doing

var acc = new GlideRecord(input.table);

var gDotWalking = acc.getDisplayValue('u_1_30');

{

"assignment_group": "Current",

// "value": acc.getValue('current')

"value": gDotWalking

now this returns me this result

{

"assignment_group": "Current",

"value": "$157,500.00"

and i want to get the result as = "value" : 157500

can you help me with the code or approach to get this result.
Thank You.

Re: how to get currency2 value without including the currency symbol

Weird — Sun, 18 Aug 2024 09:35:34 GMT

Well, if you use "current.price.getCurrencyValue()", you'd end up with 157000,00. Or you should end up with the same if you use "current.getValue("price")" depending on your session currency.

getCurrencyValue() returns the value in the original currency.
If you want it in your current currency, then use getValue. getDisplayValue might include the currency sign and "," so don't use it.

Now if you just want the numbers without the cents, you can do that by splitting the value into an array.
var newValue = value.split(".");
value = newValue[0]; //You end up with 157000.