This is my first time working on FIXML file.    Below are some information:   http://fixwiki.org/fixwiki/FPL:FIXML_Syntax     example data below:   <MyRpt RptID="ABCD1234" Dt="2019-03-07"><Pty ID="SAM" RI="A21" /><Pty ID="00615" RI="B41" > <Sub ID="C" Typ="26"/></Pty><Instrmt Sym="IBM" CID="ABCDEF" MMY="20190308" MatDt="2019-03-08" Price="40" Curr="USD" Mult="100"/><Qty Typ="AS" Short="2"/><Amt Typ="SELL" Amt="8000"/></MyRpt> ... View more

The report is in text file and it is input. I need to convert a report into a usable form (a delimited file).    Input report:   REC0168319KAYING MANAGER 1001 30227 INCORRECT DEPARTMENT ID REC0164567WALSH HR 4001 29040 INCORRECT EMPLOYEE ID REC0168319KAYING MANAGER 1001 30227 INCORRECT DEPARTMENT ID REC0168934JOHN SALES 1001 30227 INCORRECT DEPARTMENT ID 29040 INCORRECT EMPLOYEE ID REC0168345BLAZE ANALYST 2001 REC0168212WADE HR 4001 REC0168458JONAS ANALYST 2001 30227 INCORRECT DEPARTMENT ID 29040 INCORRECT EMPLOYEE ID 30227 INCORRECT DEPARTMENT ID 29040 INCORRECT EMPLOYEE ID 30227 INCORRECT DEPARTMENT ID     Output: REC_ID~EMP_ID~EMP_NAME~EMP_ROLE~DEPT_ID~Error01~Error02~ REC01~68319~KAYING ~MANAGER ~1001~30227 INCORRECT DEPARTMENT ID~ REC01~64567~WALSH ~HR ~4001~29040 INCORRECT EMPLOYEE ID~ REC01~68319~KAYING ~MANAGER ~1001~30227 INCORRECT DEPARTMENT ID~ REC01~68934~JOHN ~SALES ~1001~30227 INCORRECT DEPARTMENT ID~29040 INCORRECT EMPLOYEE ID~ REC01~68345~BLAZE ~ANALYST ~2001~30227 INCORRECT DEPARTMENT ID~29040 INCORRECT EMPLOYEE ID~ REC01~68212~WADE ~HR ~4001~30227 INCORRECT DEPARTMENT ID~29040 INCORRECT EMPLOYEE ID~ REC01~68458~JONAS ~ANALYST ~2001~30227 INCORRECT DEPARTMENT ID~         ... View more

thank you for reply. The report does not have record number at the end.    I included it to explain the report structure.    Below is actual report without record# at the end.    REC0168319KAYING MANAGER 1001 30227 INCORRECT DEPARTMENT ID REC0164567WALSH HR 4001 30227 INCORRECT EMPLOYEE ID REC0168319KAYING MANAGER 1001 30227 INCORRECT DEPARTMENT ID REC0168934JOHN SALES 1001 30227 INCORRECT DEPARTMENT ID 29040 INCORRECT EMPLOYEE ID REC0168345BLAZE ANALYST 2001 REC0168212WADE HR 4001 REC0168458JONAS ANALYST 2001 30227 INCORRECT DEPARTMENT ID 29040 INCORRECT EMPLOYEE ID 30227 INCORRECT DEPARTMENT ID 29040 INCORRECT EMPLOYEE ID 30227 INCORRECT DEPARTMENT ID ... View more

@andreas_lds wrote: I don't understand what you have and what you want as output. Please post data in usable form: a data-step creating the dataset that you want to export. Then add what you exactly expect as output. we send record to update the database. The records that were not updated were returned to us as a report.    The sample report below. It has the update record (which was rejected)followed by error message.  REC0168319KAYING MANAGER 1001 ==> actual update record #1 30227 INCORRECT DEPARTMENT ID ==> unique error number & error message.#1 REC0164567WALSH HR 4001 ==> actual update record #2 30227 INCORRECT EMPLOYEE ID ==> unique error number & error message.#2 REC0168319KAYING MANAGER 1001 ==> actual update record #3 30227 INCORRECT DEPARTMENT ID ==> unique error number & error message.#3 REC0168934JOHN SALES 1001 ==> actual update record #4 30227 INCORRECT DEPARTMENT ID ==> unique error number & error message.#4 29040 INCORRECT EMPLOYEE ID ==> unique error number & error message.#4 REC0168345BLAZE ANALYST 2001 ==> actual update record #5 REC0168212WADE HR 4001 ==> actual update record #6 REC0168458JONAS ANALYST 2001 ==> actual update record #7 30227 INCORRECT DEPARTMENT ID ==> unique error number & error message.#5 29040 INCORRECT EMPLOYEE ID ==> unique error number & error message.#5 30227 INCORRECT DEPARTMENT ID ==> unique error number & error message.#6 29040 INCORRECT EMPLOYEE ID ==> unique error number & error message.#6 30227 INCORRECT DEPARTMENT ID ==> unique error number & error message.#7 I am trying to breakdown this report into a delimited file. The report is not consistent pattern.    ... View more