11-11-2009
Thanks , what if the data is null its coming as '
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone help me format a csv file. My csv file have 6 columns. the last 2 columns were put on the second row.
Here is the sample output:
000584, 200829014,30,PAPER,
4200059000,'DIXIE BOWLS HEAVY DUTY DISPOSABLE 10 OZ
1. How can I put the last 2 columns in the first row,... (1 Reply)
Discussion started by: softwood
1 Replies
2. Shell Programming and Scripting
Hi I have a very large csv file with some hundreds of thousands of rows of data.
The data is in the following format:
Up to four alpha numeric characters for the first word. This is either set as 2 characters followed by 2 spaces, or as a single 4character word. This is then followed by an 8... (7 Replies)
Discussion started by: meself
7 Replies
3. Shell Programming and Scripting
Hi folks,
Please help me with csv file formatting which needs to be done in horizontal fashion.
I have data coming in separate files every hour. What I need to do is extract three values into csv file. In the next hour, I need to extract the new values beside the three values which were... (1 Reply)
Discussion started by: vharsha
1 Replies
4. 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
5. Shell Programming and Scripting
Hi,
Am using the following command to create a csv file
paste File_1.csv File_4.csv File_7.csv >Out1.csv
paste File_2.csv File_5.csv File_8.csv >>Out1.csv
paste File_3.csv File_4.csv File_9.csv >>Out1.csv
Input Data:
Expected Output:
Column 1 Column 2 ... (2 Replies)
Discussion started by: meva
2 Replies
6. Shell Programming and Scripting
Hello I wrote a perl script to output a text file filled with ip addresses and ports that i scanned into microsoft excel. Now that the data is in excel my boss wants me to organize the file in csv format such as
Server,port,protocol,random,random,random
ns1,25,tcp,stuff,stuff,stuff
Can... (0 Replies)
Discussion started by: kingbp
0 Replies
7. Shell Programming and Scripting
Hi All,
I was wondering how I can convert each line in an input file where fields are separated by variable width spaces into a CSV file. Below is the scenario what I am looking for.
My Input data in inputfile.txt
19 15657 15685 Sr2dReader 107.88 105.51... (4 Replies)
Discussion started by: vharsha
4 Replies
8. Shell Programming and Scripting
Dear friends, please your help. I got a .csv (comma separated values) file with 61 columns I need to make a script to change the original file into a new one with this actions:
Delete Columns: 1,13-20
Change the format of the following columns:
2: '2013-11-07 00:00:00' to '07/11/2013 0:00'... (5 Replies)
Discussion started by: lestatyela
5 Replies
9. Shell Programming and Scripting
Hello friends
I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns
1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g... (6 Replies)
Discussion started by: etldev
6 Replies
10. Shell Programming and Scripting
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
LEARN ABOUT NETBSD
ng_device
NG_DEVICE(4) BSD Kernel Interfaces Manual NG_DEVICE(4)
NAME
ng_device -- device netgraph node type
SYNOPSIS
#include <netgraph/ng_device.h>
DESCRIPTION
A device node is both a netgraph node and a system device interface. When a device node is created, a new device entry appears which is
accessible via the regular file operators such as open(2), close(2), read(2), write(2), etc.
The first node is created as /dev/ngd0, all subsequent nodes /dev/ngd1, /dev/ngd2, etc.
HOOKS
A device node has a single hook with an arbitrary name. All data coming in over the hook will be presented to the device for read(2). All
data coming in from the device entry by write(2) will be forwarded to the hook.
CONTROL MESSAGES
The device node supports one non-generic control message:
NGM_DEVICE_GET_DEVNAME
Returns device name corresponding to a node.
SHUTDOWN
This node shuts down upon receipt of a NGM_SHUTDOWN control message, or upon hook disconnection. The associated device entry is removed and
becomes available for use by future device nodes.
SEE ALSO
netgraph(4), ngctl(8)
HISTORY
The device node type was first implemented in FreeBSD 5.0.
AUTHORS
Mark Santcroos <marks@ripe.net>
Gleb Smirnoff <glebius@FreeBSD.org>
BSD
October 19, 2004 BSD