When i execute my sql query of two columns it appear with commas...and i dont want the comma to appear between this results ,i just want a space and how can i do that?

when i execute my sql query of two columns it appear with commas…and i dont want the comma to appear between this results ,i just want a space and how can i do that?

Hi @faiza_conte, is this something you do in your actions file and are trying to return to a user? if so you could use result.replace(",", " ") to replace commas with spaces, where result is the string that comes from your query :slight_smile:

this is the error am getting when i do that

Ah, so it’s a list, not a string. no worries. Then you probably want this:

','.join(my_list)

stack overflow is a good resource for quick python questions like that! from here: python - How would you make a comma-separated string from a list of strings? - Stack Overflow

where should i include that?

instead of the .replace() line.

here i face this again

here i tried to replace the comma with space inside the sql query but one syntax is incorrect can you see that for me