Hi everybody, I have a table which a column contain content as "province_district_ward_2020" and I want to split it into a word. Example:
Before: "HoChiMinhcity_District1_ward1_2020"
After: "HoChiMinhcity" / "District 1" / "Ward 1" / "2020"
I tried use StringPadder or StringReplace but the result which It's not my expected result. I think there are wrongs in my process.
Can you help me know how to work it? Thank you so much!
+20
Consider using AttributeSplitter instead.
Just fill in your delimiter of choice (_).
Use ListExploder afterwards if you want the list elements in attributes.
+30
Just add information to add quotes in the words, you can use transformer for add prefix and sufix = BulkAttributeRenamer
Thank you so much! I will try your idea!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
