2 string manipulation questions....

[Mark2]

Hi,

Question 1:

OK, I have a string called MyString as follows:

MyString = "[Letters]ABCDE[Numbers]1234"

I want to click a button and for it to search the string for [Letters] then display in 'MyStringNew' just the letters (ABC, etc), i.e. not the numbers section.

Question 2:

In the above string, how can I also show everything after [Letters] to the end of the string.

Thanks!!

Mark

[Bill Crawley]

Ans to Q2

newVal = Right(mystring, Len(mystring) - (InStr(1, mystring, "]")))

Before Answering Q1,

Will the string always be in the format you have shown?

[Bill Crawley]

Mark assuming it's in this fomat, then you retrieve the letters part with the following

letters = left(right(mystring,len(mystring) - instr(1,mystring,"]")),instr(1,right(mystring,len(mystring) - instr(1,mystring,"]")),"[")-1)

and for the numbers:

numbers = Right(mystring, Len(mystring) - InStr(10, mystring, "]"))