Substrings in the Split function. 1

[ts04]

If I split a string like: 1234=abcd and I define the delimeter as beeing "=" then the function would look like:

Split("1234=ABCD","=")

The return value would be an array with the substrings: "1234" and "ABCD". But how can I Isolate a string from this Array to be shown in my report?

Thnx for your help!

Tanja

 

[crystalvictim]

Hi,

I don't know what version of CR you're using, but I ran a quick test with CR8.5:
If your formula contains
Split("1234=ABCD","=")[1]
the output will be 1234, whilst
Split("1234=ABCD","=")[2]
will return ABCD.
So you should be able to use your formula field from within other formulas. Of course you can also use global variables to store the values (which may also be extracted by a loop) and pass them from one formula field to another.

Kind regards.

 

[ts04]

Thank you very much for your help!!

Ciao,

Tanja