I have a text file report and need to reform it into a excel file. Please find the text file format as below,
ABC Company…01-01-2018
DEF Department
Name…Age…Salary…Referral…date of employ
A…30…15000…15-05-2015
B…26…13000…08-08-2016
C…28…16000…D…09-02-2016
It is difficult to manage the data above as the referral column could be null. The (…) mean more than one space. Is there any way to reform it to an excel file?
About extracting table structured data, you can use below pattern inside Matches activity. "(?-s)(\S+) (\d+) (\d+) (\S*) ?((0[1-9]|[12]\d|3[01])-(0[1-9]|1[0-2])-[12]\d{3})"
About retrieving data from match result, please refer to the link.
Hi Yuji, I have some further questions. As after I match the data and build the datatable, it is unable to use the add data row activity. How could I add the data into the datatable in order to create an excel report?