MarcusOliveira
New Member
- Joined
- Jan 25, 2019
- Messages
- 2
Hey guys,
I need your help with this case (sorry for the bad english
)
I have this TXT file with payment details for each person divided by a line containing the name and year of the record, a new line with CPF number, and columns for each type of record (there are 7 colums, with headers).
The delimitator of columns are not clear (sometimes it's a space, sometimes it's a tabulation) so, I need a code to bring that lines (name and CPF) to new columns before the month column (Mês), delete the old lines and split that 7 columns in order to compose a proper database (the number of records (persons) is variable). Could you help me with that?
Below two images with before/after of what I need
Thanks in advance!
I need your help with this case (sorry for the bad english

I have this TXT file with payment details for each person divided by a line containing the name and year of the record, a new line with CPF number, and columns for each type of record (there are 7 colums, with headers).
The delimitator of columns are not clear (sometimes it's a space, sometimes it's a tabulation) so, I need a code to bring that lines (name and CPF) to new columns before the month column (Mês), delete the old lines and split that 7 columns in order to compose a proper database (the number of records (persons) is variable). Could you help me with that?
Below two images with before/after of what I need


Thanks in advance!