Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
VinceLuna
Frequent Visitor

remove text

I have records in which some have titles.  Mrs. Sara Jones, Dr. Robert Smith.  

Name.1              Count   Title Made

Sister12Sr.
Sr137Sr.
Sr.32Sr.
Ms35Ms.
Ms.23Ms.
Mrs141Mrs.
Mrs.97Mrs.
Mr15Mr.
Mr.12Mr.
Miss12Miss
Rev8Father
Dr12Dr.
Dr.15Dr.
Deacon3Deacon
 5B
Alexandra5B
Alexandria3B

Is it possible to use your work  and put the all but B into the "PL" marker? 

@mahony pat posted

https://community.powerbi.com/t5/user/viewprofilepage/user-id/226208

 

My goal is to remove the "titles", keep in new column and shift the new text to the left. 

Thanks.

Vince

 

2 REPLIES 2
serpiva64
Super User
Super User

Hi,

it is not clear to me what you want

@serpiva64  you are correct.  I wasn't clear. I have a field Name mixed with titles, firstnames, lastnames, and sometimes extra text after names. There is not consisentency.  

Name

Dr. Sam Smith

Susan White

Bro Elden

Bro Josh White

Sr. Sophia Anna Marie, S.J.

 

I transformed the table as such: 

= Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Name.1", type text}, {"Name.2", type text}, {"Name.3", type text}, {"Name.4", type text}, {"Name.5", type text}, {"Name.6", type text}})

I want to create the table below and don't now how to compare each record for title and then move the text to the appropriate columns. 

 

TitleFirst NameLast Name
Dr.SamSmith
 SusanWhite
Bro Elden
BroJoshWhite
Sr.Sophia AnnaMarie

 

I want to strip Titles out and move them into a field (Title).  I want to find first names and last names, and move them into First Name and Last Name. Some first names are seperated by a space. 

I cleaned up the data base to find these thinking this could be some kind of comparision list. If it find Name.1 then do something (Iike move it to Title and move the next, Name.2 into an empty Name.1, Move Name 3. into Name.2 )

Thanks for the help. 

 

 

Name.1CountName Title
Sister12Sr.
Sr137Sr.
Sr.32Sr.
Ms35Ms.
Ms.23Ms.
Mrs141Mrs.
Mrs.97Mrs.
Mr15Mr.
Mr.12Mr.
Miss12Miss
Rev8Father
Dr12Dr.
Dr.15Dr.
Deacon3Deacon

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors