3 Replies Latest reply: Jul 30, 2012 8:37 AM by 946493 RSS

    how to change the delimiter from a comma to something else?

    946493
      How can I change the delimiter from a comma to, say, a tilde when running a query? We have a few fields where the data was entered with commas and it messes the columns up

      For example... current output of three fields is interpreted as four due to extra comma:

      John Doe, 123 Any St, Anytown, 7035551212

      Thanks

      Edited by: 943490 on Jul 28, 2012 5:51 AM