ignore some commas in csv file?

[Anonymous]

I have a PowerShell that exports some data, and I am trying to do some BI with it, I have the problem that some paths have ','.

Below in yellow is the path: 

How can I indicate in powerquery to separate on delimiter ',' but ignore if they are part of the path?

[Anonymous]

Hi @Anonymous ,

Did you want to split? Please kindly refer to

Split Column by Delimiter in Power BI and Power Query - RADACAD

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.