string question

  • Thread starter Thread starter Victoria
  • Start date Start date
V

Victoria

let's say i have a textbox holding the value 12ah6/6SQ61. I need a function
that will output the string before the /, and another that outputs the string
after the /. How do i do this?

thanks in advance
Victoria
 
let's say i have a textbox holding the value 12ah6/6SQ61. I need a function
that will output the string before the /, and another that outputs the string
after the /. How do i do this?

thanks in advance
Victoria
Click to expand...

Before = Left([Fieldname],InStr([FieldName],"/")-1)
After = Mid([Fieldname],InStr([FieldName],"/")+1)
 
Back
Top