AnsweredAssumed Answered

Substracting information from a CSV line

Question asked by yomango on Apr 4, 2013
Latest reply on Apr 4, 2013 by yomango

Title

Substracting information from a CSV line

Post

     Hello, there. On the same line in two CSV files I have the following information:

     N1*PR*STATE OF FLORIDA MEDICAID~

     N1*PR*ANTHEM MIDWEST (KY, IN, OH, MO)*XV*00660~

     what I want to extract is 'STATE OF FLORIDA MEDICAID' from one file, and 'ANTHEM MIDWEST (KY, IN, OH, MO)' from the other file using the same formula. I've tried many approaches but when a calculation works on a file, it fails on the other. Can anyone give me a guidance on how to approach the calculation? Thanks

Outcomes