Get Currency from a Text String

(0) Share

Report

Posted on by usaman45

314

Hi,

The user will entry a string such as "123456.78USD" or "9,876,543HKD". The number will be different time and the currency code will also in different code.

And, I'd like to get the number out from the string and show in currency format with currency code, how can I do that?

For example:

Input: 123456.78USD

Output: 123,456.78 USD

Input: 9,876,543HKD

Output: 9,876,543.00 HKD

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

FMontesRNX1 147 on at

Like
a
(0)

Report
Copy link

Link copied!

So you'll only separate the string? This will create a registry on separate fields?
Here some ideas:
For get the number:
Value(Left(YourString.Text,Len(YourString.Text)-3))
You can also transform the value using something like: Text(value,"#,#") or as required.

For get the currency:
Right(YourString.Text,3) -Considering ISO 4217

You can use both to make another data operations (like convert between currencies), only be careful with circular references.

Was this reply helpful? Yes No
usaman45 314 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the idea, I have a question is if the string is not always has 3 characters at end. Then, what is the best way to get the number out from the string? thanks!

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @usaman45,

Do you want to extract only the currency input within the TextInput?

Here is the Rex that I use to achieve your need.

Match(TextInput6.Text,"\d+.\d+").FullMatch

Was this reply helpful? Yes No