I don't want to bog this down with the nuts and bolts of all that I am trying to do, but is it possible to extract a part of a string within parenthesis using vXI or v2008 as follows:
2 bottles of wine ($123.40)
I am hoping to enter inventory items into a database that isn't really designed to hold inventory. I can accomodate all but the price so I thought their might be a way to extract it out of a string if it is always enclosed in parentheses at the end of the string. Is their a way to do this knowing that the dollar amount won't always take up the same number of characters? Please advise.
2 bottles of wine ($123.40)
I am hoping to enter inventory items into a database that isn't really designed to hold inventory. I can accomodate all but the price so I thought their might be a way to extract it out of a string if it is always enclosed in parentheses at the end of the string. Is their a way to do this knowing that the dollar amount won't always take up the same number of characters? Please advise.