varchar(1200) sep by ;

[vjp2.at]

How do you import a records whose last field is a varchar array of max 1200
where the array elements are separated by semicolon?

I am thinking of using the GNU (unix emulator) "head" command
to look at the first records. Because maybe I can read it
as ten fields instead of an array?????

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[vjp2.at]

*+-How do you import a records whose last field is a varchar array of max 1200
*+-where the array elements are separated by semicolon?

And then, how do you query these?

varchar(max1200)

"2012 General;2012 Priority;2011 Preliminary;2010 General ;2010 Preliminary
;2008 General ;2008 PRIORITY;2007 General"

Note one is caps - not predictable


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[John W. Vinson]

How do you import a records whose last field is a varchar array of max 1200
where the array elements are separated by semicolon?

I am thinking of using the GNU (unix emulator) "head" command
to look at the first records. Because maybe I can read it
as ten fields instead of an array?????

I'm not sure what's the context. What's your table structure? You could have
this entire semcolon delimited string stored in a Memo field and search it
using wildcards: a criterion of

LIKE "*2011 Preliminary*"

will find all records where that string occurs anywhere in the field.

Better would be to import it to a memo field in a temporary table and use VBA
code to parse through the string, loading each value into a new record in a
related table. But without knowing how you'll be using the data it's hard to
advise!

Note also that this newsgroup was "killed off" by Microsoft several years ago;
only a few of us undead zombies even look at it. See my .sig for alternatives.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[vjp2.at]

*+-LIKE "*2011 Preliminary*"

THanks much


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[vjp2.at]

oops.. It truncated text at 255... do I use memo?

(I dial up using plain text unix)


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]

 

[John W. Vinson]

oops.. It truncated text at 255... do I use memo?

Yes, if you want more than 255.

(I dial up using plain text unix)

I don't know what you mean by that.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[vjp2.at]

*+->(I dial up using plain text unix)

*+-I don't know what you mean by that.

I'm not using WIndows or broadband

- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]