3 Replies Latest reply on Jun 2, 2013 8:24 PM by philmodjunk

    I need help with outputting a matched text that is listed in another field

    Lantonicus

      Title

      I need help with outputting a matched text that is listed in another field

      Post

            
           Hello,
            
           Here is the  situation.
            
           Example
            
           I have a field called STOCKS
           STOCKS has  text values..   AAA BBB CCC DDD and so on 
            
           I have a  field called  INFO
           it has  sentences  and stock names are used here
           example..    AAA.E stock is 85 dollars 
                             BBB.X stock is 11.12% down.
                             and so one
            
           what I want to do is:
           I have a third field  called MATCH
            
           I want MATCH  field  to filter  INFO field based on STOCKS field and extract the matching text and output
            
           example for AAA.E stock is 85 dollars match:
      MATCH field checks  the  values listed in the STOCKS fields and since in the INFO field entiry 1  AAA is in the list of STOCKS
      it extracts the  AAA and  output as a text value
            
           I hope I can explain what I am looking for 
            
           looking for assistance
            
           Regards,