Hello, I have this record: "50379(T)-50383(T)". What I would like to do, is to transform it into 5 records:
- 50379(T)
- 50380(T)
- 50381(T)
- 50382(T)
- 50383(T)
What is the easiest way to create this list? Thanks!
Question
create list
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi @kat, if I understand the requirement correctly, this workflow might help you.
- StringSearcher: Extract the two number parts from the source string.
- Cloner: Create feature copies of the number of difference between the two numbers.
- AttributeCreator: Create desired value by concatenating the first number + copy number, and (T).
+46- Influencer
Find the first and last numbers, clone to get the right number of features then manipulate the attribute
Edit: Snap
+59- Safer
I just mention it for completeness, but instead of the AttributeCreator I thought about using the Counter. Set Count Start to the first matched part, and _copynum for the counter name. No advantage or disadvantage, just different.
NB: Funnily we'd just talked at Safe about allowing more than one answer to be accepted. This is a perfect example of where this would be useful! Let me know if you think we should allow that (it's a simple switch) and how many answers we would allow to be accepted (we thought a maximum of two).