Hello! Does anyone know where can I find examples and tutorials on Regex Pattern option from Extract Value from Data? I have a text column that is a formatted JSON string {"field1": "value1", "field2": "value2"}, and I can't match anything using regex pattern like this "field1":\s*"([^"]+)
We don't have specific examples or tutorials for using Regex Pattern to match formatted JSON strings in our Extract Values from Data feature. However, we do offer a custom regex extraction option in our Scrape Website feature.In the Scrape Website feature, you can use the "Extract Custom Regex" field to extract specific data patterns from websites. For example, you could use it to extract Wikipedia links using a pattern like https?://([a-z]{2,3}.)?[[wikipedia.org/wiki](http://wikipedia.org/wiki)]([https://wikipedia.org/wiki](https://wikipedia.org/wiki))/[a-zA-Z0-9_-]*.Would you like more information about using regex in our Scrape Website feature, or are you specifically looking for JSON string extraction in the Extract Values from Data feature?
Sources:
Scrape Website with Clay
Extract Values from Data with Clay
I am specifically looking for JSON string extraction in the Extract Values from Data feature
We don't have specific examples or tutorials for using Regex Pattern in the Extract Value from Data feature to extract values from formatted JSON strings. However, our Extract Values from Data integration allows you to define patterns to identify and retrieve targeted information from various data types, including objects, lists, or text.To help you with this task, we have a variety of prompts designed for information extraction that might be useful. These prompts can help you pull specific, high-value data points from your datasets, which could include JSON strings.Would you like me to provide more information on how to use the Extract Values from Data feature in general, or are you looking for something more specific about regex patterns for JSON? Sources: Extract Values from Data with Clay We Made 24 Prompts So You Don’t Have To [Automated Outbound] - Clay University
regex pattern for JSON
We offer an "Extract Values from Data" feature that allows you to extract specific information from various data types, including JSON strings. You can define patterns, such as regex, to identify and retrieve targeted information like email addresses or LinkedIn URLs from objects, lists, or text.To use a regex pattern for extraction: 1. Select the "Extract Values from Data" enrichment. 2. In the "Data" field, input your JSON string. 3. For "Extraction Type", specify the type of information you want to extract (e.g., "email" or "LinkedIn URL"). 4. If needed, use the "Object Fields" option to further refine your extraction.The output will include "Matches" (an array of extracted values) and "Joined Matches" (a single string of extracted values).Could you provide an example of the specific JSON string you're working with and the type of data you're trying to extract? This would help me offer more tailored guidance. Source: Extract Values from Data with Clay
json string is {"field1": "value1", "field2": "value2"}, I want to match "value1"
Based on the available information, while the Extract Values from Data feature allows you to extract specific values using patterns, we don't have specific documentation about regex patterns for JSON string extraction.Here's what we know about the Extract Values from Data feature: 1. It allows you to extract specific values from various data types including: • Objects • Lists • Text 2. The feature requires: • Data input (your JSON string) • Extraction Type • Optional Object FieldsThe output will provide: ** Matches (as an array) ** Joined Matches (as a single string)Since we don't have specific documentation about JSON regex patterns, you may want to request help from a human agent who can provide more detailed guidance for your specific use case. Source: Extract Values from Data with Clay
Is that what you were looking for?
Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Jason - Do you mind sending the link (url) to the table so we can take a look? https://downloads.intercomcdn.com/i/o/w28k1kwz/1347419411/65baf32e1d2a789ffba395c6d35c/CleanShot+2025-01-22+at+_42I1FzxXHf%402x.png?expires=1739026800&signature=892638349d1f3d4e8a79e3e5f4f868655ae4fa9234cb75b82d29be6b1c4cd161&req=dSMjEc1%2FlIVeWPMW1HO4zVws4pg3D1KggvYjA82bedBN7Q%3D%3D%0A
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
.png){kind=logo}
