How to parse for special format

[kennng]

I have the following string types in the data:

ISS CUSHION FNDTN SPF-LI 12GM/.42OZ

IS RADIANCE PRMR SPF 20 40ML/1.4FLOZ

INTNSVE SKIN SERUM FN-WA 1.5ML/.05FLOZ

and I wish to parse the string into two parts: the unbold and bold ones

for the bold ones, the pattern is as follows:

1. after a space

2. contains a slash "/"

3. ends with 'OZ'

4. at the end of the string

thank you.

[caltang]

Like so:

(.*?) (\d+[^|]+)

[kennng]

Hall Caltang,

thank you so much. it works well for most the case. however, some string without such expression also parsed into it.

such as  'INAVTI 3-STEP TRIAL K' is parsed into the following:

INAVTI

3-STEP TRIAL K

[caltang]

Just realized my REGEX didn't go all the way. No worries, added on top of it for you:

[caltang · Accepted solution]

Err... that was not accounted for. REGEX follows patterns my friend.. so more examples are needed for me to understand and tell Alteryx what to do.

For the most part, I added some exceptions here:

[kennng]

Hallo Caltang, 

it works perfect now and thank you so much