query to split up one field into many

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

Guest

Hi. Have a field of data with many parts seperated by a carat (^). I'd like
to run a query that will effectively create 2 new fields or columns with the
seperated data and discard the carat. Any suggestions?

Thanks!
 
Hi Brian,

Using conbination of "Mid" and "Instr" will help you solve your problem.
Lookup up help on how to use those functions.

You can also export the data and import them and use "^" as the delimiter.

Help this helps.
 
Back
Top