|
|
Posted by Jochem Maas on 11/04/05 21:52
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
>>>
>>>
>>
>
Navigation:
[Reply to this message]
|