Remove specific characters from a text field

G

Guest

I have a table that contains non numberic characters in a text field. Is
there as easy way to remove these characters?
Example of data in field:
"Document 248, SnagIt owned by bwayres was printed on cdhp4pur via port
cdhp4pur. Size in bytes: 1049480; pages printed: 1"

I would like to only keep the actual number of pages printed, in this case I
only want to retain "1" at the far right so I can use it to calculate.
--
Sebastian Cavignac
Network Administrator
Salt River Materials Group
928.639.8095
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Specific Characters From Text 1
Mail Merge and Public Folders 1
Remove Specific Text/Character in Specific Place 7
How do I validate a field has 5 characters (alphanumeric)? 4
Remove text from field 2
Extracting a word from a long text field 5
get last digits in field using query 2
strip numeric characters from a text field 5

Top