Forum Discussion
Power Query in Power Bi Data Modification
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?
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.
1 Reply
v-yuta-msftCommunity Support
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.