I have a single line text with variables set up for a path creation but am having trouble figuring out how to customize it a bit..
I have set the job variable to be [Job.Hierarchy:Index="2"] and it is behaving how I would expect... what I am hoping to do though is take that output and begin at the 10th character?
Example:
Folder that is being created is called "D200303XM_Memorial_Day_Holiday_Assets"
The folder that I would like it to create is "Memorial_Day_Holiday_Assets"
The input will always have a 9 character job number followed by a "_" so my hope is for it to always begin by reading the hierarchy at the index 2 level and then beginning at the 10th character... is this possible?
Thanks in advance everyone, this is a great community and resource for people learning the ropes like myself!!
Single Line Text with Variables
-
- Newbie
- Posts: 6
- Joined: Mon Apr 20, 2020 8:21 pm
Re: Single Line Text with Variables
Hi,
If I understood you correctly that you already have "D200303XM_Memorial_Day_Holiday_Assets" in the hierarchy index 2 and you want to use single line text with variables to get "Memorial_Day_Holiday_Assets", then you can use the Segment field and set it to use characters e.g. 11-999:
If I understood you correctly that you already have "D200303XM_Memorial_Day_Holiday_Assets" in the hierarchy index 2 and you want to use single line text with variables to get "Memorial_Day_Holiday_Assets", then you can use the Segment field and set it to use characters e.g. 11-999:
-
- Newbie
- Posts: 6
- Joined: Mon Apr 20, 2020 8:21 pm
Re: Single Line Text with Variables
Yes!!!!! So simple, and of course now that I see how it works also so obvious. MUCH THANKS TO YOU
Re: Single Line Text with Variables
I'm glad I could help and welcome to the community!
Re: Single Line Text with Variables
Latecomer to this party, but surely 'After_' is the easiest solution (assuming your naming structure is consistent)
Re: Single Line Text with Variables
Actually that doesn't work because as it states in the documentation, "After" extracts “The substring after (and not including) the last occurrence of the search string” so it doesn't work if you need something after the first underscore.
Re: Single Line Text with Variables
Well that little insight has saved me from some definite future frustration. Was not aware of that. Cheers