Zhao Ji Ma , Thank You for your reply. I have tried it and it works. I was also searching the forum for help and came across http://forums.iis.net/p/1144790/1852237.aspx#1852237. Using it as a guide, here is the solution I made. The EXTRACT_TOKEN functions are used because the date and time strings were...

Running this: "select distinct FILE_NAME, STRCAT ( STRCAT ( EXTRACT_TOKEN( LAST_EDIT, 2, ' ' ), ' '), EXTRACT_TOKEN( LAST_EDIT, 4, ' ' )) AS Time from Records.txt ORDER BY FILE_NAME" -i:TSV ... returns: FILE_NAME TIME File1 LAST SAVE: 04/10/08 @ 13:19:15 BY: TM PLOT...