Text functions

  • Thread starter Thread starter CJ
  • Start date Start date
C

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!
 
CJ said:
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!
Click to expand...

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

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