471,086 Members | 934 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,086 software developers and data experts.

How to perform an opposite of CONCATENATE on a form

Hi,

I have a text field in format 000123456789 and I have to split this
text field into 12 separate text fields. So this would have to look
something like this:

Field1 has a value 0,
Field2 has a value 0,
Field3 has a value 0,
Field4 has a value 1,
Field5 has a value 2,
Field6 has a value 3,
Field7 has a value 4,
Field8 has a value 5,
Field9 has a value 6,
Field10 has a value 7,
Field11 has a value 8,
Field12 has a value 9.

I have to admit that I don't have a slightest clue on how to achieve
this and would really appreciate help. The reason I have to separate
this field is because I have to multiply each number inside the field
with a different ponder in order to calculate a control number for my
reports.

Thanks for your help,
Matej
Nov 13 '05 #1
1 5160
On 18 Oct 2004 05:33:48 -0700, ma************@email.si (matejp) wrote:

Check out the Mid$ function in the Help file.
E.g. Mid$(MyTextField, 1,1) = 0

-Tom.

Hi,

I have a text field in format 000123456789 and I have to split this
text field into 12 separate text fields. So this would have to look
something like this:

Field1 has a value 0,
Field2 has a value 0,
Field3 has a value 0,
Field4 has a value 1,
Field5 has a value 2,
Field6 has a value 3,
Field7 has a value 4,
Field8 has a value 5,
Field9 has a value 6,
Field10 has a value 7,
Field11 has a value 8,
Field12 has a value 9.

I have to admit that I don't have a slightest clue on how to achieve
this and would really appreciate help. The reason I have to separate
this field is because I have to multiply each number inside the field
with a different ponder in order to calculate a control number for my
reports.

Thanks for your help,
Matej


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Len Burman | last post: by
3 posts views Thread by Bosconian | last post: by
6 posts views Thread by Sheldon | last post: by
9 posts views Thread by pranav.choudhary | last post: by
10 posts views Thread by Aaron Hoffman | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.