Hello, LF community! I am trying to use regex with Connector to format a value from a zone OCR value. Value sample possibilities are as follows:
Discount Amount: .00
Discount Amount: 100.00
Discount Amount: 10,000.00
I need to be able to return only the number with decimal point for entry into a metadata field in a LF template in the repository (which is formatted to currency). I can successfully exclude the "Discount Amount:" term, but still end up with a leading whitespace before the number and the comma inside the number. To achieve this result, I'm currently using:
(?:[^:]+)$
I'm sure I'm missing something simple, but I just can't figure this out! I would greatly appreciate any help to return just the number and decimal point.