This looks like data that should not be all in one field to begin with.
LeftWords ( "2x @5.99" ; 1 )
will return "2x"
RightWords ( "2x @5.99" ; 1 )
will return @5.99
There is also a MiddleWords function.
Thank You for that, it gave me a little better understanding of Left and Right Words but Im still unclear on what to do, maybe Im not Explaining it correctly
In that line There is Also Space so it Really Looks Like
' 2x @$5.99 '
So I Need to Do 2 Things with this in my Script, Because it has the x and the @ all I Really want is the 2, if it does not contain this data (the x and the @), then I move on to the Next field
Thats How i Feel about this Data, But it is What it is
Thanx for your Help
WIthout that space between the two values, the Left words function will not work to return just the first item.
GetAsnumber ( Leftwords ( YourField ; 1 ) )
would return just the 2.
Sorry I don't Move on to the Next Field, I Move on to the Next Record...
I don't know what that has to do with answering a question about how to extract data from a field.