Need to Extract Data from webhook with "|" symbol

I am using gravity forms on Wordpress to send data via webbook.

Using the pricing field the data sends the field value and price with a | between them. See my screenshot line 157 and 160.

I need to get the data before the | and then in another place the price, which is the data after the |.

How can I do this?

image

Welcome to the Make community!

You can use the built-in split function:

{{ first(split(variable; |)) }}

{{ last(split(variable; |)) }}

Replace variable with the variable that you want to split.

2 Likes

Thank you this was Exactly what I needed.

1 Like

No problem, glad I could help!

In future, please create a new thread for each question. This makes it easier for others with the same problem to search for the answer. Thank you for your cooperation!

The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that

  • others can save time when catching up with the latest activity here, and
  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

2 Likes