Hi everyone! So the hurdle I'm trying to overcome is that I have a value list that contains width and height dimensions.
Sampling of that value list:
3.875 x 8.875
8.5 x 11
9 x 12
11 x 17
12 x 18
I'd like to set up a script trigger to pull each of the two integers out of the selected value and set them in Width and Height fields. The part I'm having a hard time figuring out is the "grabbing" of the appropriate number of characters (words?). I was going to just write a Case that says
If [ Table:Size_Choice = "8.5 x 11" ]
Set field [ Table:Width ; 8.5 ]
Set field [ Table:Height ; 11 ]
and then just repeat that for each choice.
However, that would mean if I added a value to that list, I would then need to go in and add a step to that script each time. I'm fairly certain there's a function that will strip the data I want from that value list, I'm just too much of a novice to know what it is or how it needs to be written to grab the correct data.
I think the function I want to use is the LeftWords. I've gotten that to work for the first number but then it grabs the first number, the "x", and the third number when I try to get just the second number. LeftWords ( Table:Size_Choice ; 3 ) is what is returning that undesirable result. I understand what is doing to return that data so my question is how do I get the just word in position 3? I think that's the answer I need.
Now you might say, use LeftWords to get the first number and RightWords to get the second number BUT
I have other places in my solution where I need to do this same thing but there is a one or two word description after the dimensions (i.e., 8.5 x 11 Tri-Fold). RightWords would return an undesirable result in cases like that. The only thing that is constant in all of the cases is that there is a number (with up to 3 decimals), a space, an x, a space, and a number (with up to 3 decimals) in all of the value lists.
Anyone out there want to give this one a bit of time? Thanks in advance!