split a field in two

[Brian L]

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

 

[fredg]

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

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

 

[Alberto G]

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"