Question

How to use String Functions in Attribute Manager to split text?

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!

+23

Consider using AttributeSplitter instead.

Just fill in your delimiter of choice (_).

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

+51

Just add information to add quotes in the words, you can use transformer for add prefix and sufix = BulkAttributeRenamer

Partner Solutial Brazil - www.solutial.com.br

Thank you so much! I will try your idea!

3 replies