Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    8

    Unanswered: Multiple Rows from text file to one Excel Row

    Hi,
    Please help. I have a text file in EDI line by line format. I need to capture specific rows from the EDI text file to one row in Excel for each segment of data. Plus line number for two of the rows identified.

    End result needs to look like this in Excel. Only using the slash here to who different columns on output to Excel. Guess I need a counter to identify line numbers for the HL lines.

    ST*837*0001/HL*2*1*22*0/HL Line number/CLM*1002111111O60482736/HL*3*1*22*0/HL Line number/CLM*1002222222O60482737

    Next row in Exel
    ST*837*0002/HL.......

    Thank you very much for any assistance given.



    Example of EDI file:

    ISA*00* *00* *ZZ*491 *ZZ*EMEDNYBAT~
    ST*837*0001*005010X223A2~
    BHT*0019*00*5093946*20111114*2335*CH~
    HL*1**20*1~
    PRV*BI*PXC*282X00000X~
    HL*2*1*22*0~
    SBR*P*18**MEDICAID*****MC~
    CLM*1002111111O60482736*2***13;A;5**A*Y*Y********* **8~
    DTP*096*TM*1900~
    DTP*472*D8*20100101~
    REF*6R*999827361~
    HL*3*1*22*0~
    SBR*P*18**MEDICAID*****MC~
    CLM*1002222222O60482737*1***13;A;5**A*Y*Y********* **8~
    DTP*096*TM*1900~
    SE*59*0001~
    ST*837*0002*005010X223A2~
    BHT*0019*00*5093947*20111114*2335*CH~
    HL*1**20*1~
    PRV*BI*PXC*282X00000X~
    HL*2*1*22*0~
    SBR*P*18**MEDICAID*****MC~
    CLM*1002333333O60482738*1***13;A;5**A*Y*Y********* **8~
    DTP*096*TM*1900~
    DTP*472*D8*20100101~
    REF*6R*604222222~
    HL*3*1*22*0~
    SBR*P*18**MEDICAID*****MC~
    CLM*1002444444O60482739*2***13;A;5**A*Y*Y********* **8~
    DTP*096*TM*1900~
    DTP*434*RD8*20100101-20100101~
    SE*59*0002~

  2. #2
    Join Date
    Mar 2003
    Posts
    17
    Did you ever get this to work?
    Thanks for your help, Mitch

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •