When I have a column with sentences like a description column, I may want to extract everything before or after a keyword or simply to extract the keyword. Let´s take an example, I have this column and I want to extract everything before or after this delimiter “:”:
NOTE:
Let´s take another example, I have this column and I want to extract this word “new”:
Now, I have this column and I want to extract “new” (after, before and word) but only if “extract” is found:
If I want to extract words between 2 delimiters, for instance “ - “:
PATHITEM(SUBSTITUTE('table'[argument],"delimiter","|"),2)
To end, I want to extract only x characters after finding a word. For this, I have to go to the “query editor -> add column -> custom column” then put this formula:
Then put this formula:
Text.Start(Text.AfterDelimiter([argument],"value_find"),number_extract)
In my example, I am asking to extract the 4 characters after finding the word “new”
NOTE:
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...