Hi Catalin, Attached, how to return in this format, possible ? Description of text verbatim Region //Level 1/Camp ABC/Bunk A ...
Hi Catalin but when I remove the {0}, all shown error
Catalin Bombea said First, I add the lookup table as a query, just like any other table, ad I perform the operations I need to get the result I need:...
Catalin, How about the questions on not showing the invoked function in the queries list ? that is under the Text (optional) enter a text then cli...
Hi catalin, so each time I append new phrases and the result, the function code will automatically update right ?
Hi Catalin for the match function, you are using Advanced editor to input M code directly right, or UI ? = (Text)=> let Source = Excel.Curr...
Thank you so much Catalin, this is the first time I see function and parameter in PQ, after adding CampAB = C and refresh it returns correctly, am...
thank you so much Mynda for your tips as for the CampAB without space, user will need to constantly update their library
Hi Mynda, Actually, the actual datasets are proj description and was trying to do text analytics, and there is a table (List) that store all the t...
Hi Mynda, what version of excel you are using = Table.AddColumn(#"Changed Type", "Text Between Delimiters", each Text.BetweenDelimiters([Folder ...
Hi Mynda, Thanks, this is for delimited that are consistent throughout in my real case scenario, the description can be free form see attache...
Hi Catalin, I get what you mean, 898 got no "Everyone","UserDomain user" at all, this is not true in real environment, I didn't mock the data a...
Catalin are you able to explain your formula as layman as possible Thank you very much
Catalin, thank you so much on your expertise in PQ, really appreciate it