Skip to main content

Column_values delimited by something other than a comma

  • September 8, 2023
  • 1 reply
  • 223 views

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?

1 reply

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 10, 2023

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 🙂

Cheers,
Matias