How to split carriage return and put in new column

Hello there,
how can I split a content of a column in my datatable and put the result in a new column ?

The name of the column : EventName
Content of the column I need to split:

aaaaa
11111

I want to put 1111 in a new column in the same dataset

How can I do that ?
Thanks in advance.

Hi,

Hope the following helps you.

Sample20201109-1.zip (8.9 KB)

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.