Is there a way using a regular expression to split a string of text such as an address by a number of words/spaces? Or even more functional, split a line at the first space after a certain number of characters?
Solved
Splitting Attributes by number of words
+10- Contributor
- 41 replies
Best answer by takashi
Hi @gmbutler2, the StringReplacer with this setting transforms a single line address string into your desired multi-line string at once.
- Mode: Replace Regular Expression
- Text To Replace: (.{19,}?)\s
- Replacement Text: \1<newline character>
Alternatively, this string expression does the trick too. Assuming that an attribute called "address" stores the original single line address string.
@ReplaceRegEx(@Value(address),(.{19,}?)\s,\1
)
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+19- Contributor
- 127 replies
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.
+10- Contributor
- 41 replies
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
+10- Contributor
- 41 replies
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
- 7842 replies
- Best Answer
Hi @gmbutler2, the StringReplacer with this setting transforms a single line address string into your desired multi-line string at once.
- Mode: Replace Regular Expression
- Text To Replace: (.{19,}?)\s
- Replacement Text: \1<newline character>
Alternatively, this string expression does the trick too. Assuming that an attribute called "address" stores the original single line address string.
@ReplaceRegEx(@Value(address),(.{19,}?)\s,\1
)
- Contributor
- 41 replies
Hi @gmbutler2, the StringReplacer with this setting transforms a single line address string into your desired multi-line string at once.
- Mode: Replace Regular Expression
- Text To Replace: (.{19,}?)\s
- Replacement Text: \1<newline character>
Alternatively, this string expression does the trick too. Assuming that an attribute called "address" stores the original single line address string.
@ReplaceRegEx(@Value(address),(.{19,}?)\s,\1
)
- Participant
- 2 replies
Hi @gmbutler2, the StringReplacer with this setting transforms a single line address string into your desired multi-line string at once.
- Mode: Replace Regular Expression
- Text To Replace: (.{19,}?)\s
- Replacement Text: \1<newline character>
Alternatively, this string expression does the trick too. Assuming that an attribute called "address" stores the original single line address string.
@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