Skip to main content
May 28, 2008
Question

Replacing comma delimiters with single quotes.

  • May 28, 2008
  • 1 reply
  • 283 views
Hi,

I need to replace all the occurences of comma delimter in my list (i.e, "one,two,three,four") with a single quote,

The output should be like this,

'one','two','three','four'

Can anybody shed some light here?
    This topic has been closed for replies.

    1 reply

    Inspiring
    May 28, 2008
    Use the ListQualify function. Details are in the cfml reference manual.

    Unless you are going to use this list in a query, in which case the list attribute of cfqueryparam is a better approach.