Using Regular Expressions in Power Query
Вставка
- Опубліковано 30 чер 2023
- In Power Query, you can utilize the Web.Page function to execute JavaScript code. For more detailed information, please refer to the link below.
Download Excel File : docs.google.com/spreadsheets/...
address for reference : www.thebiccountant.com/2018/0...
You, sir/ma'am, are an effing genius!
Genius!
One note for people having troubles with quotes. You have to escape them upfront. Just add a new step at the beginning.
str = Text.Replace(str, """", "\"""),
Impressionnant, généralement de vos exemples.
N’étant pas informaticien, j’avoue que là c’est du lourd.
Mais comme d’habitude, c’est franchement trop top.
Hi this does not work for situations where values are not unique?