cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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 4
Super User
Super User

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

@TheKiltedGolfer it seems to be doable, if you can share sample data, it will help to get the solution. 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





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

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.

 

STS Sample Snipit.JPG

Highlighted
Super User
Super User

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

@TheKiltedGolfer just checking if maximum # can be 3 ?






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





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

I believe that is correct, up to the date of my reply.  I hope it does not increase to 4 or more but the max number of times a single column should need to be split into individual columns is 3. 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 141 members 1,485 guests
Please welcome our newest community members: