Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Indeed, the last step of the query returns error, because {0} in the function return the result as a record typ.
If we remove {0} from function, we need to also replace the last step of the query, because the result will be a table, not a record anymore. I basically removed the last expand step, and I expanded the column again using UI.
August 21, 2019
Wow Catalin, fantastic, basically this function is so powerfully can practically extract any key words in a phrases
I am so grateful your patience in sharing to me your coding
If in summary, Table.ExpandTableColumn can display multiple match (as removing {0} and display in a table (many lines), however, Table.ExpandRecordColumn only the 1st match (0), 2nd match {1} and so on from a phrase
Appreciate your kindness
Chris Yap
1 Guest(s)