/profile-content.jspa?filterID=contentstatus[published]&targetUser=20113 Recent content in Tableau Community Forums en Thu, 07 Mar 2013 15:45:24 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-03-07T15:45:24Z en https://community.tableau.com/thread/124169 <!-- [DocumentBodyStart:d6f119b9-8652-4dac-bbe2-72e015099a95] --><div class="jive-rendered-content"><p><span style="color: #0000ff; font-size: 12pt;">Hi, </span></p><p><span style="font-size: 12pt;"><span style="color: #0000ff;">I am very new to Tableau and I am working on a time sensitive project using the tool.&#160; I am trying to break down a string that is part of an Excel upload that is encrypted with information regarding location of data. The string contains information on the name of the report, the category within the report the data is from and the row associated.&#160; The information is separated with a "_"&#160; (for example, the data from Report X, category Y, row Z will show up as X_Y_ Z )&#160; The categories and rows can be either numbers or letters up to 2 characters.&#160; What function will allow me to search using the "_" as the key and group the data into the buckets associated with each category and rows?&#160; I've spent hours on this already.&#160; </span><strong style="color: #0000ff;">ANY HELP IS GREATLY APPRECIATED!!&#160; </strong></span></p></div><!-- [DocumentBodyEnd:d6f119b9-8652-4dac-bbe2-72e015099a95] --> tableau data calculated field extract actions excel paramaters Thu, 07 Mar 2013 15:45:24 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/124169 2013-03-07T15:45:24Z 6 years 4 months ago 2 0