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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.