Re: How to get the dollar value from this text string?

While the regex discussion is interesting, the original post was about the
best way of extracting the number at the end of the string. It horrified me
(kind of) that Art proposed the idea of replacing all prefix-characters
with spaces, which is a valid use case for a different problem, but only
serves to add overhead to the problem at hand.


On Fri, Jul 31, 2020 at 3:01 PM Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>
wrote:

regex101.com is a good place to get explanations for regexes. The period
means any character. The asterisk means match as as many characters as you
can find. By default it is greedy which means it will try and grab as many
characters as it can. The N is just an N. So you are telling it to match
any characters up until you get to a capital N. Because it's greedy, it
will find the last capital N. For regex_replace, if you don't provide a
third parameter then it defaults to blanks. So -
regex_replace(source_string,'.*N') mean convert everything up to and
including the last capital N, and replace it with blanks.