Text functions

[CJ]

Hello all, I have first & last name in one field and a
backslash (/) is between the first & last name. I need to
pull out just the last name or the first, at this point
it doesn't matter which. Which text function would I need
to use and how do I build this expression??

Thanks!

 

[Rick Brandt]

Hello all, I have first & last name in one field and a
backslash (/) is between the first & last name. I need to
pull out just the last name or the first, at this point
it doesn't matter which. Which text function would I need
to use and how do I build this expression??

Thanks!

FirstName: Left([YourFieldName], Instr(1, [YourFieldName], "/")-1)

LastName: Mid([YourFieldName], Instr(1, [YourFieldName], "/")+1)