string problem

scialom

Hi I have this string :

9 00:02:10:10,00:02:15:02,11
10 00:02:10:10,00:02:15:02,11

I need to convert them to:
9 00:02:10:10 00:02:15:02:11
10 00:02:10:10 00:02:15:02:11

instead of the middle ',' I neet to put tab, and instead the last ',' I need to put ':'

how can I do it?

thanks,
Assaf

codeDV

This works:

<?php preg_replace("/(.+),(.+),(.+)/", "\\1\t\\2:\\3", "9 00:02:10:10,00:02:15:02,11"); ?>

The power of regular expressions.😃

scialom

Hi,

This is good only fot the first line - but I need it for both - In fact each line is a var, and I have a lot of lines...

Assaf

codeDV

<?php
$string = "9 00:02:10:10,00:02:15:02,11\n10 00:02:10:10,00:02:15:02,11\n9 00:02:10:10,00:02:15:02,11\n";

echo (preg_replace("/(.+),(.+),(.+\n)/","\\1\t\\2:\\3", $string));
?>

This cures it. You got to make sure that all new lines consit of just a /n and not /r/n.

The regular expression /(.+),(.+),(.+\n)/ :

The first (.+) means match any charater expcept newline,
The "," means match a literal comma,
Then (.+) again to match any character,
Then match a literal comma ",",
Then the final (.+) to match the last part of the string.
Then at the end we match the literal \n (newline) character.

scialom

Hi,

this is what I get when Try it:
: : : : : : : : : : : : : : : : : : : : : :

Assaf🙁

codeDV

Thats weird. When I post two backslashes \ using the PHP tags it changes it to one. The second argument in the preg_replace function should read "\1\t\2:\3". Instead of printing the the values in your origional string it printed the ASCII values 1,2, and 3. The corrected code is below.

<?php
$string = "9 00:02:10:10,00:02:15:02,11\n10 00:02:10:10,00:02:15:02,11\n9 00:02:10:10,00:02:15:02,11\n";

echo (preg_replace("/(.+),(.+),(.+\n)/","\\\\1\t\\\\2:\\\\3", $string));
?>