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!
Userlevel 2
+17
- Contributor
- 7538 replies
-
4 July 2017
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).
Userlevel 1
+21
- Contributor
- 3079 replies
-
4 July 2017
Find the first and last numbers, clone to get the right number of features then manipulate the attribute
Edit: Snap
Userlevel 4
+25
- Safer
- 2399 replies
-
4 July 2017
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).
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.