Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

What formula can I utilize to return cell values only after a specific character ("/")?

JoshuaElphee
8 - Asteroid

My current workflow utilizes a column "job ID" to perform a few actions and save a new sheet to a single excel file for each unique value in "job ID" (example "job ID" = ABC123 for a few rows and XYZ987 for a few others... the output creates a workbook with tab/sheet "ABC123" in which each row showing ABC123 in "job ID" is pasted; and the same for XYZ987).

 

I now have excessively long job ID's which build off of the basic job ID, where original job ID shows, with the character "/" before the remainder of the job ID (ex. ABC123/HTPFJ7842).

 

My Alteryx workflow no-longer works, as there is a limit to the name size of a tab in excel.  To mitigate this, I wish to take the job ID only after the character "/", and continue the workflow.  In this way, my output would have a tab not of "ABC_HTPFJ7842", but only "HTPFJ7842".

 

How do I make this feasible?  *In the case that job ID has TWO "/"'s (ex. ABC123/HTPFJ7842/4567), I want to keep everything after the FIRST "/".

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @JoshuaElphee one approach you can take is to use regex. Regex_12092023.JPG

 

Using /(.*) with the option of Parse in the Regex tool will parse everything to the right of the first slash.

ScottLewis
11 - Bolide

NoRegExJobiIDParse.PNG

Attaching a non RegEx solution in case that's how you roll. (Noting that this is about the simplest of RegExs to read.)
I would use Text To Columns for this. By setting the number of output columns to 2 we get everything after the 1st slash in the second output column, including any other /s. 
   

Labels
Top Solution Authors