Splitting Attributes by number of words

If you want to split the attribute at every space, you can use the AttributeSplitter, with a space as the delimiter.

If you want to be more specific, you can use a StringSearcher with a regular expression of something like this, but replace the _ with spaces:

^[^_]{3,}_

This will start at the beginning of the string and find the first 3 or more characters other than a space, followed by a single space. You can replace the 3 with any number. You can then use the string functions within an attribute manager to split the string.

Basically I need to split a text string at the first space after 19 characters.

I was thinking of using a stringlengthcalculator to find the length of the strings and only send ones that are longer than 20 characters through the necessary transformers. The ones that are longer will go through an attributesplitter that splits the line at the first space after the 19th character. Then I calculate the length of the string in _list(1) and if it is longer than 20 I send it through another series of identical transformers to split that line into multiple lines at the first space after the 19th character. I then continue to do this until I have however many lines of text to manipulate.

For example.

Address = Ideal Place Construction 1234 North Fulton Street Pickerington Ohio 12345 USA

- would be split into -

_list(0) = Ideal Place Construction

_list(1) = 1234 North Fulton Street

_list(2) = Pickerington Ohio 12345

_list(3) = USA

I could then rebuild the string using a stringconcatenator to be

Ideal Place Construction

1234 North Fulton Street

Pickerington Ohio 12345

USA

@ReplaceRegEx(@Value(address),(.{19,}?)\s,\1
)

This worked for me too. I was looking for a way to split a large piece of xml, in order to be able to insert it with a PLSQL