[Golith]

Hi ppl,
i just got some data in a csv file.

1896-10-26,51,0,0,51.72

I am trying to get the date to look like this 10/26/1896 - US date format

any quick PHP solution to look at the comma deliminated csv file and change it would be appreciated. There is litteraly over 10,000 lines so doing it by hand before uploading to my db is quired

regards
Scot

I kno its simple i just forgot how and have to much going on to sit down and figure it out.

[alxkls]

this might give you a head start:

Code:

$values=preg_split('/(,)(\d+)(,)(\d+)(,)(\d+)(,)(\d+)(\.)(\d+)/is', '1896-10-26,51,0,0,51.72');
$real_date = explode('-', $values[0]);
$real_date=$real_date[1].'/'.$real_date[2].'/'.$real_date[0];
echo $real_date;

[Golith]

ty for the reply .. it does work well.
Merry Xmas