Hello, I am receiving a .txt file that its ordenated like this:
1) ---------------------------------------
2) guest:!:100:100:Usuario de Sistema Operativo, guest:/home/guest:/bin/false
3) ---------------------------------------
4) SU 07/06 14:45 + pts/2 c387133-root
5) SU 07/06 18:09 + pts/1 z225029-root
6) ---------------------------------------
7) system:!:0:root,esaadmin
so I need the workflow to read that column and take as a delimiter the "---------------------------------------" row and generate three different tables with the data between the delimiters in order to work with them separately, so it would be like this:
table 1:
guest:!:100:100:Usuario de Sistema Operativo, guest:/home/guest:/bin/false
table 2:
SU 07/06 14:45 + pts/2 c387133-root
SU 07/06 18:09 + pts/1 z225029-root
table 3:
system:!:0:root,esaadmin
Solved! Go to Solution.
I would do this in the following order - there could be a simpler way to achieve the same result.
Attaching the workflow for reference. I chose to export the data as separate worksheets of an Excel workbook; but the same would also work for a DB output.
Best,
Salankayana