Re: reg ex help

explode on this first: '^%%%%% -----' then probably on explode ';' like Jay mentioned. then you can probably massage the really weird stuff into shape somehow, stuff like (wtf :-)): Back Number Font;;;;;%%%%%Athletic^%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%Athletic ..hth conditional motion 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