Separate a field into 5 fields

  • Thread starter Thread starter Janice R
  • Start date Start date
J

Janice R

I have a string of numbers that looks like "A3 000012691
100 605 00" in a column called Acct ID. I need to
separate this string into five differenct columns. The
space between the numbers is where the split needs to
be. THe new columns names are Bank Acct, Client ID,
SubAcct, Object, and Extra. What formula should I use?
I am more familiar using the query design screens than
the sql screen to write my formulas.
 
Back
Top