I’ve connected my Checkmarket survey to Smartsheets via Zapier however some of the questions are multi-line questions - such as “your information” there is are separate lines within the same question for first name, last name, email, etc however when I am in the Action part of adding the response to Smartsheet its mapping these as a string with comma separator (John, Smith, john.smith@test.com). What I need is for those to be separate fields on the smartsheet which is already setup with the separate columns. So how do I parse the string - mind you I need a no code/low code response please.
Page 1 / 1
Hi
Welcome to the Community! 
You can use Text in Formatter by Zapier - Split Text to parse the string and map them to separate fields in Smartsheet. Here’s an example:
You can learn more about modifying text formats in Zaps here: https://help.zapier.com/hc/en-us/articles/8496304469261-Modify-text-formats-in-Zaps#1-add-a-formatter-step-0-0
Hopefully, this helps! 
This doesn’t seem to work with commas as the delimiter between the text.
Hi
Have you tried setting the “Segment Index” field to All (as Separate Fields)? This is what it’ll look like based on your example (John, Smith, john.smith@test.com):
(view larger)
(view larger)
You can then map the output individually:
Please give that a try, and let me know how it goes!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.