Separating data in row

[senem127]

Hi, I want to separate the H0973B07 part in the data using the Formula or RegEx tools. Can you help me? Thanks.

Мабтера 500 мг/50 мл фл. 50 мл №1 (Рош Диагностикс), , H0973B07 до 01.01.2022

[T_Willins]

Hi @senem127,

If your data is always in a consistent format, you can use the formula .*?,\s,\s(.*?)\s in a RegEx parse.  This evaluate the string as follows:

.*?           Find all data until 

,\s,\s        It finds a comma, followed by a space, followed by a comma, followed by a space then

(.*?)         Return all data until

\s             A space

[DawnDuong]

hi @senem127 

Highly recommend that you watch the videos on Regex. It seems that the data extract problem you are attempting to solve involves some pretty unstructured data and one sample line may not not be sufficient to generalise the pattern of data you have.

Dawn.

[mceleavey]

Hi @senem127 ,

I've built this using regex with the regex tool configured as follows:

The regex expression is using the parse function, which parses out the section in parentheses and looks like this:

(\u\d{4}\u\d{2})

The breakdown of this is:

\u - Any uppercase letter

\d{4} - Followed by four digits

\u - Followed by an uppercase letter

\d{2} - Followed by 2 digits.

This provides the following output:

I've attached the workflow for you, but as @DawnDuong pointed out, I would strongly recommend you look at the resources available in the Academy area of the community to learn about parsing non-structured data.

You can find the those resources HERE.

I hope this helps,

M

[senem127]

Thank you everyone. " Мабтера 500 мг/50 мл фл. 50 мл №1 (Рош Диагностикс) " I couldn't separate this part. How can I do it?