Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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