Forum Discussion

RingoSun's avatar
RingoSun
Icon for Helper II rankHelper II
4 years ago
Solved

Splitting a text in a column

Inside a column I have values such as: Column Test Nice Product Test 1 Product Test 2 Good Product Test 3 Product I want to do the splitting inside the same column (I don't wa...
Need Help
jaipal's avatar
jaipal
Icon for Resolver III rankResolver III
4 years ago

RingoSun there are multiple ways to do it. One of them is as follows

 

RingoSun's avatar
RingoSun
Icon for Helper II rankHelper II
4 years ago

jaipal 

I've been trying to experiment with that option but I just cant seem to get my desired output

  • jaipal's avatar
    jaipal
    Icon for Resolver III rankResolver III
    4 years ago

    RingoSun because rows has data with many spaces. You can try Ashish_Mathur 's solution or you can try with DAX something like:

    column= Left/right('table[column]', 6]