Business Object - Utility Strings, Action - Split Text - using non-Word characters

RocMcNaughton — Thu, 10 Aug 2023 14:32:28 GMT

I'd like to enter carriage return / line feed as my split char, so I'm looking to enter something like "Hex(ODOA)" or "Ascii(1310)" (using proper syntax). Is this possible? I'm obviously hoping so as this would be my easiest path forward. If this isn't possible, then perhaps I can achieve this via RegEx? I'm just being made aware of RegEx but am not at all fluent in it. If RegEx is my answer, please lemme know how to code what I want here. Thanks! (I tried to find my answer via existing questions but didn't see one...)

Roc McNaughton

Re: Business Object - Utility Strings, Action - Split Text - using non-Word characters

MichealCharron — Thu, 10 Aug 2023 16:19:18 GMT

@Roc McNaughton

You can use the following for your "Split Char" parameter:

Chr(13)&Chr(10)

You could also use the "Split Lines" action but the one disadvantage of that action is that you cannot name your collection column

topic Re: Business Object - Utility Strings, Action - Split Text - using non-Word characters in Product Forum

Business Object - Utility Strings, Action - Split Text - using non-Word characters

Re: Business Object - Utility Strings, Action - Split Text - using non-Word characters