Forum Discussion
Basic Data Engineering | M Code Noob | How to extract only what you want into a new column?
Hi folks, I've been using PQ easy UI for a while now, but am realizing that I will eventually have to start learning M CODE to fulfill certain requirements. I have a flat CSV file with client...
Type this into the formula bar:
= Table.AddColumn(#"Name of Table or Previous Step Name", "New Column", each if Text.Contains([Consultant Role], "mROC Lead") then Text.Replace([Consultant Role], "mROC Lead", "") else "")
--Nate
Type this into the formula bar:
= Table.AddColumn(#"Name of Table or Previous Step Name", "New Column", each if Text.Contains([Consultant Role], "mROC Lead") then Text.Replace([Consultant Role], "mROC Lead", "") else "")
--Nate
Thank you !!!!