> On Behalf Of Alex Koolhof
> For example, 5878億 becomes 587.8 billion
>
> However, I can't seem to get it to work when numbers contain a comma, like
> 5,878億. Ideally, I want the comma removed, so this too becomes 587.8 billion.
Here is a regular expression that works for "5,878億" and "5878億":
Source:
(\d),?(\d\d)(\d)億
Target:
\1\2.\3 billion
[,?] means "optionally, a comma"
> I would also be interested in other useful J to E matches/replacements using
> regular expressions that could be imported into the rule manager if others are
> willing to share them?
I have a few that I use, but they're pretty specific to software, so I don't know how generally useful they are. If you post some patterns that you'd like to turn into rules, I'm sure I or someone else can help you out.
Regular expressions are really complicated, but they can also be useful in a lot of situations. If you've got the time to invest, the book "Mastering Regular Expressions" by Jeffrey Friedl is pretty much the bible on the subject.
Regards,
Ryan