By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 733 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

splitting memo field at character limit

P: n/a
I have a product database that includes a memo field for product
descriptions. That database must be imported into a legacy system that
has four text fields for product descriptions, each with a 250
character field length.

So, I am looking for a way to write a query or script that will pick up
the first 250 characters of the memo field and insert them into the
first field of my query, the second 250 characters into the second
field of the query, etc. until it reaches the 1000 characters. It
would also be nifty if it alerted me to which records have more than
1000 characters in the memo field, so that I could edit down the data
to a more manageable record size.

Any ideas?

Jul 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
use MID.

first one:
Mid$(MyTextField,1,250)
second
Mid$(MyTextfield,251,250)
third
Mid$(MyTextfield,501,250)
fourth
Mid$(MyTextfield,751,250)

Jul 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.