Hello.
I am looking to split some of the attributes of a filed into 2 separate fields while rest stay in the main field contents. even the split one part goes to separate field and rest stays in.
example I have following data:
Banana 24
Banana 25
Banana 26
Banana 27
Apple 01
Apple 02
Apple 03
Apple 04
Pear
Pear
I want it like Banana stays in original field and 26 goes to separate field.
but nothing happens to pear.
I tried using tester to filter them out then attribute manager with string function to replace but length is not same for all attributes how do I handle different length?
Thank you
Nikki
Best answer by hkingsbury
View original