I have an attribute [complete] withe the value 1-A.
I would like to split that value to attribute [split1] with the value 1
and attribute [split2] with the value A
I've tried AttributeSplitter;AttributeTrimmer;AttributeCreator
Solved
Split attributevalue into 2 different attributes
Best answer by courtney_m
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
+12- Contributor
- Best Answer
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
+18- Contributor
courtney_m wrote:
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
+18- Safer
Hi @kees_v, you can accomplish this using the AttributeManager as well. If you're splitting by only one character on each side of the -, you can set the transformer parameters as they are below:
+12- Contributor
erik_jan wrote:
Or follow the AttributeSplitter by an AttributeCreator to create [split1] with value _list{0} and [split2] with value _list{1}.
courtney_m wrote:
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
courtney_m wrote:
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
Anyway, I think the AttributeSplitter would be a general way to split a string by a specific separator character or string.
+38- Influencer
fmelizard wrote:
Hi @kees_v, you can accomplish this using the AttributeManager as well. If you're splitting by only one character on each side of the -, you can set the transformer parameters as they are below:
e.g.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.