Forum Discussion

Poornima2023's avatar
Poornima2023
Icon for Helper I rankHelper I
2 years ago
Solved

Seperate words in direct Query

Hi,   In power bi i have direct query. I have one column where i need to seperate words in different column. NAME/AGE/Class   So I want all to per seperated where "/" is found. Not able to use d...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Poornima2023 ,
    I’d like to acknowledge the valuable input provided by the amitchandak  . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 
    In my investigation, I took the following steps:


    Create three columns

    Name = LEFT([Column], FIND("/", [Column]) - 1)
    Age = MID([Column], FIND("/", [Column]) + 1, FIND("/", [Column], FIND("/", [Column]) + 1) - FIND("/", [Column]) - 1)
    Class = RIGHT([Column],FIND("/",[Column])-1)

    Final output

     

    Best regards,

    Albert He

     

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

     



     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Poornima2023 ,
I’d like to acknowledge the valuable input provided by the amitchandak  . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 
In my investigation, I took the following steps:


Create three columns

Name = LEFT([Column], FIND("/", [Column]) - 1)
Age = MID([Column], FIND("/", [Column]) + 1, FIND("/", [Column], FIND("/", [Column]) + 1) - FIND("/", [Column]) - 1)
Class = RIGHT([Column],FIND("/",[Column])-1)

Final output

 

Best regards,

Albert He

 

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