split a field in two

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to split field in two before and after a carat (^). Problem is, I
can't use Left or Right trim because num of characters is always diff. Any
ideas? Perhaps Mid?

22451^Jones Incorporated
 
I want to split field in two before and after a carat (^). Problem is, I
can't use Left or Right trim because num of characters is always diff. Any
ideas? Perhaps Mid?

22451^Jones Incorporated
Click to expand...

LeftPart:Left([Fullfield],InStr([FullField],"^")-1)
RightPart:Mid([Fullfield],InStr([FullField],"^")+1)
 
Brian try this

ex. Tomorrow^afternoon

Left([FieldName],InStr([FieldName],"^")-1) this will give you "Tomorrow"

Mid([FieldName],InStr([FieldName],"^")+1) this will give you "afternoon"
 
Back
Top