Forum Discussion
Remove Text in a specific Column
Hi Anonymous
Please fo the following
Please also make sure to use a space behind Ms or Mrs.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi Anonymous
I also built a more lean solution. with an Added Column.
if Text.StartsWith([Column1],"Mr ") or Text.StartsWith([Column1],"Mrs ") or Text.StartsWith([Column1],"Ms ") then Text.AfterDelimiter([Column1], " ") else [Column1]
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Mike,
Thanks for this solution. Is there a way to add a search in a table with common prefixs? I'd rather automate the replacements based upon the everchange master data set. I have a dataset that includes DR, dr DRS. Mrs, Miss, Ms, MS, Deacon, Dcn and other combinations. I can compile a list form the data using splitter to find the most prevelant prefixes. The list looks like:
Name.1 Count Title Made
| Sister | 12 | Sr. |
| Sr | 137 | Sr. |
| Sr. | 32 | Sr. |
| Ms | 35 | Ms. |
| Ms. | 23 | Ms. |
| Mrs | 141 | Mrs. |
| Mrs. | 97 | Mrs. |
| Mr | 15 | Mr. |
| Mr. | 12 | Mr. |
| Miss | 12 | Miss |
| Rev | 8 | Father |
| Dr | 12 | Dr. |
| Dr. | 15 | Dr. |
| Deacon | 3 | Deacon |
| 5 | B | |
| Alexandra | 5 | B |
| Alexandria | 3 | B |