[Resolved] String Help

ChaosT

Hi,

I am working with a databse that has a field - the content of which looks like this:

1,33|2,IMS|3, 2004|4,39.5|5,1|12,0.84|13,0.84|14,0.26|15,0|16,0|17,40|33,0|32,Other Charges|20,1|21,17.5|24,4006||

Basically, it is a rate card.

the number after the pipe symbol denotes the rate card item and the text or numbers after the comma is the rate card value. The double pipe signifies the end of the rate card.

I have another database with field numbers 1 - 35. I need to exctract the data from that string and insert it into the database.

Essentially then, based on the above example, i am looking for output similar to this:

$n1 = 33
$n2 = ims
$n3 = 2004

Any help or the combination of functions i need would be gratefully appreciated!

Regards

ChaosT

mrhappiness

$x = '1,33|2,IMS|3, 2004|4,39.5|5,1|12,0.84|13,0.84|14,0.26|15,0|16,0|17,40|33,0|32,Other Charges|20,1|21,17.5|24,4006|| ';

preg_match_all('%,([^\\|]+)%s', $x, $matches);
$matches = $matches[1];
print_r($matches);

hth

ChaosT

mrhappiness,

thanks for the help.

Yes, something along those lines should do it .

However, the identifier is not the same on every string. For example, in this string, fields 6-11 are not included, but in another string they maybe.

Therefore, i need to keep the number that has been replaced by the [#]=> in the resultling array - am i making any sense?

Thanks

ChaosT

Ok - i can sort of do it this way:

$x = '1,33|2,IMS|3, 2004|4,39.5|5,1|12,0.84|13,0.84|14,0.26|15,0|16,0|17,40|33,0|32,Other Charges|20,1|21,17.5|24,4006|| '; 
 $detail = explode("|", $x);
   $d = $detail[1];
   $d = explode(",", $d);

outputs:

[0]=> 1
[1]=> 33

But this is very messy and far too verbose. There must be a better way :bemused:

edit - ignore this post - this does not work (well it does with like 50,000,000 lines of code!)

mrhappiness

preg_match_all('%(\\d+),([^\\|]+)%s', $x, $matches);

$data = array();
foreach ($matches[1] as $key => $match)
	$data[$match][] = $matches[2][$key];

print_r($matches);
print_r($data);

$matches[1] contains the part ion front of the comma
$matches[2] contains the part after the comma (and in front of the pipe)

$data contains the part in front of the comma as array-index and the values as array-elements in 2nd dimension

output for 1,33|2,45|1,48|12,Hallo|| would be ($matches, $data)

Array
(
    [0] => Array
        (
            [0] => 1,33
            [1] => 2,45
            [2] => 1,48
            [3] => 12,Hallo
        )

[1] => Array
    (
        [0] => 1
        [1] => 2
        [2] => 1
        [3] => 12
    )

[2] => Array
    (
        [0] => 33
        [1] => 45
        [2] => 48
        [3] => Hallo
    )

)
Array
(
    [1] => Array
        (
            [0] => 33
            [1] => 48
        )

[2] => Array
    (
        [0] => 45
    )

[12] => Array
    (
        [0] => Hallo
    )

)

ChaosT

Yeah - got it. works a dream

thanks MrHappiness