Regular Expressions 101

Community Patterns

1...56789...300

QIF amount from French format to English for MS MONEY

1

Regular Expression
PCRE2 (PHP >=7.3)

/
^([T\$])([-+]?)(\d*)(\s?)(\d+)(\,)(\d+)$
/
gm

Description

For a QIF file extracted from Boursorama bank account, transform the diffrent amount in French format to an English format (without thousand separator) for MS Money. ^([T$])([-+]?)(\d*)(\s?)(\d+)(,)(\d+)$ Substitute with $1$2$3$5.$7

Submitted by anonymous - 6 months ago