RegEx Parse after addition sign (+)

[CSchimm]

I am attempting to parse an item of text that contains pricing information +/- an adder. The data would look something like this:

Pricing information using service 1 + 0.0075 USD/gal

Pricing information using a different service - 0.015 USD/gal

The information at the beginning can/will be different, but it always ends with plus or minus some number. I have successfully parsed the ones that are subtracting a number using RegEx Parse with Regular Expression:  -(.*)     However, when I try to do the same exact thing with the plus sign, +(.*)  I get the following error. "RegEx: An attempt to repeat something that can not be repeated - for example a*+ at character 0"

I have spent quite a while searching the community to find somebody else who had issues parsing at a + sign but came up short. Can anybody help?

Thanks!

Cailin

[binu_acs · Accepted solution]

@CSchimm Something like this

[CSchimm]

Thank you so much! For those who might find this helpful later, I wanted to keep the positive and negative signs on the adder at the end, so I created two expressions in the same formula tool and created two separate columns one as "positive" and the other "negative." I am certain there were more efficient ways to do this, but as a beginner, this makes sense to me. 

In addition, putting the whole expression in TONUMBER(), I was able to get the end information as a double in order to add/subtract later.

Thanks again!!

[BS_THE_ANALYST]

@binu_acs In RegEx, when you are using special characters inside character classes [] I don't think you need to escape '\' the special characters. I could be wrong though! 😂. See below

[binu_acs]

@BS_THE_ANALYST interesting !!!