Thanks a lot, @Yoichi. Yes, the split works for all the scenarios, including the full names with(out) middle name (alphabet). I have a follow up question for you, if you do not mind.
– I do not want to see the column called fullname in the output (result) file, just first name and last name, just split ones. How do I restrict the fullname column from going to output?
– I need all the columns in the input except the fullname in my output (result) file
– Not very much essential but just FYI, I use modern design in my process.
Please advise. Thanks!