{"id":383,"date":"2020-11-19T08:52:27","date_gmt":"2020-11-19T13:52:27","guid":{"rendered":"http:\/\/quikstarts.com\/qs\/?p=383"},"modified":"2020-11-22T09:26:29","modified_gmt":"2020-11-22T14:26:29","slug":"how-to-parse-specific-parameters-from-string-urls-or-api-response-data-using-regex-in-bubble","status":"publish","type":"post","link":"https:\/\/quikstarts.com\/qs\/bubble\/how-to-parse-specific-parameters-from-string-urls-or-api-response-data-using-regex-in-bubble\/","title":{"rendered":"How to parse specific parameters from string urls or API response data using RegEx in bubble"},"content":{"rendered":"\n<p><strong>Objective<\/strong>: Learn how to parse specific parameters from string urls or API response data using RegEx in bubble.<\/p>\n\n\n\n<p><strong>Introduction<\/strong>: RegEx &#8211; which stands for <a href=\"https:\/\/en.wikipedia.org\/wiki\/Regular_expression\" target=\"_blank\" rel=\"noreferrer noopener\">regular expression<\/a> &#8211; is very popular in the world of coding. It is often used to identify character patterns but is not often explained very well. We will attempt to explain it here by using a real-life example in two steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\" id=\"block-8fbbe65b-9238-4807-81c8-d9d2efca5924\"><li>Parse the API Response for a parameter.<\/li><li>Decode the data so that it is readable for our purposes. (when needed )<\/li><\/ol>\n\n\n\n<p><strong>Note<\/strong>: This guide does not cover API calls, extensive workflow or database setup.<\/p>\n\n\n\n<p><strong>Requirements<\/strong>: A <a rel=\"noreferrer noopener\" href=\"http:\/\/bubble.io\" target=\"_blank\">bubble.io<\/a> account.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"267\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.51-AM-1024x267.png\" alt=\"regex-bubble-parse\" class=\"wp-image-393\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.51-AM-1024x267.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.51-AM-300x78.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.51-AM-768x200.png 768w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.51-AM.png 1934w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>String of parameters returned by an API call.<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p><strong>Bubble Version<\/strong>: 7<\/p>\n\n\n\n<p><strong>Demo \u2013&nbsp;<a href=\"https:\/\/quikstarts-demo.bubbleapps.io\/version-test\/parse-paramters\" target=\"_blank\" rel=\"noreferrer noopener\">quikStarts parse specific parameters from string urls or API response<\/a><\/strong><\/p>\n\n\n\n<p><strong>Source \u2013&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/bubble.io\/page?type=page&amp;name=parse-paramters&amp;id=quikstarts-demo&amp;tab=tabs-1\" target=\"_blank\">quikStarts parse specific parameters from string urls or API response<\/a><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Start<\/strong><\/h4>\n\n\n\n<!--more-->\n\n\n\n<ol class=\"qs-block wp-block-list\"><li>Identify that the parameter\/s that you need are included in the string. In this case, we will be seeking to recover the paying customer&#8217;s email address highlighted in the image below.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"155\" class=\"wp-image-401\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.38-AM.png\" alt=\"\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.38-AM.png 1938w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.38-AM-300x77.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.38-AM-1024x264.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-19-at-8.47.38-AM-768x198.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><li><strong>Note: <\/strong>This is an actual example of a String of data returned from a PayPal Checkout API response (<a href=\"https:\/\/developer.paypal.com\/docs\/archive\/express-checkout\/integration-jsv4\/ec-get-payment-details\/\">GetExpressCheckoutDetails<\/a>) containing several parameters. This technique can also be used with a URL string.<\/li><\/ul><\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Define the RegEx pattern<\/strong><\/h4>\n\n\n\n<ol id=\"block-f4584b7d-5414-4afc-9b4b-5943a42beeaf\" class=\"qs-block wp-block-list\"><li>We need to define the RexEx pattern that we will place in bubble later in this guide. Visit <a rel=\"noreferrer noopener\" href=\"https:\/\/regexr.com\/\" target=\"_blank\">regexr.com &#8211; https:\/\/regexr.com\/<\/a>.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"197\" class=\"wp-image-414\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.07.34-AM.png\" alt=\"RexEx-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.07.34-AM.png 2866w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.07.34-AM-300x98.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.07.34-AM-1024x336.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.07.34-AM-768x252.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><li>Note: If you use RegEx or thing that you will in the future, we recommend that you save this data by creating an account at RegExr.com.<\/li><\/ul><\/li><li>Define the pattern that matches the parameter that you want to extract.<ul><li><strong>Note<\/strong>: bubbles reference contains minimal information but does reference important syntax that we will use in this example &#8211; <a href=\"https:\/\/bubble.io\/reference#Data.Messages.text.extract_regex\">https:\/\/bubble.io\/reference#Data.Messages.text.extract_regex<\/a> . <\/li><li><strong>Note<\/strong>: Specifically look at RegEx pattern &#8216;@\\S+&#8217;<img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"87\" class=\"wp-image-420\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.32.40-AM.png\" alt=\"RegEx-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.32.40-AM.png 1436w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.32.40-AM-300x43.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.32.40-AM-1024x148.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-8.32.40-AM-768x111.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><li>Where it gets tricky, is that there is no one way to accomplish this step as a beginner. Basically, you can work with the steps outlined on regexr.com. It may still not be very clear. Proceed to see how we handle this process.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"235\" class=\"wp-image-437\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.00.49-AM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.00.49-AM.png 2110w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.00.49-AM-300x117.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.00.49-AM-1024x401.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.00.49-AM-768x301.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><\/ul><\/li><li>Copy the entire string \/ API Response that needs to be parsed and paste it into the section outlined in the above image at RegExer.com.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"241\" class=\"wp-image-444\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.14.37-AM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.14.37-AM.png 2108w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.14.37-AM-300x120.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.14.37-AM-1024x411.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.14.37-AM-768x308.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>In the expression field, remove the default syntax. Then type the name of the parameter that you would like to capture along with its preceding character followed by &#8216;=&#8217;. In our case, the parameter is preceded by &#8216;&amp;&#8217; so we would type &#8211; &#8220;&amp;EMAIL=&#8221;.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"239\" class=\"wp-image-448\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.30.36-AM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.30.36-AM.png 2090w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.30.36-AM-300x120.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.30.36-AM-1024x409.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-11.30.36-AM-768x306.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><li><strong>Note<\/strong>: In realtime, the words that you typed are matched in the body of your string.<\/li><\/ul><\/li><li>The next step is a bit more challenging because the data that we need to capture is dynamic data and we have no way to know what it will be. The beauty of RegEx is that we will use it&#8217;s syntax to capture this data despite it being dynamic. We know we need to capture everything after the &#8216;EMAIL=&#8217; but before the next &#8216;&amp;&#8217;. Using the &#8220;cheatsheet&#8221; tab to the left, we can identify the syntax.<ul><li>Note: Remember when capturing this data, that it may be encoded making some of the characters appear different than what you expect. This may be referred to as <a rel=\"noreferrer noopener\" href=\"https:\/\/en.wikipedia.org\/wiki\/Percent-encoding\" target=\"_blank\">encoding, URL encoding, or percent-encoding<\/a> and there is an easy way to decode that we will cover in the next section.<\/li><\/ul><\/li><li>Ultimately the syntax we will use for RexEx in bubble is &#8211; <strong>&amp;EMAIL=(.+?)&amp;<\/strong>. Why? Here we break the syntax down into detail with explanations:<ul><li>&#8220;&amp;EMAIL=&#8221; &#8211; &#8216;&amp;&#8217; is a known parameter separator.<\/li><li>&#8220;EMAIL&#8221; &#8211;  is the name of the parameter.<\/li><li>&#8216;=&#8217; &#8211; is the equals sign that will be followed by a value for the &#8220;EMAIL&#8221; parameter.<\/li><li>&#8220;( )&#8221; &#8211; is a regex class for capture group. Meaning anything inside of the parentheses is a part of the group.<\/li><li>&#8216;.&#8217; &#8211; means any character in the same line. Not on a newline.<\/li><li>&#8216;+&#8217; &#8211; match one or more of the preceding token.<\/li><li>&#8216;?&#8217; &#8211; makes the preceding quantifier lazy, causing it to match as few characters as possible.<\/li><li>&#8216;&amp;&#8217; &#8211; Important. This trailing ampersand was used to tell RegEx where to stop searching since in this case, it represents the start of the next parameter &#8220;PAYERID&#8221;.<\/li><li>Note: We determined that there were other combinations of the syntax that worked as well. E.g. &#8220;&amp;EMAIL=.+?&amp;&#8221;, returned the same results. So be advised that there may be more than one way to achieve your goal. Testing is the best approach.<\/li><\/ul><\/li><li>You should now have RegEx syntax that identifies your parameter and its value that can be used in bubble.<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Using the RegEx syntax in bubble<\/strong><\/h4>\n\n\n\n<p><strong>Note<\/strong>: If you have not already, you should have a field in the database prepared to capture and hold the value of the parameter after it has been parsed. We will not cover database setup and workflow in detail as it is outside of the scope of this guide.<\/p>\n\n\n\n<ol id=\"block-f4584b7d-5414-4afc-9b4b-5943a42beeaf\" class=\"qs-block wp-block-list\"><li>We are going to illustrate the following using the API call response identified above:<ul><li>Parse the API response data for the value of a specific parameter (EMAIL).<\/li><li>Store the value of that parameter in the database using a simple form with one input field and one button.<\/li><li>Display it on the screen.<\/li><\/ul><\/li><li>Create a form in bubble that contains an input field and a button.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"62\" class=\"wp-image-472\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.33.36-PM.png\" alt=\"regex-parse-bubble\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.33.36-PM.png 1924w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.33.36-PM-300x31.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.33.36-PM-1024x105.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.33.36-PM-768x79.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>Use the proper RegEx syntax identified earlier and in your bubble editor launch the workflow, for the button. <ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"387\" class=\"wp-image-474\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.35.42-PM.png\" alt=\"regex-parse-bubble\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.35.42-PM.png 1002w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.35.42-PM-300x193.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.35.42-PM-768x495.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>Click &#8220;Click here to add an action&#8221;, select &#8220;Create a new thing&#8230;&#8221;.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"777\" class=\"wp-image-481\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.41.20-PM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.41.20-PM.png 1078w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.41.20-PM-232x300.png 232w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.41.20-PM-791x1024.png 791w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.41.20-PM-768x995.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>Drill down to the list of choices for populating the database with a value.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"406\" class=\"wp-image-484\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.43.44-PM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.43.44-PM.png 1588w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.43.44-PM-300x203.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.43.44-PM-1024x693.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.43.44-PM-768x519.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>After that source has been identified, select the &#8220;:extract with Regex&#8221; option.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"432\" class=\"wp-image-490\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.46.35-PM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.46.35-PM.png 1596w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.46.35-PM-300x216.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.46.35-PM-1024x737.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.46.35-PM-768x552.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>At this point, we have successfully used RegEx to parse the parameter that we want out of a string of parameters returned by the API. <ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"77\" class=\"wp-image-497\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.58.20-PM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.58.20-PM.png 1934w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.58.20-PM-300x38.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.58.20-PM-1024x131.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-1.58.20-PM-768x98.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><li><strong>Note<\/strong>: The issue at this point is that although RegEx did it&#8217;s job, the data is still encoded, contains &#8216;&amp;&#8217;s, and does not serve our purposes yet.<\/li><\/ul><\/li><li>Append the &#8220;Find&amp;Replace&#8221; function to &#8220;:extract with Regex&#8221; (step 6) &#8211; as many times as you need to &#8211; to replace and remove unwanted characters. We will do one here as an example for &#8220;EMAIL&#8221;.<ul><li><strong>Note<\/strong>: Perform all clean-up functions before inserting the data into the database.<\/li><\/ul><\/li><li>After appending &#8220;Find&amp;Replace&#8221;, enter &#8220;EMAIL=&#8221; in the &#8220;Text to find&#8221; field and leave the &#8220;replace&#8221; field blank. Click &#8220;Close&#8221;.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"228\" class=\"wp-image-514\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.41.15-PM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.41.15-PM.png 2204w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.41.15-PM-300x114.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.41.15-PM-1024x388.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.41.15-PM-768x291.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>When the workflow runs, it should parse the value of the parameter and insert it into your database. You should now have successfully extracted, parsed, and stored the email address in the database in bubble. <ul><li><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"81\" class=\"wp-image-519\" style=\"width: 600px;\" src=\"http:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.44.32-PM.png\" alt=\"regex-bubble-parse\" srcset=\"https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.44.32-PM.png 1944w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.44.32-PM-300x40.png 300w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.44.32-PM-1024x138.png 1024w, https:\/\/quikstarts.com\/qs\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-21-at-2.44.32-PM-768x104.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/li><\/ul><\/li><li>END<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to use regex in bubble Part 1\" width=\"580\" height=\"435\" src=\"https:\/\/www.youtube.com\/embed\/QwxhAU5LgYY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Objective: Learn how to parse specific parameters from string urls or API response data using RegEx in bubble. Introduction: RegEx &#8211; which stands for regular expression &#8211; is very popular in the world of coding. It is often used to identify character patterns but is not often explained very well. We will attempt to explain [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[12,3,11],"class_list":["post-383","post","type-post","status-publish","format-standard","hentry","category-bubble","tag-api","tag-bubble-io","tag-regex"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/posts\/383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/comments?post=383"}],"version-history":[{"count":115,"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/posts\/383\/revisions"}],"predecessor-version":[{"id":523,"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/posts\/383\/revisions\/523"}],"wp:attachment":[{"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/media?parent=383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/categories?post=383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quikstarts.com\/qs\/wp-json\/wp\/v2\/tags?post=383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}