I need some help which probably involves regex.
The scenario i have is there are 3 possibilities of returned results and all 3 lead to different scenarios
Returned results can be
(0.09) - this is considered a negative number
0.09 - this is considered a positive number
0.00 - this is considered the best outcome
How do i code the bot to recognise either of the scenarios and if it is the first two then create an output that offsets it back to 0 e.g. if it is (0.09) it should enter 0.09 in another field to balance it back to 0.00. and if its 0.09 then type in -0.09 in another field.
0.09 is just an example it can be any number, the number in () indicates its negative, no brackets is positive.