text parsing

Protecting against aan Address that doesn't have an "-", then

Please Login or Register  to view this content.

Use ShortAddress rather than address in the assignment statement

Hi Blane

I get a compiler error with expected array message.

Hi Leith

Yes, the hyphen will always be there and also i'm looking for VBA code preferably if its ok. Also Address is not equal to property of the object but a name of variable which is of type string. i'll change it below to avoid me confusing you

So, in theory, when my following code gets executed

Please Login or Register  to view this content.

The TargetName variable pulls out different string variable depending on what are the contents of the row cell. I have about 15 cells each with different names on a row like

Q1 Zone - London
Q2 Zone - Paris
Q3 Zone - Rome
.
.
.
Q14 Zone - Tokyo

So when my above line of code gets called, i get the any of the above contents of the cell captured as row information and gets added to my email generator which is another function not to worry in this i guess.

So instead of Q1 Zone - London, i want Q1 Zone only to be read and add to email generator

Originally Posted by blane245

Protecting against aan Address that doesn't have an "-", then

Please Login or Register  to view this content.

Use ShortAddress rather than address in the assignment statement

Hi Leith

Thank you so much as it worked like a treat
One last question on the same issue though

On your code below

Please Login or Register  to view this content.

The highlighted line of code i.e. Range("F" + strCurrentRow).Value3 pulls contents from some other range of cells and adds them to the subject line

Some of the contents of the Cells are like as follows

PetrolPrice - Rate
DieselPrice - Rate
NetProfit - Value
GrossProfit - Value
TotalDeficit - AbovePar
NetDeficit - AbovePar

I want to exclude - Rate, - Value and - Above Par and just add only PetrolPrice, DieselPrice, NetProfit, GrossProfit, TotalDeficit and NetDeficit to the subject line

Is this possible Leith?

regards

Hi Leith

only some of the contents has the following
PetrolPrice - Rate
DieselPrice - Rate
NetProfit - Value
GrossProfit - Value
TotalDeficit - AbovePar
NetDeficit - AbovePar

There are other rows as well which has contents like PerCapita, AnnualTax, FiscalBudget etc.
So the whole list of cell contents are as follows

FiscalBudget
PetrolPrice - Rate
DieselPrice - Rate
PerCapita
NetProfit - Value
GrossProfit - Value
TotalDeficit - AbovePar
NetDeficit - AbovePar
AnnualTax

what I want to know is can use trim and/or use exclude function(if it exists) so that contents of the cell before hyphen or if hyphen doesn't exist then the entire contents get captured to subject line

Thanks Leith

This raises one last question i guess on the same topic

How do i extract the text from the right side in the below list( which is actually the same as the one above)

PetrolPrice - Rate
DieselPrice - Rate
NetProfit - Value
GrossProfit - Value
TotalDeficit - AbovePar
NetDeficit - AbovePar


So if i want to extract only Rate, Value, AbovePar?

Thanks a lot Leith

You have been exceptional patient and helpful in resolving. Thanks to your advice, i have the accurate solution to my problem

regards

Originally Posted by Leith Ross

Hello captedgar,

In my previous post, the variable ShortName2 will either be the entire text or if a hyphen is found, only the text to the left of the hyphen will be used. The following lines of code perform that function.

Please Login or Register  to view this content.