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
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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
![8yiyE.png](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2F8yiyE.png&hash=fb5c48d3994d12002df8a6769733913f)
![jphKT.png](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FjphKT.png&hash=727cf76433ed3cba303e092b2861e442)
Thanks in advance!