Link to home
Start Free TrialLog in
Avatar of MrWeen
MrWeen

asked on

Extract information Crystal Reports

I have a column named "comment" from a table named "Journal" with data that looks like this.

Comment
Reg:    5 Chq:030048 Sup:HEW010  Bank:01 Inv:INVS3857592    
Jnl:   19 Inv:JMVERSAILLES6/7/12   Sup:MIN010              
Jnl:   19 Inv:CDIMEDIOo6/7/12      Sup:MIN010              
Jnl:   19 Inv:MANOLI6/7/12         Sup:NAT012          
Jnl:   19 Inv:CDIMEDIO6/7/12       Sup:DIM010              

Using this formula mid([Comment], instr([Comment], "Sup:")+4, 6)

I was able to extract this data


HEW010
MIN010  
MIN010
NAT012
DIM010


Now I have the same column with this

Comment
Reg:  193 Bank:01Supplier :BLA010                          
Reg:  193 Bank:01Supplier :CHA010                          
Reg:  193 Bank:01Supplier :CHE010                          
Reg:  193 Bank:01Supplier :COR010                          
Reg:  193 Bank:01Supplier :DAV010                          

How do I change the formula to get the new codes?

I want these results

BLA010
CHA010
CHE010
COR010
DAV010

Thank you,

MrWeen
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial