Seperate number from text

[natemclain]

I have a field called Pattern::FlaskSize and the contents of the field are dimensions of a box 18x18, 21x20, etc.

I need to populate CastingQuote::DimCopeL & CastingQuote::DimCopeW for the Length & Width of the box.

I have this script step that doesn't seem to be working:

Set Variable [$Flaskwidth; Value:LeftWords(Pattern::FlaskSize ; 1)]

Set Field [CastingQuotes::DimCopeW; $FlaskWidth]

But it returns the whole data string 18x18. I'm assuming that since there are no spaces between 18 x 18 that it is interpeting 18x18 as 1 word.

[mr_vodka]

Hi the LetWords function does not work with the character 'x'. It will take the whole value as one word.

Try:

Set Variable [$Flaskwidth; Value: Left(Pattern::FlaskSize; Position ( Pattern::FlaskSize;"x" ; 1 ; 1 )]

Set Variable [$Flasklength; Value: Right(Pattern::FlaskSize; Length(Pattern::FlaskSize ) - Position ( Pattern::FlaskSize;"x" ; 1 ; 1 ))

Set Field [$FlaskWidth]

Set Field [$Flasklength]