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