putting data into a table

[tempj]

Hey guys,
I am new to MS. I've been trying to add string into a table, something like

--------------------------------------
url | http://domain.com |
--------------------------------------
time | 2009-09-22 14:20:05 |
--------------------------------------

Here is my sample script. I would like to know if there is any other efficient way to retrieve data.

Let>strHTML={"url: http://domain.com, time: 2009-09-22 14:20:05}"

//remove opening bracket {"
Let>pattern={"
RegEx>pattern,strHTML,1,matches,new,1,,strHTML2

//remove closing bracket, "}
Let>pattern="}
RegEx>pattern,strHTML2,1,matches,new,1,,strHTML3

MessageModal>strHTML3


Thanks in advance.

[Marcus Tettmar]

If I've understood you correctly you want to end up with two rows, and two columns and in this case the columns are split by the ": " and rows by ",". So we could do:

Code: Select all

let>html=
Let>comma=,
Let>str=url: http://domain.com, time: 2009-09-22 14:20:05
Separate>str,comma,rows
Let>html=<TABLE>
If>rows_cout>0
  Let>r=0
  Repeat>r
    Let>r=r+1
    Let>html=%html%<TR>
    Separate>rows_%r%,: ,cols
    If>cols_count>0
      Let>c=0
      Repeat>c
        Let>c=c+1
        Let>this_cell=cols_%c%
        Let>html=%html%<TD>%this_cell%</TD>
      Until>c=cols_count
    Endif
    Let>html=%html%</TR>
  Until>r=rows_count
Endif
Let>html=%html%</TABLE>

MessageModal>html

[tempj]

thanks much.

Very helpful to understand the basic route.