Forum Discussion
ignore some commas in csv file?
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?
1 Reply
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.