Power Query in Power Bi Data Modification

[davidwhite83]

Power query in PBI, I am trying to find and replace a value that has a return in a cell. I am trying to replace the value with just the employees name. 

I need it to go from SCOTT D HALL_x000D_ 208580 to just Scott Hall....also his name placement may change each month so how do I have power query recongize his name is in another location and modifies that information?

[v-yuta-msft · Accepted solution]

@davidwhite83 ,

Generally, you can splite the column by custom separator like " " and "_", then remove the useless columns and combine the two left columns.

Or you can regular expreesion to match the pattern using python or R.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.