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)
 
Back
Top