UNIX for Beginners Questions & Answers

Hi Team,
I have delimited file with 6gb of data and it is not hsve newline seperator.

Ask : I would like to split file into rows based on columns.

Example:
File.txt contains below data

Code:

abc-per-qwe-xyz-triv-amz-try-utr-ytu-uio-pou-cvf-bht-grt-qwe

Expected output:

Code:

abc-per-qwe
xyz-triv-amz
try-utr-ytu
uio-pou-cvf
bht-grt-qwe

Please show attempts to complete this task. Otherwise a moderator might have you do it manually with a text editor. Also, search the site for similar or exact solutions to accomplish this task.

Hi
If you use regexp you can hang the computer.

Code:

tr '-' '\n' <file | pr -3tas'-' >new_file

it takes 10 to 20 minutes
You can look at the progress.
In another window, run

Code:

progress -c pr -M

or

Code:

pv file | tr '-' '\n' | pr -3tas'-' >new_file

We do encourage users to post their own attempts before helping.
Please in the future, show your effort, as we are not your scripting service.

Give this a shot :

Code:

awk -F"-" ' { for ( i=3;i<=NF;i+=3) print $(i-2) FS $(i-1) FS $i }' input

Regards
Peasant.

Code:

<file tr - $'\n' | paste -sd'--\n'
abc-per-qwe
xyz-triv-amz
try-utr-ytu
uio-pou-cvf
bht-grt-qwe

It prints the line occurrence of column 1 ($1). a[$1]++ fails for the first occurrence increment since the array value for that key does not exist. The ! means not true so the expression is evaluated to true. The default action for true in awk is to print the line. In other terms: if the previous value of column 1 in array "a" cannot be incremented then print the line. The line could have been written as: '{if (! a[$1]++) print $0}'

Speed increased 5-10 times!
6GB single line file completely froze the system