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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors