Skip to main content
  • EN

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!

Consider using AttributeSplitter instead.

Just fill in your delimiter of choice (_).

Use ListExploder afterwards if you want the list elements in attributes.

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!

Reply


Community Stats

30,177
Posts
114,548
Replies
37,838
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.