Reply To: GREP Styles Help

#1240159
Stan Cain
Member

Your help has been greatly appreciated Aaron, I do notice that when I do the string 0+(\d\d\d)(\d\d) R it misses some of the records, seems like it misses the ones with 9 zeroes before a number EXAMPLE (0000007 COMPANY NAME 000000000870998 R) It passes over all of the records with 9 zeroes.

So I edited the string to 0+(\d\d\d)(\d\d\d) R and to be replaced with $$1.$2 and run it again to catch the leftovers and it puts the decimal in the wrong location example ( $870.998), need it before the last 2 digits not 3.

This article was last modified on April 23, 2020

Comments (0)

Loading comments...