15.6 Parse and extract dates


The following table stores the event memo information:


For the convenience of future statistics, we want to extract all the date data from each row, and put them in the next column after separating by semicolon, like this:


Enter in cell B1:

=spl("=?1.split("" "").(date(~,""dd.MM.yy"")).select(ifdate(~)).concat("";"")",A1)

Then drag B1 down to every relevant row.

Split the string with spaces to form a sequence;
Convert the text string in the sequence to the date type data according to the specified format;
Select the date type data and concatenate them into a string with semicolon.

esProc Desktop and Excel Processing
15.5 Parse and extract numbers
15.7 Take out different types of characters