Splitting Text to Columns
Our campaign names are made up of a string of text values combined into one name, as follows:
FY_sbu_pillar_marcom objective_campaign_sub campaign_consumer journey_brand_campaign tactic_weather triggered
I am looking to split each value in this name into it's own column, which I know is something I'm able to do in Google Sheets / Excel. Is this possible to do with a formula in Smartsheet? Or am I just going to have to split the text out in Excel and then paste into Smartsheet?
Answers
-
@Jacob Peterson Is each value separated by an underscore? So you need to look for each underscore and split out a new value accordingly?
Do you know how many columns/values you have in each string?
You could use FIND to locate each underscore, and build on that to parse the string.
If you put equal signs back into each formulae and lay out the sheet with matching names you will see how to extract to sections from the "Text_more text_even more" value.
Cheers,
Dale
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 150 Just for fun
- 72 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!