This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello friends , iam a noob airtable user , i’m in charge of a table that recieves data from an api in json format , the output is all in one line , so when i try to extract a value from a key using regex it does not work (it shows error) unless i use...
I went the scripting way at the end and i crafted a small script that go through all the records and of a specific table’s cell and just parse the json data and get the value of the key i specified and problem solved .
Thank you again for all the hel...
I did manage something with REGEX but ONLY after i get through a beautifier online :
REGEX_EXTRACT({FieldNAme},‘“MyKey”[:]\s(“.*”)’)
this gets me the desired output .
@ScottWorld Thank you i figured it out but didn’t know i can nest them lol ! great...
Thank you for the reply , but i’ve looked into these tools , they do not provide what im looking for .
To explain a bit more what i mean .
This is what i have : (dummy data)
{ “id”: 1,“title”: “iPhone 9”,“description”: “An apple mobile which is nothi...
