Page 1 of 1

Converting from tab to comma

Posted: Wed Dec 17, 2008 12:10 am
by Glenn Boyce
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

Posted: Wed Dec 17, 2008 1:01 am
by Mark
Hi Glenn,

You can use the replace command:

replace comma with tab in myData


Best,

Mark

Posted: Wed Dec 17, 2008 2:15 am
by Glenn Boyce
Thanks Mark. Got it working