cancel
Showing results for 
Search instead for 
Did you mean: 

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

RocMcNaughton
Level 2

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

1 REPLY 1

MichealCharron
Level 8

@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

Micheal Charron
RBC
Toronto, Ontario
Canada