How to exclude the middle name (alphabet) and split the full name as 'First Name' and 'Last Name' on separate columns

Help Studio
, ,
4

Hi,

We can use RemoveDataColumn Activity as the following.

image

FYI, if you need to change column position of FirstName and/or LastName, the following will help you.

image
image1091×601 33.9 KB

dt.Columns("FirstName")SetOrdinal(0)

Regards,