Mark Drelinger
asked on
pull value out of an access field into separate field
I have an access field with data such as :
<ROOT><NEW_DATA FILE_NO="5535" BRANCH="02" CUST_ORD_NO="" TAX_NO="ON FILE" TYPE="O" FREIGHT="0.00" SALESMAN="S201" .
I need a query that puts the Branch # in a separate field.
The text varies, but The Branch Field is always preceded by "BRANCH=" and will be 2 characters.
Is this possible?
<ROOT><NEW_DATA FILE_NO="5535" BRANCH="02" CUST_ORD_NO="" TAX_NO="ON FILE" TYPE="O" FREIGHT="0.00" SALESMAN="S201" .
I need a query that puts the Branch # in a separate field.
The text varies, but The Branch Field is always preceded by "BRANCH=" and will be 2 characters.
Is this possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yuo can also do this
SELECT [FieldName], Mid([FieldName],InStr([Fie ldName],"B ranch=")+8 ,2) as BranchNo
FROM Table1;
SELECT [FieldName], Mid([FieldName],InStr([Fie
FROM Table1;
ASKER
even better ! thank you.
ASKER