RegEx Parse after addition sign (+)

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

Regex

Parse

Accepted answers

binu_acs

@CSchimm Something like this

Regex_020223.yxmd

All comments

binu_acs

@CSchimm Something like this

Regex_020223.yxmd

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 !!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703