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

Count fields within a Field

P: n/a
hi

I have a situation like this
a field in a table has the following values of capacitors

c1,c2,c5-c10

can I count the number of so that I get the result as 8

if so please help me understand how I can do that
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
TC
A single field should not be used to store multiple values like
"c1,c2,c5-c10".

You need to read:
http://support.microsoft.com/support...es/Q100139.ASP

HTH,
TC
"venkata" <ra*********@yahoo.com> wrote in message
news:f8*************************@posting.google.co m...
hi

I have a situation like this
a field in a table has the following values of capacitors

c1,c2,c5-c10

can I count the number of so that I get the result as 8

if so please help me understand how I can do that

Nov 12 '05 #2

P: n/a
DFS
"venkata" <ra*********@yahoo.com> wrote in message
news:f8*************************@posting.google.co m...
hi

I have a situation like this
a field in a table has the following values of capacitors

c1,c2,c5-c10

can I count the number of so that I get the result as 8

if so please help me understand how I can do that


If you can say with certainty that you only ever use the letter c followed
by digits 0 through 9, and commas or dashes to separate the values, you can
code a brute force routine to parse those strings and get your capacitor
counts. It wouldn't be pretty, though.

You're probably better off redesigning your database and reentering the
data.

Capacitor
--------------
c1
c2
c5
c6
c7
c8
c9
c10

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.