Converting from tab to comma

Glenn Boyce · Post by **Glenn Boyce** » Wed Dec 17, 2008 12:10 am

I have stored some data taken from a table field in an ordinary field. I want to be able to retrieve that information and put it back into the table field. If it was stored as CSV I'd be able to do it really easily. Is it possible to put data from a table into a temp variable and convert it to comma format? Some of the information in each field on the data table is multiple words so the string separation is lost when putting it into an ordinary field. Previously I have carried the information accross separately with a comma and put it into the field that way but I thought there may be a simpler way of doing the same thing.

cheers

Glenn

Mark · Post by **Mark** » Wed Dec 17, 2008 1:01 am

Hi Glenn,

You can use the replace command:

replace comma with tab in myData

Best,

Mark

Glenn Boyce · Post by **Glenn Boyce** » Wed Dec 17, 2008 2:15 am

Thanks Mark. Got it working