Convert text to csv

Shell Programming and Scripting
1

Hi,

Is there somebody there to post an idea on how to convert this 5 liner row to 1 liner or tab delimiter to be import to database.

Here the text file format:

Description: Description1
Link: https://www.google.com
Date: June 2, 2018
Time: 00:07:44
Age: 1 days ago
Description: Description12
Link: https://www.google.com
Date: May 2, 2018
Time: 00:07:44
Age: 1 days ago
Description: Description14
Link: https://www.google.com
Date: August 2, 2018
Time: 00:07:44
Age: 1 days ago
Description: Description18
Link: https://www.google.com
Date: July 2, 2018
Time: 00:07:44
Age: 1 days ago
Description: Description110
Link: https://www.google.com
Date: September 2, 2018
Time: 00:07:44
Age: 1 days ago

Thank you so much

2 
IFS=":"
while read desc DESC

do
    read link LINK
    read date DATE
    read time TIME
    read age AGE
    echo "$DESC \t $LINK \t $DATE \t $TIME \t $AGE"
done

you may need to use 'echo -e' instead of 'echo'

1 Like
3

Not sure what exactly the output should look like, but try also

paste -sd"\t\t\t\t\n" file
Description: Description1	Link: https://www.google.com	Date: June 2, 2018	Time: 00:07:44	Age: 1 days ago
Description: Description12	Link: https://www.google.com	Date: May 2, 2018	Time: 00:07:44	Age: 1 days ago
Description: Description14	Link: https://www.google.com	Date: August 2, 2018	Time: 00:07:44	Age: 1 days ago
Description: Description18	Link: https://www.google.com	Date: July 2, 2018	Time: 00:07:44	Age: 1 days ago
Description: Description110	Link: https://www.google.com	Date: September 2, 2018	Time: 00:07:44	Age: 1 days ago
1 Like