• Search Forums
    Advanced Search
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Parsing out Lawson PO Header comments in crystal

 2 Replies
 0 Subscribed to this topic
 39 Subscribed to this forum
Sort:
Author
Messages
Lmanke
Basic Member
Posts: 5
Basic Member
6/25/2013 5:57 PM
Has anyone had to parse out the PO Header comments from the L_HPCR table?
I have a crystal report that pulls out the PO Comments and prints them but they don't go into Excel very nicely.  I'm trying to parse these comments into separate fields but they are separated by the hex value for Carriage Return/Line Feed and so far I can't figure out how to get crystal to look for that. 
Would rather not rewrite this in Cobol but if I have to I will.. just thought I would see if anyone else has done this.
Thanks! 
StephanieD
Veteran Member
Posts: 39
Veteran Member
6/25/2013 8:01 PM
I have used this formula in Crystal with comments, Replace(Mid(TrimRight({L_HPLI.OBJECT}),96),chr(10),',  ').  Does this help ?
Lmanke
Basic Member
Posts: 5
Basic Member
6/26/2013 11:06 AM
Thanks Stephanie.. that seems to work!!