Posted by conditional motion on 11/04/05 21:11

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
> >
> >
>

[Back to original message]