Report Format file

[Scheruku]

I'm trying to import report format file and facing few issues with the alignment. Attached the raw file, and below the output of the same. Request your help.

DATA	SEQ	PARTIDA	EMP	HIST	COMPLEMENTO	DR	CR	Bal	Conta	Referent
13/06/2019	1/41	2110300011	SCB400	002	BRADSCO Lanc. : REC. VLOS 0000     .	295.490,00	0	69.075,00	1.2.3.01.001 (        0.1) - SAMAROIS	NOVEMBR/2018
13/06/2019	1/42	5150100019	SCB400	002	DESDESCO COBRA) Lanc. : 564	0	28.358,10	97.433,10	1.2.3.01.001 (        0.1) - SAMAROIS	NOVEMBR/2018
14/06/2019	1/1	5150100001	SCB400	002	TARanc. :	0	30,31	97.463,41	1.2.3.01.001 (        0.1) - SAMAROIS	NOVEMBR/2018
14/06/2019	1/2	2110101034	SCB400	002	PAGAMRES. , REF DOLOR 7.4INA S/A ATES AU 0000     .	0	7.412,80	104.876,21	1.2.3.01.001 (        0.1) - SAMAROIS	NOVEMBR/2018

[danilang · Accepted solution]

Hi @Scheruku 

The nice thing about having to import Report type files is that you can be fairly sure the format is not going to change over time.  The bad thing is that these have different columns depending on the row, so you need to input the file delimited only by line breaks \n and parse the data inside the work flow.  

This workflow loads the entire file and then finds the Conta groups and the line items within them.  The top path parses the item rows and the bottom one parses the Conta rows.  Both have a different row format built into the Regex parse tools.  The only complex part after that is concatenating the Compemento column and ensuring that all the fields have values on the row your going to keep.  

The results look like this

Dan