AnsweredAssumed Answered

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

Question asked by Lantonicus on Jun 1, 2013
Latest reply on Jun 2, 2013 by philmodjunk

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,
      
      
      

Outcomes