Question

Formatter Split Text - Only get part of Data

  • 20 September 2023
  • 1 reply
  • 26 views

Hi, I am new on zap. I am trying out the automation Smartlead (webhooks) to Gsheet. I have extracted data that shows multiple dates and times separated by multiple commas (ex: Sep 18, 2023 12:38 pm,Sep 19, 2023 01:05 pm,Sep 19, 2023 01:06 pm,Sep 19, 2023 01:33 pm,Sep 20, 2023 09:24 am). I only wanted to get the first date and time or the last date and time (ex:Sep 18, 2023 12:38 pm or Sep 20, 2023 09:24 am), may I ask how it is possible?

I tried FORMATTER - SPLIT TEXT with separator as comma (,) and chose different segment indexes (0,1,2,last) but nothing is showing up with the data that I wanted. Please help. 


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

1 reply

Userlevel 7
Badge +14

Hi @JNWZKS 

Good question,

To help us have context please post detailed screenshots with how your Zap steps are configured.

Make sure to show screenshots of the DATA OUT from the Zap trigger step.

You may have to add this Zap action: Formatter > Utilities > Line Items to Text