Forum Discussion

dev814's avatar
dev814
Regular Visitor
5 years ago
Solved

Eliminate middle initial from row

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 nee...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

You can use Text.BeforeDelimiter:

 

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

 

---Nate