I have data of name like this: John Wilson A. Barren and Jaklin W. Holm
And would like to define Wilson A. Barren and W. Holm as 'LastName' variable.
The first words will be first name and others behind will become last name.
In this case, I have done split text in PAD but got stuck in the following step. I search through forum and find out that there's a skip () function in power automate that can solve this easily but not in PAD.
