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

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]