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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Nipius ,

 

A little confuse with your requirments.

 

Do you want the output to look like this? or do you want to remove (on leave) in your report?

 

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