hoping this is in the right place here, if not mods feel free to move
while using search and replace in OO writer i am trying to re-format an E Mini tick file.
the file is in following format
12/7/2010,03:30:00,122275,3
12/7/2010,03:30:00,122300,2
12/7/2010,03:30:01,122275,3
12/7/2010,03:30:02,122300,50
now i need an regex which will place a dot (.) after the 4th digit on the close stamp to retrieve the decimal value like this
12/7/2010,03:30:00,1222.75,3
12/7/2010,03:30:00,1223.00,2
12/7/2010,03:30:01,1222.75,3
12/7/2010,03:30:02,1223.00,50
i guess a regex which will find an 6 digit value between two komma's and then place a dot after the 4th digit ?
hoping for some help as i have no clue how to do this, all help will be appreciated
while using search and replace in OO writer i am trying to re-format an E Mini tick file.
the file is in following format
12/7/2010,03:30:00,122275,3
12/7/2010,03:30:00,122300,2
12/7/2010,03:30:01,122275,3
12/7/2010,03:30:02,122300,50
now i need an regex which will place a dot (.) after the 4th digit on the close stamp to retrieve the decimal value like this
12/7/2010,03:30:00,1222.75,3
12/7/2010,03:30:00,1223.00,2
12/7/2010,03:30:01,1222.75,3
12/7/2010,03:30:02,1223.00,50
i guess a regex which will find an 6 digit value between two komma's and then place a dot after the 4th digit ?
hoping for some help as i have no clue how to do this, all help will be appreciated