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.
Formatter Split Text - Only get part of Data
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 27684 replies
-
20 September 2023
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.