• Registered: 2009-12-30
  • Posts: 4

Topic: AWK Script help

Hello. here are few lines of the 1min GBP/JPY and i need it to be 5 min. Could you please help me with the script (AWK)? i want to convert data since 2001 into 5 min ...

THANK YOU
<TICKER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
GBPJPY,20010108,051800,174.90,174.90,174.90,174.90,4
GBPJPY,20010108,051900,174.90,174.91,174.90,174.91,4
GBPJPY,20010108,052000,174.91,174.91,174.91,174.91,4
GBPJPY,20010108,052100,174.91,174.91,174.91,174.91,4
GBPJPY,20010108,052200,174.91,174.93,174.91,174.93,4
GBPJPY,20010108,052300,174.93,174.93,174.93,174.93,4
GBPJPY,20010108,052400,174.93,174.93,174.93,174.93,4
GBPJPY,20010108,052500,174.93,174.93,174.93,174.93,4
GBPJPY,20010108,052600,174.93,174.93,174.93,174.93,4
GBPJPY,20010108,052700,174.93,174.93,174.92,174.92,4
GBPJPY,20010108,052800,174.91,174.91,174.90,174.90,4
GBPJPY,20010108,052900,174.90,174.91,174.90,174.91,4
GBPJPY,20010108,053000,174.92,174.94,174.92,174.94,4
GBPJPY,20010108,053100,174.94,174.94,174.94,174.94,4
GBPJPY,20010108,053200,174.94,174.94,174.94,174.94,4
GBPJPY,20010108,053300,174.94,174.94,174.94,174.94,4
GBPJPY,20010108,053400,174.94,174.94,174.94,174.94,4
GBPJPY,20010108,053500,174.94,174.94,174.94,174.94,4
GBPJPY,20010108,053600,174.93,174.93,174.93,174.93,4
GBPJPY,20010108,053700,174.93,174.94,174.93,174.94,4
GBPJPY,20010108,053800,174.94,174.95,174.94,174.95,4
GBPJPY,20010108,053900,174.95,174.95,174.95,174.95,4
GBPJPY,20010108,054000,174.95,174.95,174.94,174.94,4
GBPJPY,20010108,054100,174.94,174.94,174.94,174.94,4
GBPJPY,20010108,054200,174.94,174.94,174.93,174.93,4
GBPJPY,20010108,054300,174.93,174.93,174.91,174.91,4
GBPJPY,20010108,054400,174.91,174.91,174.90,174.90,4
GBPJPY,20010108,054500,174.89,174.89,174.86,174.86,4
GBPJPY,20010108,054600,174.86,174.86,174.86,174.86,4
GBPJPY,20010108,054700,174.87,174.87,174.87,174.87,4
GBPJPY,20010108,054800,174.87,174.88,174.87,174.88,4
GBPJPY,20010108,054900,174.89,174.89,174.89,174.89,4
GBPJPY,20010108,055000,174.89,174.90,174.89,174.90,4
GBPJPY,20010108,055100,174.91,174.91,174.91,174.91,4
GBPJPY,20010108,055200,174.91,174.91,174.91,174.91,4
GBPJPY,20010108,055300,174.91,174.91,174.89,174.89,4
GBPJPY,20010108,055400,174.89,174.89,174.89,174.89,4
GBPJPY,20010108,055500,174.89,174.89,174.88,174.88,4
GBPJPY,20010108,055600,174.87,174.87,174.83,174.83,4

  • Registered: 2009-12-30
  • Posts: 4

Re: AWK Script help

no idea how to work out with this script, the problem is i cannot really do much in excel either because it does not load the whole thing, the .txt file is 156 MB, is 1 min data and i need to make into 5 min data for 10 years... and i do not know how to work with the AWK Converter, above are few lines of the data.

PLEASE HELP with the script

THANK YOU