Forum Discussion
Delimeters - Data Cleansing/Best Practices
Hi, so there were data entries in this column that were separated in the following form: pigs - type - cats but some entries have pigs - types - cats pig-s - type - cats pigs - type...
LivioLanzo
Solution Sage
Solution SageHi Anonymous
You can get the text before the 3rd delimiter with this function: https://docs.microsoft.com/en-us/powerquery-m/text-beforedelimiter
You could add an extra - at the end of each string before calling this function
For the other problem, probablt this function can help you: https://docs.microsoft.com/en-us/powerquery-m/text-replace