Copy and paste text from begining of line and pasting to another place

[mchadwick]

I have records that contain the begining of the information I want to have in a specific line by itself. I need to go into the field for each record and copy the text before the "\" and then go to another feild in that record and paste it in there. How do I do that?



Example of text in field "Location" for a record
"Dallas\121 smithy rd\dallas\texas\76177"

What I need in the field Alias
"Dallas"

There are sometimes spaces between the words, I need everything before the "\". thanks for your help. I'm using a query to work on the data now, but is going to take me a very long time to do manually. 20k records in all.

[June7]

Use string manipulation functions to extract text.

Left([fieldname], InStr([fieldname], "\") - 1)

However, InStr will error if the field is null.

Left([fieldname], InStr(Nz([fieldname],""), "\") - 1)

[mchadwick]

Perfect, thank you very much for such a quick reply.