Extract a number for a string field in ms access query
Hello,
I need assistance in write a query to extract the number from a string field (See example below). The field will always have just one number in it and no decimal point. However, the number itself can be of any length. In the example below to number to extract will be: 214295600
# //STATION AGENCY="TEST " NUMBER="0214295600 " TIME_ZONE="EST" DST_FLAG=Y
Thank you.
I need assistance in write a query to extract the number from a string field (See example below). The field will always have just one number in it and no decimal point. However, the number itself can be of any length. In the example below to number to extract will be: 214295600
# //STATION AGENCY="TEST " NUMBER="0214295600 " TIME_ZONE="EST" DST_FLAG=Y
Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER