CodeGuru Forums - Crystal Reports
http://forums.codeguru.com/
enFri, 24 May 2019 13:04:10 GMTvBulletin60http://forums.codeguru.com/images/misc/rss.pngCodeGuru Forums - Crystal Reports
http://forums.codeguru.com/
Extract Text
http://forums.codeguru.com/showthread.php?563421-Extract-Text&goto=newpost
Tue, 21 May 2019 11:37:37 GMTGood morning,
I have a text field and need to extract out the numbers so I can create a formula to calculate the variance. See example below
Discount: Rate changed from -799,960.00 to -1,031,100.00
The numbers would change each time but the rest of the verbiage would be the same. Any assistance would be greatly appreciated.
Thank you
mtappGood morning,

I have a text field and need to extract out the numbers so I can create a formula to calculate the variance. See example below
Discount: Rate changed from -799,960.00 to -1,031,100.00
The numbers would change each time but the rest of the verbiage would be the same. Any assistance would be greatly appreciated.