Thread: Checking string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Checking string

Hi! I have a matrix that contains names of companies and some info about
these compaines. For every company there is an array that contains rating
info. These ratings are written with a special syntax. What I want to do is
to find which rating agency is used. The ratings are written with a special
syntax. First comes three letters and an underscore and then comes (an
abbrevation of) the name of the ratingagency. Eg a raing looks like: RTG_SP*.
Here I want to single out the SP. The start indicates that there might be
additional info that I am not intreseted in. There are only three rating
agencies that I want to single out; SP, MDY and FITCH. But how do you check
an array and look for the names? Please any help appreciated! Thanks alot!