Extracting percentages out of string columns

[mokawner]

I am trying to extract the percentages out of this column (COMPENSATIONAMOUNT) but they are kinda messy.

For example, this is what is in the column:

"FlashFunders shall be entitled to compensation for services equal to four percent (4%) of gross proceeds, and be entitled to reimbursement for out-of-pocket third party expenses it pays or incurs on behalf of the issuer in connection with the offering"

And I just want this:

4%

There are also percentages that are in decimal format too like 5.5% and such.

I am having trouble extracting these numbers, can anyone help me out?

[Qiu · Accepted solution]

@mokawner 
I will only focus on the extracting part. 🤣

(\d{1,2}\.*\d*%|\d{1,2}\spercent)

[mokawner]

That is so impressive, I am glad you were able to answer my question!

You rock @Qiu !!

[Qiu]

@mokawner 
Glad to be helpful. 😁