Enable Regex to increase the power of powerquery. Some function such as split column and extract are good but could be great if custom regex could be used to pattern match more effectively.
Please add text transformation and filtering ability based on open and common standard Regular expression to Data Factory (Power Query engine). Currently there are only very simple excel-like function, which are unusable for real work.
Please vote here and on this idea: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=1395c308-7f92-4321-8e35-6cd04d7108bf
