regex - Find and replace in notepad for large file++ -

i have xml file has 9000 lines in it.

each xml node has 10 attributes in it.

one of attributes is:

<createddate>2009-10-26t02:39:24</createddate>

what need change format of datetime to:

<createddate>27/05/2010 07:30:16</createddate>

but not know how it.

i know write regex identify each value needs replaced, how can make change values want , maintain rest?

i have thought writing macro, document big format in way predict element want ot change is, , searching not seem work on macro.

any ideas? - sure can done.

if want change datetimes format inside <createddate> tags, try regex replace in notepad++ this:

replace this:

<createddate>(\d{4})\-(\d{2})\-(\d{2})t([\d\:]*)</createddate>

with this:

<createddate>$3/$2/$1 $4</createddate>

we refer each parentheses using $ symbol , it's position, can use values in replacing result.

TSQL