Forum Discussion
How to delete characters before "." in a string
Hello! I have a text column. it is like:
Dr. Helen Malinpn
Dipl. Wen Yu
Dr.Med. Linda Holm
Dr. Mary Julp
Dr. Med. Msc. Lucas Sobe
What I expect is:
Helen Malinpn
Wen Yu
Linda Holm
Mary Julp
Lucas Sobe
Please help. I tried use replace "Dr. "with null, but then I must list all the possible titles used in the column, which is not easy to find out all the possible titles and their combinations-
Hello Anonymous ,
You go to Power Query => the click at the column => in the transform tab click extract => then click at text after delimiter => and you put the dot
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
5 Replies
- Idrissshatila
Super User
Hello Anonymous ,
You go to Power Query => the click at the column => in the transform tab click extract => then click at text after delimiter => and you put the dot
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- Thennarasu_R
Responsive Resident
Hi Anonymous
try this Measure,
it will help youThanks,
Thennarasu - Thennarasu_R
Hi Anonymous
Use delimeter in Power QuerryThanks ,
Thennarasu
