tupac1979
asked on
Query to search through string of values
I have column in table that contains values such as:
5D7;8M7;9M7
1H1
I would like to use a query that could get this values and then multiply them out for example
5D7 wouble 5 *7 + 8M7 would be 8 * 7 + 9M7 would be 9 * 7 = total and so on.
Can someone guide me in the right direction.
5D7;8M7;9M7
1H1
I would like to use a query that could get this values and then multiply them out for example
5D7 wouble 5 *7 + 8M7 would be 8 * 7 + 9M7 would be 9 * 7 = total and so on.
Can someone guide me in the right direction.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
does the table have something like 55dd77;4mmm9999;
Interesting. I've never seen this but just off the top of my head I would have thought that M = * (multiply) and D = / (divide) instead of both being *.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no the main problem is first moving past the semicolon to get the next value to mulitply. And the D and M mean days and minutes but I am not concerned with converting them to time just only multiplying the values and moving past the semicolon if there is one. Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.