I have a text file having this kind of data
REC_CODE ORDER_ID CUSTOMER_ID ORDER_DATE
ORD 1 1 01-01-2001
LIN 1 1 1 1
LIN 1 2 2 3
LIN 1 3 1 2
ORD 2 3 02-01-2001
LIN 2 1 1 1
LIN 2 2 2 3
LIN 2 3 1 2
If you see this data carefully ORD corresponds to the Order Level details where as LIN corresponds to Line details of the Order, The problem is the file is not delimited or having fixed width this varies as you can see there are single space and multiple spaces in file.
Any suggestions on handling this in ODI to import the data and process it ? I tried File technology for this since it is unstructured i was not able to get through the first step.