Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago
Solved

Power Query | Replacing Text Recommendation (Wildcard/RegEx)?

Hi, I have a very simple problem, so Im still working on names... full names unfortunately there are some inconsistencies that I wanted to fix.   For example there's a       <Last Name><comma><Fi...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Apart from combining multiple steps in 1 line, I don't see any way.

     

    2 Alternatives:

     

    Table.AddColumn(Source, "Custom", each Text.Combine(List.Transform(Text.Split([Name],","), Text.Trim),", "))

or

Table.AddColumn(Source, "Custom", each Text.Replace(Text.Replace([Name],",",", "),",  ",", "))
MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

Apart from combining multiple steps in 1 line, I don't see any way.

 

2 Alternatives:

 

Table.AddColumn(Source, "Custom", each Text.Combine(List.Transform(Text.Split([Name],","), Text.Trim),", "))

or

Table.AddColumn(Source, "Custom", each Text.Replace(Text.Replace([Name],",",", "),",  ",", "))