Need to split column based on a string

[jmedidi]

i am trying to split the text based on string value using Regex. Something like this:

Existing  Field 1 : Size 112KB(76 KB Used) 65%

Expected:

 Field1 :Size 116KB(12 KB Used)

 Field2: 65%

There can be space between the number and percentage and it can be decimal as well like 65.22%

[jmedidi]

Parsing breaks if the string is something like this:

Primary: 4 kB, 70.4% free Secondary: N/A

[jmedidi]

Appreciate the response.

[atcodedog05 · Accepted solution]

Hi @jmedidi 

Here is the updated Regex for the task.

Hope this helps : )