Remove part of a string before adding to New Collection

[jordan2322]

G'day everyone,

Im using the following code to create a validation list. My question is this - how could I modify the string value to exclude a specified term.
I.e. If the cell.value found makes it thru to the line

Please Login or Register  to view this content.

and this value is "Fld Coordinator OH", then could i include an extra line before adding it to the collection so that if it contains "Fld Coordinator" then this term is removed, leaving only "OH" as the value to be added to the collection?

Please Login or Register  to view this content.

Thanks heaps

[vandan_tanna]

may be something like this...

Please Login or Register  to view this content.

[jordan2322]

thank you for your reply vandan, this works great.
My only question is what if i wanted it to be more broad, such that the user could define any term they wanted for it to exclude, and it could determine where in the string the term is and is able to remove it.
an example could be

rmStr = Collar
eg.1
Cell.Value = 'Blue Collar'
newStr = Blue
eg.2
Likewise if Cell.value = Collar Excel
newStr = Excel

regards

[jindon]

One way

Please Login or Register  to view this content.

[vandan_tanna]

I like jindon's way. it is a bit more neater than mine.

One suggestion I have is to may be have an array with a list of string you want to remove and then processing the cell value through it to remove all unwanted strings. This could be done in a separate function.