473,387 Members | 1,548 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Access Db. Remove Characters in a string

I would like to remove characters in the contract id #

If returns like: 948005102-00 or 947138462-05

I would like to remove the last 2 digits and the -

Please healp!

Candy
Dec 15 '14 #1

✓ answered by jimatqsi

Candy,
Welcome to Bytes.com. You can remove known characters with the replace function
Expand|Select|Wrap|Line Numbers
  1. Somestring=replace(Somestring,"-","")
You can remove 2 characters from the end with
Expand|Select|Wrap|Line Numbers
  1. Somestring=Left(Somestring,Len(Somestring)-2))
Jim

2 1353
jimatqsi
1,271 Expert 1GB
Candy,
Welcome to Bytes.com. You can remove known characters with the replace function
Expand|Select|Wrap|Line Numbers
  1. Somestring=replace(Somestring,"-","")
You can remove 2 characters from the end with
Expand|Select|Wrap|Line Numbers
  1. Somestring=Left(Somestring,Len(Somestring)-2))
Jim
Dec 15 '14 #2
Awesome and THANKS!!!
Dec 15 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: soni29 | last post by:
hi, how can i remove a string from an existing string in javascript. i have a textbox in a form and want to make sure that when the user clicks a button that certain words are moved, like all...
5
by: Jon | last post by:
Hello all, Would anyone please be able to help? I would like to remove all characters after and including the @ from a string, for example the string joe.Bloggs@someplace.com would become Joe...
10
by: Chung Leong | last post by:
Just saw a message in pl.comp.lang.php, which states that the following message has appeared in the PHP CVS snapshot: Usage of {} to access string offsets is deprecated and will be removed in...
7
by: Chris Brat | last post by:
Hi, Is there a better way to replace/remove characters (specifically ' and " characters in my case, but it could be anything) in strings in a list, than this example to replace 'a' with 'b': ...
2
by: adi108 | last post by:
hi how does one access parts of string in C. string comes back like this in Hyperterminal LITL0 0000 LITL1 0759 LITL2 0014 LITL3 0024
2
by: rpeacock | last post by:
Is there a way to basically trim off the last X characters in a field? Example Field 1 Value - 15000 Field 2 Value - 2645678 Desired output - 15 Desired output - 2645
10
by: teenIce | last post by:
Hi all, Does anyone have suggestion what can I do to remove some string from a string? Like this : Original : I have a cat. Remove : have Result : I a cat. Thanks in advance.
10
by: Mike Copeland | last post by:
I have data I need to normalize - it's "name" data. For example, I have the following: "Watts, J.C." I wish to (1) parse the "first name" ("J.C.") and adjust it to "JC". Essentially, I want to...
2
by: grinder332518 | last post by:
My pipe delimited file is coming over with spurious “\” characters inserted into some alpha fields, which is causing the records to be split into 2. Eg Abc|def|10/11\ AAAA|xyz ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.