Page 1 of 1

Converting field into table & vice versa

Posted: Sat Jan 07, 2012 4:49 am
by david_ff
What would be a script for turning a field into a table, or vice versa. This is easily done in the Object Inspector, but I would like to be able to do this in a script.
Thanks,
David

Re: Converting field into table & vice versa

Posted: Sat Jan 07, 2012 12:34 pm
by jmburnod
Hi David,

You cane use the replace command like this:

Code: Select all

function FromCommaToTab pText -- pText contains lines with items, itemdel = ","
   replace "," with tab in pText
    return pText
end FromCommaToTab

function FromTabToComma pText
   replace tab with ","  in pText
   return pText
end FromTabToComma
Best regards

Jean-Marc

Re: Converting field into table & vice versa

Posted: Sat Jan 07, 2012 7:57 pm
by david_ff
Thanks for the reply.
I'm running Revolution 2.1.2, and I don't see that function in the documentation, nor does it work. Other ideas?

Best
David

Re: Converting field into table & vice versa

Posted: Sat Jan 07, 2012 8:33 pm
by jmburnod
Hi David,
I'm running Revolution 2.1.2, and I don't see that function in the documentation
I don't remember if the "replace" command exist in Rev 2.12 but i'am sur there is not a FromTabToComma finction. I write it :D

Are you sur there is not a "replace" command in Rev 2.12
, nor does it work
How do you try to use it ?

Best regards

Jean-Marc

Re: Converting field into table & vice versa

Posted: Mon Jan 09, 2012 6:08 am
by david_ff
Jean-Marc,

There is a replace command (and a replacetext command) in Revolution 2.1.2, but I don't see how I can use it to convert a table to a normal field or vice-versa.

David

Re: Converting field into table & vice versa

Posted: Mon Jan 09, 2012 9:54 am
by jmburnod
Hi David,

I put a simple stack in attachment

Best regards

Jean-Marc

Re: Converting field into table & vice versa

Posted: Fri Jan 13, 2012 11:29 pm
by david_ff
Thank you, Jean-Marc. This should solve the problem.
Best,
David