Question for Advanced CR Designers

[MSGCR]

Need help with formula for array. For example:
Given a string like this,
"1;1500;3804^^0.757;2200;2880"
I'd like to stuff 3804 and 2880 in the array and then sum those numbers.

I want to split the string by the '^^' character, then split the element by the ';' and take the 3rd element. There could be more than two elements when splitting by '^^', but always only 3 ';' within that element.

Sorry if this is confusing. Thanks for the help.

 

[vidru]

Fun stuff...
[tt]
StringVar str := "1;1500;3804^^0.757;2200;2880";
StringVar Array splitter := Split(str, "^^");
NumberVar summary := 0;
NumberVar i;

for i := 1 to Count(Splitter) do(
summary := summary + Val(Split(Splitter, ";")[3]);
);

summary;
[/tt]
-dave

 

[MSGCR]

That works. You are a bad ass. Thanks a million!

 

[bdreed35]

I like working with formulas, so here is my condensed take on it:

stringvar array nums := split(replace("1;1500;3804^^0.757;2200;2880","^^",";"),";");

val(nums[3]) + val(nums[6])

~Brian