Support Questions
Find answers, ask questions, and share your expertise

How to transform an unstructured data to structured data in Nifi ?

How to transform an unstructured data to structured data in Nifi ?

New Contributor

I am working with an unstructured log file that I have split using SplitText. 

this is one of my Record:

 

 

CELLMEAS,10:02:30.207,,7,0,6,10,0,70007,3050,242,-31.3,-65.1,-13.9,16001,84.0,,10,70003,1350,132,-46.5,-74.6,-8.1,,,,2,70007,3050,30,-33.6,-75.1,-21.4,,,,2,70007,3050,23,-33.1,-76.9,-23.9,,,,2,70007,3050,48,-35.1,-79.3,-24.3,,,,2,70003,1350,173,-47.9,-84.3,-16.4,,,

 

 

I am looking for a way to delete the 7 firsts columns and split that information so I can get 5 records from this:

 

 

0,70007,3050,242,-31.3,-65.1,-13.9,16001,84.0, ,
10,70003,1350,132,-46.5,-74.6,-8.1,,,,
2,70007,3050,30,-33.6,-75.1,-21.4,,,,
2,70007,3050,23,-33.1,-76.9,-23.9,,,,
2,70007,3050,48,-35.1,-79.3,-24.3,,,,
2,70003,1350,173,-47.9,-84.3,-16.4,,,

 

 

 Thanks