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

Question

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 "/".

ScottLewis · Answer

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.

NoRegexJobIDParse.yxmd

JosephSerpis · Answer

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

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

Regex_12092023.yxmd