Is there a way using “morph” to strip text ahead of say the 4th underscore in the example below? We’re setting up a variable data print job that will call the file name, but we also need to break out the school code, grade, and teacher.
Thanks for that, Gary. I’d already figured out how to get everything after the last . Now I’m trying to get everything before the "" so I can bust out the Teacher, Grade & Location. I “misspoke” when I said “strip” up above. I really need to keep just everything before the 4th underscore in the new field and I can take it from there…
Got it Gary once I realized that F19 was common to all the strings, I was able to break it apart from there. Thanks for the assist! I always learn things here!
I know you have your solution but I thought I’d put out another alternative approach. You can use arrayrange( to get the first 4 elements or the array( function to pick out individual elements of the string.