Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

format output in csv file

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting format output in csv file
Prev   Next
# 1  
Old 11-06-2009
Question format output in csv file
I am sending the output of a file to .csv file.
The output should look like this:

Total Customers Processed:,8
Total Customers Skipped:,0
Total Customers Added:,8
Total Customers Changed:,0


Total Policies Deleted:,0
Total Policies Failed:,0

total:,8

Now i want this output in only one cell, i.e line break in the same cell of csv file.like, we use Alt Enter on the cell in excel.

Wht my approach is , first of all i will replace the , with something else, thn i will remove the new line character with some spaces so that data comes in different lines bt in same cell, but its not working..

Please Help.........
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Python or Shell script to Grep strings from input file and output in csv format

Hi Experts, I am writing a python script to grep string from file and display output in csv file as in attached screenshot https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view Input file(result_EPFT_config_device) Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies

2. Shell Programming and Scripting

How to translate df -h output into a CSV format?

Hi, Can someone please let me know as how I can send the below df -h format of a linux system into a CSV format ? Resource Size GiB Used GiB Avail GiB Use% Cleanable GiB* ---------------- -------- -------- --------- ---- -------------- /data: pre-comp -... (10 Replies)
Discussion started by: new2prog
10 Replies

3. Shell Programming and Scripting

How to parse this file using awk and output in CSV format?

My source file looks like this: Cust-Number = "101" Cust-Name="Joe" Cust-Town="London" Cust-hobby="tennis" Cust-purchase="200" Cust-Number = "102" Cust-Name="Mary" Cust-Town="Newyork" Cust-hobby="reading" Cust-purchase="125" Now I want to parse this file (leaving out hobby) and... (10 Replies)
Discussion started by: Balav
10 Replies

4. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

5. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

6. Shell Programming and Scripting

UNIX command output in csv format

I'm just wondering is there any way to capture the output of a unix command in a csv format. df -h gives the result of filesystem,free space,Used space, use %,mounted on. Is there a way to capture the command output and format it as comma sparated or fixed length file. (3 Replies)
Discussion started by: anita81
3 Replies

7. Shell Programming and Scripting

Csv format output file using scirpt

Hi All, I get the test result file daily after running the main test script. from the resultfile, need to fetch only server info and status and put them in tabular format in a file and as well in CSV format output file. I tried using awk command but am not able to put them in tabluar... (6 Replies)
Discussion started by: Optimus81
6 Replies

8. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

9. Shell Programming and Scripting

formatting into CSV format of SQL session output

I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format . The output should be like this 'a','b','c', (4 Replies)
Discussion started by: mady135
4 Replies

10. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
Login or Register to Ask a Question

LEARN ABOUT OPENSOLARIS

n2cp

n2cp(7d)							      Devices								  n2cp(7d)

NAME

       n2cp - Ultra-SPARC T2 crypto provider device driver

DESCRIPTION

       The  n2cp  device  driver  is a multi-threaded, loadable hardware driver supporting hardware-assisted acceleration of the following crypto-
       graphic operations, which are built into the Ultra-SPARC T2 CMT processor:

	 DES:	CKM_DES_CBC, CKM_DES_ECB
	 DES3:	CKM_DES3_CBC, CKM_DES3_ECB,
	 AES:	CKM_AES_CBC, CKM_AES_ECB, CKM_AES_CTR, CKM_AES_CCM, CKM_AES_GCM
	 RC4:	CKM_RC4
	 MD5:	KM_MD5, CKM_MD5_HMAC, CKM_MD5_HMAC_GENERAL,
		  CKM_SSL3_MD5_MAC
	 SHA-1: CKM_SHA_1, CKM_SHA_1_HMAC,
		 CKM_SHA_1_HMAC_GENERAL, CKM_SSL3_SHA1_MAC
	 SHA-256:CKM_SHA256, CKM_SHA256_HMAC,
		 CKM_SHA256_HMAC_GENERAL

CONFIGURATION

       You configure the n2cp driver by defining properties in the /kernel/drv/n2cp.conf which override the default settings. The following  prop-
       erty is supported:

       nostats			   Disables the generation of statistics.  The nostats property may be used to help prevent traffic analysis, how-
				   ever, this may inhibit support personnel.

CRYPTO STATISTICS

       Solaris crypto drivers must implement statistics variables. The n2cp driver maintains the following statistics:

       cwqXstate		   State (online, offline, error) of respective cryptographic engine, CWQ X.

       cwqXsubmit		   Number of jobs submitted to CWQ X.

       cwqXqfull		   Number of times when submitting a job that the queue for CWQ X was full.

       cwqXqupdate_failure	   Number of submit job failures on CWQ X.

       des			   Total number of jobs submitted to device for DES operations.

       des3			   Total number of jobs submitted to device for DES3 operations.

       aes			   Total number of jobs submitted to device for AES operations.

       md5			   Total number of jobs submitted to device for MD5 operations.

       sha1			   Total number of jobs submitted to device for SHA-1 operations.

       sha256			   Total number of jobs submitted to device for SHA-256 operations.

       md5hmac			   Total number of jobs submitted to device for HMAC_MD5 operations.

       sha1hmac 		   Total number of jobs submitted to device for HMAC_SHA-1 operations.

       sha256hmac		   Total number of jobs submitted to device for HMAC_SHA-256 operations.

       ssl3md5mac		   Total number of jobs submitted to device for SSL3_MAC_MD5 operations.

       ssl3sha1mac		   Total number of jobs submitted to device for SSL3_MAC_SHA-1 operations.

       ssl3sha256mac		   Total number of jobs submitted to device for SSL3_MAC_SHA-256 operations.

       Note -

	 Additional statistics targeted for Sun support personnel are not documented in this manpage.

FILES

       /kernel/drv/sparcv9/n2cp

	   64-bit ELF kernel driver.

       /platform/sun4v/kernel/drv/n2cp.conf

	   Configuration file.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Architecture		     |SPARC			   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWn2cp.v		   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Unstable			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       elfsign(1), cryptoadm(1M), kstat(1M), libpkcs11(3LIB), printers.conf(4), pkcs11_kernel(5), attributes(5)

       Solaris Cryptographic Framework - Solaris Software Developer Collection

       Solaris Security for Developer's Guide - Solaris Software Developer Collection

SunOS 5.11							    13 Jan 2009 							  n2cp(7d)