Posted by Dan McCullough on 11/04/05 21:13

Whos responsible for putting all that information into one field. LOL

On 11/4/05, conditional motion <conditionalmotion@gmail.com> wrote:
> The name like "Roch Small Sum" and others dont change, they will be in
> there whether there is a value associated with them or not.
>
>
> On 11/4/05, conditional motion <conditionalmotion@gmail.com> wrote:
> > Here is what the field content from the database would look like. I
> > have removed any sensitive data.
> >
> > str = "Name;;;;;Grill Transom (GT302)^%%%%% -----
> > Sort;;;;;Find/Replace^%%%%% ----- Calc;;;;;2568.09x^%%%%% -----
> > Type;;;;;Veck^%%%%% ----- PO Number;;;;;^%%%%% ----- Previous Order
> > Number;;;;;^%%%%% ----- Fabric Whole;;;;;Dyna-Dry^%%%%% ----- Fabric
> > Body;;;;;^%%%%% ----- Fabric Yoke;;;;;^%%%%% ----- Fabric
> > Sleeves;;;;;^%%%%% ----- Fabric Panels;;;;;^%%%%% -----
> > ID;;;;;32398^%%%%%^%%%%%%%%%%%%%%%%%%%%%%%%%^%%%%%^%%%%%^%%%%% -----
> > Size;;;;;6.0^%%%%%^%%%%%%%%%%%%%%%%%%%%%%%%%^%%%%%^%%%%%^%%%%% -----
> > Layer;;;;;0^%%%%%^%%%%%%%%%%%%%%%%%%%%%%%%%^%%%%%^%%%%%^%%%%% -----
> > Coords;;;;;147^173^400^%%%%%^^^%%%%%%%%%%%%%%%%%%%%%%%%%^^^%%%%%^^^%%%%%^^^%%%%%
> > ----- ID;;;;;%%%%%32400^%%%%%^%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%^%%%%%
> > ----- Coords;;;;;%%%%%147^110^400^%%%%%^^^%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%^^^%%%%%
> > ----- Back Number
> > Font;;;;;%%%%%Athletic^%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%Athletic^%%%%%
> > ----- Front Text
> > ID;;;;;%%%%%%%%%%32402^%%%%%32403^%%%%%^%%%%%^%%%%%%%%%%%%%%%%%%%%%%%%%^%%%%%^%%%%%^%%%%%
> > ----- Roch Small Sum;;;;;0^%%%%% ----- Cards Med Extra;;;;;0^%%%%%
> > ----- Roch Large Sum;;;;;0^%%%%% ----- Silver Small Corp;;;;;X^%%%%%
> > ----- Gold Medium Corp;;;;;RE^%%%%% ----- Platinum Large
> > Corp;;;;;YRE^%%%%%";
> >
> > That is one field.
> >
> > On 11/4/05, Pablo Gosse <gossep@unbc.ca> wrote:
> > > [snip]
> > > The problem with that is there are about 40 different listings in the
> > > one field.
> > >
> > > Silver Small Corp;;;;;X^%%%%%\n#####\n
> > > Gold Medium Corp;;;;;RE^%%%%%\n#####\n
> > > Platinum Large Corp;;;;;YRE^%%%%%\n#####\n
> > >
> > > being three of them so maybe this is a bettter way of listing it
> > >
> > > ... Silver Small Corp;;;;;X^%%%%%\n#####\nGold Medium
> > > Corp;;;;;RE^%%%%%\n#####\nPlatinum Large Corp;;;;;YRE^%%%%%\n#####\n
> > > ...[/snip]
> > >
> > > Try this:
> > >
> > > $values = array(); // we'll put the extracted vars here
> > > $str = "This is supposed to be your string";
> > >
> > > $tmpStr = explode("#\n", $str);
> > >
> > > foreach ($tmpStr as $foo) {
> > > if (strlen(trim($foo)) > 0) {
> > > array_push($values, substr($foo, 0, strpos($foo, ';')));
> > >
> > > }
> > > }
> > >
> > > HTH,
> > >
> > > Pablo
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

[Back to original message]