• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

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: 57

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