Recent content by xmattxman
-
X
Extract text from a field in access
I will try that thanks for pointing me in the correct direction -
X
Extract text from a field in access
On further review it looks like they are all 10 characters long and will always end with two numbers at the end -
X
Extract text from a field in access
No sometimes one could have more characters . Could we do something like anything that starts with 09 up to the first space? -
X
Extract text from a field in access
original - CUT (09GN20T-01) 73" LONG result 09GN20T-01 original - (09GN20T-01)CUT 6.50" - STRIP result 09GN20T-01 original - CUT 2 09GN20T-01 LEADS result 09GN20T-01 original - (09BN22R-01) CUT 3.5" result 09BN22R-01 Everything I am extracting... -
X
Extract text from a field in access
AH0370400091 27 CUT (09GN20T-01) 73" LONG AH0370400092 25 (09GN20T-01)CUT 6.50" - STRIP AH0370400093 20 CUT 2 09GN20T-01 LEADS AH0370400093 80 (09BN22R-01) CUT 3.5" I need to extract only the numbers that start with 09 from the text in the far right field. I tried left trim but cant...