Parsing out Lawson PO Header comments in crystal

Sort:
You are not authorized to post a reply.
Author
Messages
Lmanke
Basic Member
Posts: 5
Basic Member
    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
      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
        Thanks Stephanie.. that seems to work!!
        You are not authorized to post a reply.