Something similar as Skip () in PAD

(0) Share

Report

Posted on by deerzzxdell

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.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

Split text works
or you can use parse text and use regex to get the value

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

You could use Split text with a white space as the delimiter. When your result is %TextList%, you can get your first name (the first word) as %TextList[0]%. You can then use Remove item from list to remove the first item (at index 0) to leave everything else in the list and then use Join text to join the remaining words into last name. Use white space as a delimiter for joining.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No