Column_values delimited by something other than a comma

Hi

This is a long shot but is there a way to get a colum_values[“text”] return that is not delimited by commas? My product team has a column that has multiple values in it and some of those values are written with commas - like:

"A thing, Move X, Y, and Z to A, B, and C, Another Thing".

When I get this returned I need to split that string into a list (I’m using Python), which I can’t do because some of the items have commas in them. My list ends up:

[A thing, 
Move X, 
Y, 
and Z to A, 
B, 
and C, 
Another Thing]

Any ideas?

Hello there @KargoTechComms,

Would you be able to please share the exact query you are using and the response you are getting so I can take a closer look?

Looking forward to hearing from you :slightly_smiling_face:

Cheers,
Matias