![chrome word replacer exact match chrome word replacer exact match](https://wd.imgix.net/image/BrQidfK9jaQyIHwdw91aVpkPiib2/Vl5ixHwhHp2lUc8Y0qvY.png)
Hot water unit toilet block need replacement leak flood toilet block The above 1) and 2) will use the nested text.splitany() by spaceĭvk lock toilet cubicle door portacom smoko sheed missing lockĮntry door design hand injury potential due proximaty lock door jambĪy lock mechanism switchyard b man gate accept keyĬondenser internal door lock ac fall apart My predefined list is shorten the if-else will go through in the order like below:ģ) ntain ("lock", "padlock", "locksmith") I cleaned the data from R, so there is no singular and plura problem.
![chrome word replacer exact match chrome word replacer exact match](https://miro.medium.com/max/1200/1*nfV2tpL0ZwXxwkJXjUO_Vg.png)
Table.AddColumn(Gate, "Door & Door Hardware", each if(List.ContainsAll(Text.SplitAny(, " "),)) then "lock" else if(Text.Contains(, "lock")) then "lock" else "" ) For example, it thinks the work description with words "blocked toilet." is a "lock" problem now just because "block" has "lock". It now returns the work order decription contains string "^lock" to me. This is a huge dataset normally more than 10k rows.īefore I run below script I'll get work order description related to lock issue easily. However, the fuzzy match makes my life difficult. My input text is work order description (the context of these description is mainly about building fabrics). Can anyone tell me if there is a workaround?
![chrome word replacer exact match chrome word replacer exact match](https://miro.medium.com/max/640/1*aODGDr70aFQWE7ZZo3NR4A.jpeg)
Before the first character in the data, if the first character is a word character. Strictly speaking, '\b' matches in these three positions: 1. By itself, it results in a zero-length match. It matches at the start or the end of a word. I used to run some M functions in power query to do keywords searching and assign these rows with specific keywords to a category. The regular expression token '\b' is called a word boundary.