Remove Text and Keep Only Numbers

[gameemaster]

Hello,



I have a column in one of my tables called: ErrorMessage. When I import into the Long Text data type column, this is what it looks like:

EXAMPLES:

Company not found: 997.
Company not found: 9004.
Company not found: 0.
Vendor not found or inactive or deleted: 24968.
Branch Code:CLR Invalid. Could not find the Client Code.
Company not found: 150.

I would like to have a column with just the numbers, meaning I want to remove all text, all periods and just have the number, how do I do that? Plz Help!

[andy49]

https://access-programmers.co.uk/for...ad.php?t=61485

Use this page. Then run a query on your table calling the function.


Sent from my iPhone using Tapatalk

[gameemaster]

Works fantastic! Thank you so much.

[gameemaster]

Can you help with this? Your advice before was superfluous!

I have two tables. I import one (1) table that has a column as a Number (Column 1), and it stays a number. I have another table, that I import a column as Text (Column 2), that's because it has characters attached to it like 144147R or 134991A.

I am able to remove alphas on the text column import to remove the letters. Now I am trying to run an inner join and a left join on those two columns. I have used the Fortmat(), Val(), Int(), CDbl() functions, trying to convert the removed alphas text column (Column 2), which would technically be Column 3, since I had to use a module to remove the alphas.

I've tried all those functions to convert a text column to a number after I have removed alphas, removing alphas requires me to create a 3rd column (Column 3), so I want to inner join and left-join column 1 and column 3, but I cannot get column 3 formatted as a number!

[jwhite]

FYI: The appended post above is in its own thread: https://www.accessforums.net/showthread.php?t=65591

[gameemaster]

Can you assist? It seems pretty simple, i have one table that has number column and one table that has text column, and I need to join the two, what's the best way to do that?