how to replace white spaces in text file to upload in grid

Question

Dear All,

 

I need to upload a text file in data grid, which is having multiple white spaces within the given data. If you go through the sheet, I have three columns(EMP_ID, DATE/TIME and CODE ) to port data in datagrid.

Here, main problem is,  Inconsistancy between columns. between EMP_ID and Date/Time, there is no fix space defined but this space is always more than single while space.

similarly, Date/Time and Code also do have more than single while spaces. If we consider Date/Time column values in the sheet, we found single white space.

 

I am looking for a solution where i can upload the same sheet in data grid in three columns only. If white spaces is more than one then consider next value in new column else in the same column( Date/Time column values). Since Date/Time column having single white spaces, all the date time values will be consider in the same column only.

 

Guys, please help me on this case.  I have to make this solution ready on priority basis in my company. If possibe, please upload the C3 code which can be used to complete this requirement.