for the below:
22,579,029.59-196,288,552.58-196,288,552.58-6 Total Object Account 250101 22,579,029.59-22,579,029.59-196,288,552.58-196,288,552.58
I am looking to extract the 6 digits after “Total Object Account” and then in a second variable the first set of numbers after that 6 digit number(in this case the 22,579,029.59.
Have started with this: (?<=Total Object Account ).+")
Any ideas welcome. This will be used the same on other categories to build a dt. We just have to pull one by one through a get visible text activity