Forum Discussion

TheKiltedGolfer's avatar
TheKiltedGolfer
Helper III
7 years ago

How to split column based on first character until first space?

I have a 'Short Description' column that will either start with a '#" character or not AND it may have mulitple '#' in the description.  I need to create a new column for every '#' and keep all of the following characters after the '#' until there is a space.  Therefore, based on the text in the column, the text may NOT need to be split into columns.  The two new columns would be titled "Hashtag 1" and "Hashtag 1 Description."  That means if there is not a '#' as the first character that "Hashtag 1 Description" will be empty.  I would then use the same DAX on the newly created column "Hashtag 1 Description," because there may be multiple "#" in the origianl description, to create two new columns.  Then I plan on doing this one more time to split the column because right now the max is three '#' in the description.  Does anyone have any idea how I can do this?

 

Thanks

 

 

4 Replies

    • TheKiltedGolfer's avatar
      TheKiltedGolfer
      Helper III

      Thank you for your assistance.  Below is a sample of my "Short Description" column.  Not sure if it can all be written in one DAX formual or not.