Equivalent feature of PHP Explode

[Don_Macaroni]

Hi,

I'm breaking my brains over something that should be as easy as 123. I have a global text field where a user inputs a 'period-' or 'comma-' separated text in a custom dialog box. I then want to run a script that separates those values, eg. "456123.785412.255879.225788" and creates a new record for each of them.

I used PatternCount(text, ".")+1 to have a variable for the loop, but how do I extract the actual values? As php explode and a while loop would do...

Help appreciated.

[Raybaudi]

Set variable ( $values ; Substitute ( global text field ; [ "." ; ¶ ] ; [ "," ; ¶ ] ) ]

Loop

Exit Loop if [ IsEmpty ( $values ) ]

New Record/Request

Set field [ yourTable::yourField ; GetValue ( $values ; 1 ) ]

Set variable [ $values ; RightValues ( $values ; ValueCount ( $values ) - 1 ) ]

End Loop