Multi-valued Script parameters

[sijmons]

I'm trying to pass on several fields into a script parameter to be picked up in another file. One of the fields may contain hard returns which I would like to keep in, so I use & "^" & to delimit the fields.

This induces the problem that my usual method:

GetValue (Get ScriptParameter) ; 2 )

can no longer be used and I am puzzled how to parse out my fields using the ^ delimiter. So far all my attempts fail to work and I am calling the forum for help.

... and enjoy 2007 !

[comment]

I am not sure this is the best method to pass multiple values in a script parameter*, but you could use a calculation like this to extract the n-th value from a string delimited by "^":

Let ( [

text = "^" & string & "^" ;

start = Position ( text ; "^" ; 1 ; n ) + 1 ;

end = Position ( text ; "^" ; 1 ; n + 1 )

] ;

Middle ( text ; start ; end - start )

)

---

(*) see here

[mr_vodka]

You may want to check out this technique for passing multiple parameters that is on FileMaker Magazine's Website

[sijmons]

Thank you both for this help.

I had the example file downloaded several months ago but just completely forgot about it.

... time to built a FAQ database for myself, what?

[Søren Dyhr]

I'm trying to pass on several fields into a script parameter

But chances are that referential integrity is buried underneath heaps of nifty scripting. If a lot needs to get copied ...does it talk in favour for getting broken up in relational structure!

--sd

[sijmons]

You are right Soren, but this is from a customized file to a standard solution file and I like to keep that communication as generic as possible to be able to use the standard solution with multiple clients in an uncompromised way.

[T-Square]

There were a couple of Custom functions (one my own) for parsing script parameters. Mine used a "var1=value1; var2=value2" syntax that you could modify to your own characters.