How to extract a piece of a string variable, and assign to a new variable

**jmccoughlin** · 11-04-2015, 10:18 PM

Hi All,

Hopefully this is an easy one...

If I have a string:

strEmailBody="Percent done and comments: 99% (Will be done tonight!)<end-of-line>etc...additional text is on the next line in this same string"

Would anyone know how to extract any text between "comments: " and the (unseen) end-of-line character?
...it would be assigned to a new string called "strPctDoneAndComments"

Thanks so much,
jmc

**Obsessed** · 11-04-2015, 10:22 PM

I would assume that you'd already have that string elsewhere, else how did you build the email body string?

**AlphaFrog** · 11-04-2015, 10:37 PM

Try something like this.
< br> is a common end-of-line HTML tag.

Please Login or Register  to view this content.

**jmccoughlin** · 11-04-2015, 11:11 PM

Thanks so much AlphaFrog!

This worked great!

I had to make a slight tweak by replacing <br> with vbLf, other than that... perfect! Thanks again!!

To Obsessed, the string is read from the body string from an Outlook email. I should have mentioned that above, but thankfully, all figured out!

**excel_joe** · 11-04-2015, 11:50 PM

Try this

Please Login or Register  to view this content.

How to extract a piece of a string variable, and assign to a new variable

LinkBack

Thread Tools

Rate This Thread

Display

How to extract a piece of a string variable, and assign to a new variable

Re: How to extract a piece of a string variable, and assign to a new variable

Re: How to extract a piece of a string variable, and assign to a new variable

Re: How to extract a piece of a string variable, and assign to a new variable

Re: How to extract a piece of a string variable, and assign to a new variable

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract variable length string

[SOLVED] How can I assign the last 4 characters of a string to a string variable?

[SOLVED] UDF to extract digits from variable range string

[SOLVED] how to extract variable length string

[SOLVED] Assign entire row to variable, how do you paste variable values in a new workbook?

Adding a variable string comment to a cell. "Object Variable or WIth Block Variable Not.."

Assign activesheet name to string variable?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions