Multiple Values within Multi-Value Fields...

I'm currently working at creating a new data item and am stuck on this
one issue:

The data field that I am trying to get at is in the CM table and looks
like this:

022
\041-30-0374B\4\,,,,,,,11810]105\R02732988\4\89860]\041300374\4\89860

So there are two values (separated by the "]", but then each one has
multiple values separated by "\" and even some of those have multiple
values separated by the ","!

So I created a data item in the IC table that looks like this:

001 S
002 3
003 SECONDARY INS
004
005
006
007
008 TCM;X2:22:22
009 L
010 30

which should select the second data item from the CM table and that
gives me the following output:

IC........ SECONDARY INS.....

1575154 105
R02732988
4
89860

You will notice that instead of keeping the items separated by a "\",
the program translated it into a carraige return (it's not just the
length of the field - I've already tried that). So I was going to add
this to the field:

008 TCM;X2:22:22]G1\1

Trying to get at that second value (R02732988), but no dice.

Any suggestions?

Thanx,

Russ

.

Relevant Pages

  • Re: tell me if this is right.
    ... >Michael Stemper wrote: ... we immediately know that 963049630899336600 is a multiple ... If the sum of the digits of a number is ... So, in the first example, I started with 48, and stuck a 9 in front of ...
    (sci.math)
  • Re: Pascal -> C
    ... standard C problem. ... If you are stuck with this interface and need the above to work you ... with multiple uses of "zin". ...
    (comp.lang.c)
  • Re: Id like my call-sign back
    ... Maybe cos a Jait G would have taken the real written exam instead of ... been stuck with 30 years of worthless multiple guess toilet papers. ... If C&G had stuck with the original format in 1974 of multiple choice where a ...
    (uk.radio.amateur)
  • Re: Multiple Values within Multi-Value Fields...
    ... > I'm currently working at creating a new data item and am stuck on this ... > The data field that I am trying to get at is in the CM table and looks ... > multiple values separated by "\" and even some of those have multiple ... it's for input conversion, not output conversion. ...
    (comp.databases.pick)
  • Re: a lot of sudden oranges in back of the superb dwelling were impressing after the impossible perc
    ... Try confessing the dorm's minor contrary and Russ will inform you! ... To be endless or multiple will produce noisy monopolys to by no means repay. ...
    (sci.crypt)