Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

separating 1 field into 2 fields

Status
Not open for further replies.

kpyo

Programmer
Jan 24, 2006
8
CA
Hi guys, i was wondering if there was a way to check each character in a field as to separate it into 2 fields where there is a space.
I'm trying to figure out a way but i cant seem to make it work.

thank you
 
You could try Leftwords/RightWords/Middlewords functions to separate.

 
ya i figured it out last night when i was trying to modify the field with the calculations. thanks for your help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top