Question

How do I parse multi-line Checkmarket survey answers into separate Smartsheet fields?

  • 18 August 2023
  • 3 replies
  • 30 views

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.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +6

Hi @spreik1,

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:

a8e22405a1c8272ab7cbc6e251239f61.png
(view larger)

0a0b438fca175f763b898140cf5eab18.png
(view larger)

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.

Userlevel 7
Badge +6

Hi @spreik1,

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

ae9c0020d1d2b3cd6f0850ae739dfd0c.png
(view larger)
2a72ad7416d6964d4b582732c3b3e7c5.png
(view larger)

You can then map the output individually:

881ea04c77ad875684c0dcce4bf1ade2.png
(view larger)

Please give that a try, and let me know how it goes! 😊