|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Option in sql script to include column headers when spooling file to .csv format
Post 302324338 by vidyadhar85 on Wednesday 10th of June 2009 01:25:02 PM
06-10-2009
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
2. Shell Programming and Scripting
Hi all,
I have a huge csv file with the following format of data,
Num SNPs, 549997
Total SNPs,555352
Num Samples, 157
SNP, SampleID, Allele1, Allele2
A001,AB1,A,A
A002,AB1,A,A
A003,AB1,A,A
...
...
...
I would like to write out a list of unique SNP (column 1). Could you... (3 Replies)
Discussion started by: phoeberunner
3 Replies
3. Shell Programming and Scripting
I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ?
I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I... (4 Replies)
Discussion started by: Sriranga
4 Replies
4. Shell Programming and Scripting
Hi,
I have a script I am developing (actually more than 1 just now).
1st part - executes SQL in a 2nd script.
2nd part - reformats the output of the sql into a csv
Problem:
How am I able to run the SQL from the first script? I assume there is a sql command? I generally use isql when... (6 Replies)
Discussion started by: mcclunyboy
6 Replies
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
Hi All,
The below sar -u command generates multiple column headers in csv file
Expected output should print column headers only once in the csv file
shell script:
$cat sar_cpu_EBS.sh
#!/bin/bash
while ; do
sar -u 15 1 | awk '/^/ {print $1,$2,$4,$6,$7}' | tr -s ' ' ',' >>... (6 Replies)
Discussion started by: a1_win
6 Replies
7. UNIX for Dummies Questions & Answers
Hi Guys,
Another questions to the genius over here. I have spool the dataf from the database into a .csv file. But can it be possible to have all the rows and column with the boundaries..for example the .csv file which i have is as below:
20140327 BU 9A 3
20140327 SPACE 9A 3
20140327... (8 Replies)
Discussion started by: Pramod_009
8 Replies
8. Shell Programming and Scripting
I had a requirement to check if data exists after headers (typically row 2 & so on) in csv file.
please help how we can check through shellscript in linux.
Thank you !! (1 Reply)
Discussion started by: chandu123
1 Replies
9. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
10. Shell Programming and Scripting
All,
I guess by this time someone asked this kind of question, but sorry I am unable to find after a deep search.
Here is my request
I have many files out of which 2 sample files provided below.
File-1 (with A,B as column headers)
A,B
1,2
File-2 (with C, D as column headers)
C,D
4,5
I... (7 Replies)
Discussion started by: ks_reddy
7 Replies
LEARN ABOUT CENTOS
struct_sk_buff
STRUCT
SK_BUFF(9) Linux Networking STRUCT SK_BUFF(9) NAME
struct_sk_buff - socket buffer SYNOPSIS
struct sk_buff { struct sk_buff * next; struct sk_buff * prev; ktime_t tstamp; struct sock * sk; struct net_device * dev; char cb[48]; unsigned long _skb_refdst; #ifdef CONFIG_XFRM struct sec_path * sp; #endif unsigned int len; unsigned int data_len; __u16 mac_len; __u16 hdr_len; union {unnamed_union}; __be16 inner_protocol; __u16 inner_transport_header; __u16 inner_network_header; __u16 inner_mac_header; __u16 transport_header; __u16 network_header; __u16 mac_header; sk_buff_data_t tail; sk_buff_data_t end; unsigned char * head; unsigned char * data; unsigned int truesize; atomic_t users; }; MEMBERS
next Next buffer in list prev Previous buffer in list tstamp Time we arrived sk Socket we are owned by dev Device we arrived on/are leaving by cb[48] Control buffer. Free for use by every layer. Put private vars here _skb_refdst destination entry (with norefcount bit) sp the security path, used for xfrm len Length of actual data data_len Data length mac_len Length of link layer header hdr_len writable header length of cloned skb {unnamed_union} anonymous inner_protocol Protocol (encapsulation) inner_transport_header Inner transport layer header (encapsulation) inner_network_header Network layer header (encapsulation) inner_mac_header Link layer header (encapsulation) transport_header Transport layer header network_header Network layer header mac_header Link layer header tail Tail pointer end End pointer head Head of buffer data Data head pointer truesize Buffer size users User count - see {datagram,tcp}.c COPYRIGHT
Kernel Hackers Manual 3.10 June 2014 STRUCT SK_BUFF(9)