Why am I getting a duplicate output?
Take out the parentheses around the amount:
RegexExtract([text 1],"(?<=spend\s)\$[\d,]+")
It may be returning the same value as a match and a capture group.
3 Likes
Why am I getting a duplicate output?
Take out the parentheses around the amount:
RegexExtract([text 1],"(?<=spend\s)\$[\d,]+")
It may be returning the same value as a match and a capture group.