10-08-23 03:32 PM
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
10-08-23 05:19 PM
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