Sponsored Content
Top Forums Shell Programming and Scripting Separate lines in csv by column content (newbie) Post 302590861 by tarun_agrawal on Tuesday 17th of January 2012 10:33:26 PM
Old 01-17-2012
try this

Code:
awk 'NR%4==0{print "--------------";next;} {print} END{print "--------------"}' filename


Last edited by tarun_agrawal; 01-18-2012 at 12:19 AM..
This User Gave Thanks to tarun_agrawal For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to separate file content

Hi All, I have a file like below which is having 3 fields namely companycode, companylocation & companyaddress and i want to separate all the fields individually. How can i do? File Structure: ---------------- Aberdeen Centre Aberdeen The Ming An Ins Co (HK) Ltd Academic... (30 Replies)
Discussion started by: vinsara
30 Replies

2. Shell Programming and Scripting

Convert xlsx worksheet to separate csv

Hi All, I need a solution to convert my .xlsx file which has lot of worksheet, convert to separate csv file. Is there any shell script to do this? I can’t use excel macro to do this, since it was password locked. I need the csv output as an input to my shell script. (1 Reply)
Discussion started by: ranjancom2000
1 Replies

3. UNIX for Advanced & Expert Users

Parse (delimited string) key-value pairs in a column into separate lines

Hi experts, e.g. i/p data looks like 0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405552747,9700005405717924,9700005405733788|unidentified,unidentified,unidentified|| o/p data should like - row1: 0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405552747|unidentified ... (1 Reply)
Discussion started by: sumoka
1 Replies

4. Shell Programming and Scripting

Merge *.csv files, each in separate sheets

Does anyone know how to Merge *.csv files, each in seperate sheets? (7 Replies)
Discussion started by: frhling
7 Replies

5. Shell Programming and Scripting

Print every 5 4th column values as separate row with different first column

Hi, I have the following file, chr1 100 200 20 chr1 201 300 22 chr1 220 345 23 chr1 230 456 33.5 chr1 243 567 90 chr1 345 600 20 chr1 430 619 21.78 chr1 870 910 112.3 chr1 914 920 12 chr1 930 999 13 My output would be peak1 20 22 23 33.5 90 peak2 20 21.78 112.3 12 13 Here the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

6. Shell Programming and Scripting

Need help with awk statement to break nth column in csv file into 3 separate columns

Hello Members, I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file. input file --> file.csv cat file.csv|less "product/fruit/mango","location/asia/india","type/alphonso" need output in... (2 Replies)
Discussion started by: awk-admirer
2 Replies

7. 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

8. UNIX for Dummies Questions & Answers

Fill csv entire column with content from another text file

I have a csv that looks like this: ,yude-to-nap2,0,0,0,0,0 ,2twis-yude-to-nap2,0,0,0,0,0 ,2tiws-yude-to-nap2,0,0,0,0,0 ,2arcos-yude-to-nap2,0,0,0,0,0 and another file named m1 that has a single line of text as content: Feb 1 15:30:20 How can I fill the whole the empty column of the... (1 Reply)
Discussion started by: RobertoRivera
1 Replies

9. 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

10. UNIX for Beginners Questions & Answers

How to Dump data into CSV file which is Separate by <tab>?

Dear Team, please help me to solve this problem using Linux command. I want to dump this data into an excel sheet, Suppose I have a string like: ABC PQR XYZ ASD then I expect output as a ABC XYZ PQR ASD (3 Replies)
Discussion started by: Shubham1182
3 Replies
print-service(1M)					  System Administration Commands					 print-service(1M)

NAME
print-service - select, report, import, export active print service on a system SYNOPSIS
print-service [-s service [-m] | -q | -e file | -i file] DESCRIPTION
The print-service utility manages print service selection, as well as export and import of basic print queue configuration. Only a user root privileges or with the Printer Management profile can change the active print service or import print queue configuration. OPTIONS
The following options are supported: -s service Select the active print service for on a host. service can be one of lp or cups. -m Migrate print queue configuration during print service selection. -q Report the active print service on a host. -e file Export basic print queue configuration to a file. -i file Import basic print queue configuration from a file. EXAMPLES
Example 1 Selecting a Print Service The following command selects the CUPS print service as the active print service on a host. # print-service -s cups Example 2 Reporting the Active Print Service The following command reports the active print service on a host. # print-service -q Example 3 Exporting a Print Queue Configuration The following command exports the print queue configuration from the active print service. # print-service -e /tmp/queues Example 4 Importing a Print Queue Configuration The following command imports the print queue configuration to the active print service. # print-service -i /tmp/queues EXIT STATUS
0 Successful completion. non-zero An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWpcu | +-----------------------------+-----------------------------+ |Interface Stability |Obsolete | +-----------------------------+-----------------------------+ SEE ALSO
intro(1), attributes(5) NOTES
The print queue configuration saved and restored during export, import, and migration is limited to queue name and device name. It is likely that further configuration changes will be required before imported or migrated print queues become usable. SunOS 5.11 18 Mar 2008 print-service(1M)
All times are GMT -4. The time now is 12:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy