Solved

strip characters in field

Posted on 2013-02-04
3
293 Views
Last Modified: 2013-02-04
Access 2010

I have a table called "NoPic_Picture_NotAll"
Field called "Material_no" text

In this field I have a list of jpg names...(no actaual pics)

What I need:
I need to delete the ".JPG" FROM Every record in this field.

1a003.jpg
10a255.jpg
3aa34.jpg

So the result would be:
1a003
10a255
3aa34



Thanks
fordraiders
0
Comment
Question by:fordraiders
3 Comments
 
LVL 26

Accepted Solution

by:
jerryb30 earned 400 total points
ID: 38851544
update someTable set somefield = replace(someField, ".jpg", "")
0
 
LVL 13

Assisted Solution

by:Surone1
Surone1 earned 100 total points
ID: 38851545
"update NoPic_Picture_NotAll set Material_no = replace(Material_no,'.jpg','')"

or if you donot want to modify the table and just  display the modified sting in a query use:

replace(Material_no,'.jpg','') as MatNo
0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 38851563
Thanks folks
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now