extracting data to the right of a set character
On 21 Aug, 19:30, Tevuna wrote:
=SUBSTITUTE(SUBSTITUTE(A1,"y",""),".","")
or
=SUBSTITUTE(A1,"y","")
The second doesn't remvoe dots
" wrote:
I would like to know if there is a way to isolate the characters to
the right of a set of characters in a string.
I know the basics on how to use the LEN, MID, RIGHT and LEFT functions
but the problem I have is that the character is a full stop and for
some of the data, the full stop occurs more than just once, otherwise
it would be quite simple.
For instance a string could be as follows: -
yyy.yyyy.yyyyyyy.yy.y.yyy.xxx
where I need to capture the xxx and the xxx could be between 2 and 5
characters long.
I have tried all sorts of ways with modified code from postings on the
Group but to no avail.
Help much appreciated.
Mark.
Thanks, but perhaps you took me a little too literally, or more likely
I have missed the point.
The y's in my example can be any number or text, and they can be
random.
I tried substituting your Y for a wildcard but that didnt work.
here is another example: -
First Draft.Standard Subjective.Structure Proposal.evd where evd could
be any combination from 2-5 chars long
Thanks
mark
|