Reply
New Contributor
Posts: 1
Registered: ‎11-21-2016

Any idea to turn semi structure to structure data

Hi all Can you help me share the idea to turn semi structure to structure data 

 

I have Reporting Fixlenght file  like picture below 

 

ask.jpg

 

- I Need to capture  Filed  As of Date (Top header yellow) to every row  

-I need capture Report to (secound line yellow)  to every row  

the final output that i expected  is

 

<as of date>  <Report to> <Customer ID> <Dimension>

27-08-2559        001              S1230               3*10*23

27-08-2559        001              A0711                4*12*17

27-08-2559        001             M2312                5*10*23    

.................         ......              ..........                 ...........

27-08-2559        002              C0048                8*8*22

 

Please Advice  thanks in advance