Splitting Column by delimiter

[ryan_b_fiting]

Hello Community - 

I am looking to split one of my columns by a delimiter (comma), however, some of the text strings use a comma for grammatical purposes.  Is there a way to split a column by comma that is followed by a space and capital letter?  See small sample of data below:

Current Data:

First-Aid Provided On Site?	Body Part(s)
Yes	Hand(s), (not wrist, fingers, thumb)
Yes	Lower Extremities-Foot, Lower Extremities-Lower Leg, Lower Extremities-Upper Leg
Yes	Body Systems & Multiple Body Systems
Yes	Upper Extremities-Hand, Upper Extremities-Thumb, Upper Extremities-Wrist

What I need to see once the column is split:

First-Aid Provided On Site?	Body Part(s).1	Body Part(s).2	Body Part(s).3
Yes	Hand(s), (not wrist, fingers, thumb)
Yes	Lower Extremities-Foot	Lower Extremities-Lower Leg	Lower Extremities-Upper Leg
Yes	Body Systems & Multiple Body Systems
Yes	Upper Extremities-Hand	Upper Extremities-Thumb	Upper Extremities-Wrist

Is there anyway to acheive this in Power Query so we can properly split the column by the correct comma delimiter?

Thank You Community!

Ryan F

[amitchandak]

@ryan_b_fiting , you have split the column by delimiters, But that is going to create 2 columns for first one , So you might have to remove the comma in first one based on some logic

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

[ryan_b_fiting]

@amitchandak thanks for the reply, but this does not provide any value for my issue unfortunatley.  I am fully aware of how to split columns by a delimiter, but I am looking for a more advanced solution that will allow be to properly split based on my original post.

Thanks again.