split currency and amount from a string
Posted
by webber
on Stack Overflow
See other posts from Stack Overflow
or by webber
Published on 2010-06-09T00:05:02Z
Indexed on
2010/06/09
0:12 UTC
Read the original article
Hit count: 660
I am importing a file which has amount with different currency signs
£12.10
$26.13
€12.50
I need to import and convert this into single currency. I am splitting the string as follows
$parts = split(' ', preg_replace("/([0-9])/", ' ${1}', $amount, 1));
Couldn't make preg_split work with PREG_SPLIT_DELIM_CAPTURE
$parts = preg_split("/\d/", $amount, 2, PREG_SPLIT_DELIM_CAPTURE);
I have an array of currency sign to currency code
$currencySymbols = array('£'=>'GBP', '$'=>'USD','€'=>'EUR')
I need to 1. split the string into currency sign and value - if there is a better way then what i am doing 2. map the currency sign to currency code. Not able to map with $currencySymbols[$parts[0]]
Any help will be appreciated. (PHP 5.2.6) using charset=utf-8
Many thanks
© Stack Overflow or respective owner