Extracting a block of text from a large block of text

You are in luck. You have a semi colon as s delimiter

Trim(
Part([My Text field], 2, ":"))

Just keep increasing the 2 to get the different parts.

Thank you. I'll try that.

Since any amount of information can be present ahead of the desired block of information, the provided solution only works after the isolation of the block. We need to plow past any amount of data that is ahead of the desired block first, like CCs and BCCs, etc. We are also capturing the RawBody of the email. The block we want to isolate is prefaced by �<b>� markup.

There is also any amount of data after the desired block. Our objective for now is to isolate that needed block of information into its own field, and then from there we will be able to use the Part() function to pull it apart even more.

Any help is appreciated.

Did you try the low tech method I described?

It is almost always a better idea to clean up and parse your data before importing it into a new system (here QuickBase). I am going to assume you  have already looked at this option and are accepting the fact that the un-parsed data has landed in your application.

You used the word "consistency" in describing the information you want to parse out of the text field. More than likely your data is a lot less consistent than you assume as information could appear out of order, could be missing, or contain unexpected characters. One example of the data is insufficient to derive its actual format and structure. Because of this variability is probably best to initially manually supervise the parsing of the data rather than completely automate the process.

Here is a quick demo - Click the Parse button to parse the fields and click the Reset button to reset the fields:

Regexp Capturing Groups
https://haversineconsulting.quickbase.com/db/bnm9bcsys?a=er&rid=1

Pastie Databsase
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=652

Notes:

(1) To simplify the maintenance of the demo I have made the [Text] field readonly on the HTML form and provided a Reset button to clear the parsed fields.

(2) For the City, State and Zip information I have parsed the string into individual fields.

(3) This is just a simple demo of parsing data out of a field using script and regular expressions. In fact I wrote the script to allow a user unfamiliar with regular expressions to modify the script without having to understand every detail. However, regular expressions are so powerful that it could easily be adopted for much more complex parsing requirements.

If you need further assistance with implementing this solution feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt/

Thank you. We will try this and see how it goes.