Removing unwanted characters in field

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi

i have a field for which I want to remove the first three and 6th character.
How would i go about this please - I assume I need to run two queries?

Thanks
A
 
something like:

newfield: MID([oldfield],4,2) & MID([oldfield],7)

This is assuming that [oldfield] is present in the expected format

see VB help on MID. Press Alt + F11 to get into VB, and enter Help there.
 
Thanks David

A

David F Cox said:
something like:

newfield: MID([oldfield],4,2) & MID([oldfield],7)

This is assuming that [oldfield] is present in the expected format

see VB help on MID. Press Alt + F11 to get into VB, and enter Help there.

Alex said:
Hi

i have a field for which I want to remove the first three and 6th
character. How would i go about this please - I assume I need to run two
queries?

Thanks
A
Click to expand...
Click to expand...
 

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

retrieve last three characters of field 2
Query based on 6th character 1
Create a field from another field 4
Remove last character 1
Split data in field on character return 0
Strip leading characters from field name 14
Extract portion of field 2
Use first 3 characters in query 4

Back
Top