Parse Data

  • Thread starter Thread starter Exaviour
  • Start date Start date
E

Exaviour

Hello everybody
I'm trying to delete 4 characters in a field, example
0505-181
0505-192
0504-143
I want to delete the dash and all #s following
any help would be appreciated
 
Hello everybody
I'm trying to delete 4 characters in a field, example
0505-181
0505-192
0504-143
I want to delete the dash and all #s following
any help would be appreciated
Click to expand...

If it's always 4 characters you wish to keep, then
NewData:Left([OldField],4)

If the number of characters can vary, i.e 0589-369, 036982-963, etc.
then:
NewData:Left([OldField],Instr([OldField],"-")-1)
 

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

Parse text string and insert characters 5
Query Criteria for specific placeholders 1
parse tables 4
RegSeeker reboot 5
parse some text from an inconsistent text field 6
Parse String within Query 2
Instr parsing with a comma delimited string 3
detecting unwanted characters 7

Back
Top