Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to Dump data into CSV file which is Separate by <tab>?
Top Forums UNIX for Beginners Questions & Answers How to Dump data into CSV file which is Separate by <tab>? Post 303032610 by nezabudka on Thursday 21st of March 2019 03:45:09 AM
Old 03-21-2019
Code:
pr -mts$'\t' <(sed '/^$/,$d' file) <(sed '1,/^$/d' file)

a different order would be easier
Code:
fmt file | column -t

But I understand the elementary example has a more complex structure?

--- Post updated at 09:46 ---

Code:
paste  <(sed '/^$/,$d' file) <(sed '1,/^$/d' file)

--- Post updated at 10:45 ---

Code:
awk '
BEGIN           {i=0}
!/^$/           {BUF[i] = BUF[i] sp $0; i+=1}
/^$/            {i=0; sp = "\t"}
END             {for (i in BUF) print BUF[i]}
' file

Last edited by nezabudka; 03-21-2019 at 04:54 AM..
This User Gave Thanks to nezabudka For This Post:
Shubham1182
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to create a CSV File by reading fields from separate files

SHELL SCRIPT Hi, I have 3 separate files within a folder. Every File contains data in a single column like File1 contains data mayank sushant dheeraj File2 contains DSA_AT MG_AT FLAT_09 File3 contains data 123123 232323 (2 Replies)
Discussion started by: mayanksargoch
2 Replies

2. Shell Programming and Scripting

Shell script - Excel/CSV file - More than one tab

Hi All, Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more. We are generating different reports through shell script after we finish our data load. Currently there are 7 such... (5 Replies)
Discussion started by: ace_friends22
5 Replies

3. Shell Programming and Scripting

Conversion of xhtml data into csv format using dump utility

Hi Unix Gurus, I tried to convert the attached xhtml table content into csv file using unix shell script (lynx -dump filename) and got the below results: Title ID Owner Priority Estimate Project Change Date Changed By Complexity Create Date Created By Detail Estimate Total De tail... (6 Replies)
Discussion started by: bi.infa
6 Replies

4. UNIX for Dummies Questions & Answers

using sed delete a line from csv file based on specific data in two separate fields

Hello, :wall: I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books. I know this does not work /^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d Any ideas? Thanks Please... (2 Replies)
Discussion started by: Chris Eagleson
2 Replies

5. Shell Programming and Scripting

How to add a new sheet or a new tab in a csv file?

Hi All, I woulk like thanks to all of you for your instant support. I am again in a trouble so move to here for solution. I want to add a new sheet or a new tab in a csv file means a singly csv file having two or more sheets. Please help me any help towards this should highly be appreciated. ... (3 Replies)
Discussion started by: Ashish Singhal
3 Replies

6. Shell Programming and Scripting

Csv file separate using awk

Hi, I have file like below apple,orange,pineapple,pappya,guva,avocado want to store as apple orange pineapple pappya I tried below command to seprate first field command1: (3 Replies)
Discussion started by: stew
3 Replies

7. UNIX for Dummies Questions & Answers

Writing multiple outputs in to separate cells of CSV file

Hi I am writing a script which has multiple awk statements and each statement gives me a numeric count as an output. I want those output to be stored in different cells of a csv file. say 12 awk statements give 12 output and i want them in diffrenet cells of csv file. Thank you guys..!! (4 Replies)
Discussion started by: prabhat.diwaker
4 Replies

8. Shell Programming and Scripting

How to convert space&tab delimited file to CSV?

Hello, I have a text file with space and tab (mixed) delimited file and need to convert into CSV. # cat test.txt /dev/rmt/tsmmt32 HP Ultrium 6-SCSI J3LZ 50:03:08:c0:02:72:c0:b5 F00272C0B5 0/0/6/1/1.145.17.255.0.0.0 /dev/rmt/c102t0d0BEST /dev/rmt/tsmmt37 ... (6 Replies)
Discussion started by: prvnrk
6 Replies

9. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

10. Shell Programming and Scripting

How to separate data coming in one column of CSV file?

I am running an ISQL command on Sybase DB and getting output of a query in an CSV file. The issue is that all the data comes in to the same column, i want them to be separated in different columns. SQL_COMMAND=command.sql file=file.txt formatFile=formatFile.txt report=report.csv echo... (1 Reply)
Discussion started by: Sharma331
1 Replies

LEARN ABOUT CENTOS

conflict

CONFLICT(8)                                                          [nmh-1.5]                                                         CONFLICT(8)

NAME

       conflict - search for alias/password conflicts

SYNOPSIS

       /usr/lib/mh/conflict [-search directory] [-mail name] [-version] [-help] [aliasfiles ...]

DESCRIPTION

       Conflict is a program that checks to see if the interface between nmh and the transport system is in good shape

       Conflict also checks for maildrops in /var/mail which do not belong to a valid user.  It assumes that no user name will start with `.', and
       thus ignores files in /var/mail which begin with `.'.  It also checks for entries in the group(5) file which do not belong to a valid user,
       and for users who do not have a valid group number.  In addition duplicate users and groups are noted.

       If  the  -mail  name  switch is used, then the results will be sent to the specified name.  Otherwise, the results are sent to the standard
       output.

       The -search directory switch can be used to search directories other than /var/mail and to report  anomalies  in  those  directories.   The
       -search directory switch can appear more than one time in an invocation to conflict.

       Conflict should be run under cron(8), or whenever system accounting takes place.

FILES

       /etc/nmh/mts.conf          nmh mts configuration file
       /etc/passwd                List of users
       /etc/group                 List of groups
       /usr/bin/mh/mhmail         Program to send mail
       /var/mail/                 Directory of mail drop

PROFILE COMPONENTS

       None

SEE ALSO

       mh-alias(5)

DEFAULTS

       `aliasfiles' defaults to /etc/nmh/MailAliases

CONTEXT

       None

MH.6.8                                                             11 June 2012                                                        CONFLICT(8)
All times are GMT -4. The time now is 09:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy