Splitting Full Name into First Name and Last Name

[infoTP]

Pabbly spreadsheet formulas don't seem to allow use of items like IFERROR and COUNTIF making it very difficult to work with entries which have only first name i.e. no space in full name. Have even tried using countif to check for no spaces - nothing seems to work. Any help would be appreciated.

The goal is to send first name only if there is only 1 word given in full name field and pass blank value in Last Name field. Examples of possible name combos are:

Sundeep Jain
Sundeep
Sundeep M Jain

Thanks

 

[Fagun Shah]

Check this video - https://www.berrycast.com/conversations/f31c2c04-eb4a-5882-9b43-55fc09c6b1c3

For testing use this form - https://fagunshah.in/fname-and-lname/

View Result in this Gsheet - https://docs.google.com/spreadsheets/d/1R5lFAVqfwqnMZQDrt2rpuZShmXl-6AJSoCsd3yeds9w/edit?usp=sharing

Copy My Workflow - https://connect.pabbly.com/workflow/share/WxNUZlIVASlQGghMBk0MbQAXACkFTwVTUjVURg##