Forum Discussion
An example of the string will help
{{ b.content.split(':"')[1].split(',')[0] }}
Based on gut feel , you want to split the string twice, once with : and then with , .
Above is based on scenario , these two delimiters would always be present otherwise this will throw an error.
------------------------------
Prashant Maheshwari
------------------------------
- MarkShnier__You2 years agoQrew Legend
I pasted Melissa's whole question into chat GPT, my only change was to insert the word QuickBase before the work Webhook.
It gave me this response with a handy button to copy the code.
To extract the token from the long text string and remove any irrelevant text after it using Jinja templates, you can nest another
split
function to further split the string using the comma (,
) delimiter. Here's an example of how you can achieve this:{{ b.content.split(':"')[1].split(',')[0] }}
In the above code,
b.content.split(':"')[1]
is used to split the text string and retrieve the token. Then,split(',')[0]
is nested to split the resulting token again using the comma delimiter and retrieve the relevant part before the comma.Make sure to adapt this code snippet according to your specific implementation and the structure of your long text string.
......... it's more than a little spooky.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - MelissaFreel12 years agoQrew Cadet
Prashant:
Thanks! This is what I was thinking, but was unsure of the "seperator" to join the two splits. You gave me the "." and that is what I needed.
------------------------------
Melissa Freel
------------------------------ - MelissaFreel12 years agoQrew Cadet
Mark! Why didn't I just do that? I used chatGPT to write a power automate for a series of excel files.....I should have just applied the same problem solving!.
Hope all is well with you!
Melissa
------------------------------
Melissa Freel
------------------------------