• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Problem with Splitting of names

When we have an 2 Names( Example: Suman N) that is First Name and Second name we were using Split Text formula To get successful response that is (Suman + N).
Then if a person doesn't have second name then we used Spread Sheet formula to get response as NA ( IF(LEN('2. Result 2 : Madappady')=0,'NA','2. Result 2 : Madappady') .

But in the case of Three Names Splits what should if a person doesn't have second name and last name??
if a person name is Dr Sajjan Madapaddy how to make this please guide us with an example?????
 

Attachments

  • 01.png
    01.png
    34.5 KB · Views: 127

Hermes

Active member
Best is a router, with route 1 is that if result0 = Dr or Drs or Mr or anything you could think of, then add result1 as surname.
With a router you could add all possibilities, if 1 still now correct just add it to the router and re-execute
 
Top