Скачать с ютуб Split columns where rows have different delimiters/ widths with PowerQuery в хорошем качестве

Split columns where rows have different delimiters/ widths with PowerQuery

00:00 Convert text to columns where each row has different widths 00:10 Convert list to Table and import into Power Query 00:18 Irregular spaces makes splitting to columns problematic 00:44 First remove unnecessary rows (rows that DON'T contain our key row identifier) 01:05 With other rows removed, the field widths become apparent 01:20 Split column based on spaces 01:45 Dates/ times and amounts are in their own columns now 02:00 Correct the data type on the key columns 02:25 Replace points with commas to create a valid decimal number in Power Query How to deal with a data set where we are interested in one part (faxes in this case) but it is mixed into other data and the rows seem to have different split points depending on what is on that row. In this case we need to first group like with like rows (deleting the other rows in this case) and then split the more consistent data set into its own columns.