Eliminate middle initial from row

[dev814]

I have a large data set. 

I have a column with first names, however, some of the rows have first names that also include middle intials or middle names.  

Example...

Mary A.

Mary Ann

I need to eliminate the middle intial/name from the row.  It has to be first name only in the first name column.

[Icey · Accepted solution]

Hi @dev814 ,

Try this:

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Anonymous]

You can use Text.BeforeDelimiter:

Table.TransformColumns(PriorStep, {{"Name", each Text.BeforeDelimiter(_, " ")}})

---Nate

[dev814]

Unfortunetly that didn't work at all

[mahoneypat]

Have you tried the Column from Examples feature?  Would likely work well for this.

Add a column from an example in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Pat