Forum Discussion

Nipius's avatar
Nipius
Advocate I
7 years ago
Solved

Remove text between characters

Hi!   I have a column in a Power BI query with names. In case of absence of a person, the system adds (On Leave) to the name of the employee. So, if John Doe is absent for 2 months, the report show...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Nipius ,

     

    I hop[e you have access to edit queries.

    if so these are the steps:

     

    1-  Data looks like this

     

    2- right click and hit on split column , you will get output like this. Hit ok

     

    3. remove the column which was created after splitting.

     

    4. Output looks like this

     

     

     

    Let me know if this works.

     

    Thanks,

    Tejaswi

     

Nipius's avatar
Nipius
Advocate I
7 years ago

Anonymous Thanks for the response!

 

So, originally the data looks like this "Name (On Leave)" or "Name (Name in different writing)". I want everything to look like "Name". So for all the records where there is data between brackets in the records, I'd like to remove this part.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Nipius ,

 

I hop[e you have access to edit queries.

if so these are the steps:

 

1-  Data looks like this

 

2- right click and hit on split column , you will get output like this. Hit ok

 

3. remove the column which was created after splitting.

 

4. Output looks like this

 

 

 

Let me know if this works.

 

Thanks,

Tejaswi