So i want to parse my string that contains value with currency, for example:
€579,976
€0
$1.5
Currently i am just removing the first char and trying to parse the rest.
Does anyone have an idea how to do it in a better way?
Asked
Active
Viewed 95 times
-1
Som Bhattacharyya
- 3,732
- 31
- 50
david hol
- 1,184
- 7
- 21
- 38
-
Not all characters can be represented in 1 character, so if you are just using the currencies that can be represented in a single character, then you don't need an optimization. – Sendhilkumar Alalasundaram Mar 21 '16 at 04:54
-
just use a regex: 1st group - currency symbol - NaN, 2nd group - floating point with thousand separator. – yǝsʞǝla Mar 21 '16 at 05:10
-
Can i have code example ? – david hol Mar 21 '16 at 05:14
-
which part are you having problem with? regex or scala code? – yǝsʞǝla Mar 21 '16 at 05:36
-
regex, i try to learn it but it seems difficult – david hol Mar 21 '16 at 05:40
-
Look here : http://stackoverflow.com/questions/13848570/currency-regular-expression – Som Bhattacharyya Mar 21 '16 at 07:07
1 Answers
2
You could use a regular expression to solve that problem.
There is a Unicode Character Property for Currencies : \p{Sc}.
Usage Example, currency and amount:
val amountAndCurrencyRe = "(\\p{Sc})(.*)".r
val results = amountAndCurrencyRe.findAllIn("""€579,976
€0
$1.5
¥20
""")
results.collect{
case amountAndCurrencyRe(currency,amount) =>
println(s"Amount:$amount Currency:$currency")
}.toList
Result:
scala> results.collect{ case amountAndCurrencyRe(currency,amount) => println(s"Amount:$amount Currency:$currency") }.toList
Amount:579,976 Currency:€
Amount:0 Currency:€
Amount:1.5 Currency:$
Amount:20 Currency:¥
res6: List[Unit] = List((), (), (), ())
just get Amounts:
scala> "€579,976 €0 $1.5 ¥20".replaceAll("\\p{Sc}","")
res1: String = 579,976 0 1.5 20
Andreas Neumann
- 10,516
- 1
- 31
- 52
-
I don't need this currency, also not list, just simple string without the currency. – david hol Mar 21 '16 at 11:31