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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
split data problems 8
How do I split Names into 2 or more fields? 1
Query with too many fields 7
splitting a field 2
split up one field into multiple fields 2
Move data from Primary table to a One to Many Table 2
Split one field into two fields 1

Back
Top