06-19-2009
relevant unix code
can anybdy help me with the relevant unix code for removing multiple instances of comma in double quotes in single row
in a comma delimited file
input
====
"ro,han","ra,hul","ku,nal","vishe,sh"
output
===
"rohan","rahul","kunal","vishesh"
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear all
I have a file which looks like this
xxxxxxxxxxxxxx,xxx,xxxxxxxxxx
xxxxxxxxxxxxxx,xxx,xxxxxxxxxx
etc
basically 14 characters then a comma, three characters, then a comma then 10 characters. We are uploading this file to our mainframe and they want the commas removed, so it... (6 Replies)
Discussion started by: hcclnoodles
6 Replies
2. HP-UX
Hi Gurus,
There is a ASCII file in which a comma is used as a seperator for the amount field when the amount exceed seven digits: e.g. 0001300,000. Now, this comma needs to be removed from this field, after padding leading zeros (to maintain the ASCII positions) e.g. 00001300000.... (1 Reply)
Discussion started by: pranag21
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I get some flat files with trailer which gives the totol records count and i want to remove the trailer from the file.
i used the following command it works fine with a single file.
cat file_name | grep -v 'Total records:' > file1
mv file file_name
But i dont know how to remove the... (12 Replies)
Discussion started by: kumarsaravana_s
12 Replies
4. UNIX for Dummies Questions & Answers
hi
I have an expression
aaabbb; xxx xxxi
i need to get the ouput as
xxx xxxi
i am using sed -e 's/\(*;\)//g' but it is not working..??
can some one suggest..
This is urgent (9 Replies)
Discussion started by: aixjadoo
9 Replies
5. Shell Programming and Scripting
i have the below line as output from a script. I want to delete the string "," and get the output without comma,
cat D* | grep "bytes free" | awk '{print $3}' | ?????
output:
40,966,189,056
Desired O/P:
40966189056 (1 Reply)
Discussion started by: ali560045
1 Replies
6. Shell Programming and Scripting
Hi ,
Im relatively new to unix and have to process a comma serparated flat file . I recieve some of the fields in double quotes and i want to remove it ..
INPUT
====
filed1,field2,field3,"fie,ld4"
OUTPUT
=====
field1,field2,field3,"field4"
can anyone tell me how to achieve... (10 Replies)
Discussion started by: r_t_1601
10 Replies
7. Shell Programming and Scripting
Hi Experts,
I have below strings
hello,hi,,,,,,start date
age,code,,,,,61,season
I am trying to format this string to
hello,hi,start date
age,code,61,season
Can anyone please help me in achieving this?
Kind Regards,
RB (3 Replies)
Discussion started by: ramakanth_burra
3 Replies
8. Shell Programming and Scripting
Hi all,
I haven't needed to do any shell based editing for nearly 20 years, and no amount of searching around has found me a solution to this very simple problem :-(
I have a csv file.
Some lines have three commas at the end. This means the invoice hasn't been paid.
I'd like to use sed / grep... (4 Replies)
Discussion started by: chardyzulu
4 Replies
9. Shell Programming and Scripting
Hello Team,
Could you please help me with the below question?
I have a file with the following properties
1) File Delimiter is ;
2) Text columns are within double quotes
3) Numeric columns will not have double quotes
4) File has total 6 columns
Please see a sample record from file
... (3 Replies)
Discussion started by: sam99
3 Replies
10. UNIX for Beginners Questions & Answers
Hi
I'm creating a sh script to generate a csv file. The CSV contains the values from a sql table.
The content looks this:
a,b,c,c2,c3,,,,,,,,,,,d,e
I have some code that can separate the fields using the comma as delimiter, but some values actually contain commas, such as... (2 Replies)
Discussion started by: preema
2 Replies
LEARN ABOUT DEBIAN
h5totxt
H5TOTXT(1) h5utils H5TOTXT(1)
NAME
h5totxt - generate comma-delimited text from 2d slices of HDF5 files
SYNOPSIS
h5totxt [OPTION]... [HDF5FILE]...
DESCRIPTION
h5totxt is a utility to generate comma-delimited text (and similar formats) from one-, two-, or more-dimensional slices of numeric datasets
in HDF5 files. This way, the data can easily be imported into spreadsheets and similar programs for analysis and visualization.
HDF5 is a free, portable binary format and supporting library developed by the National Center for Supercomputing Applications at the Uni-
versity of Illinois in Urbana-Champaign. A single h5 file can contain multiple data sets; by default, h5totxt takes the first dataset, but
this can be changed via the -d option, or by using the syntax HDF5FILE:DATASET.
By default, the entire dataset is dumped to the output. in row-major order. For 3d datasets, this corresponds to a sequence of yz slices,
in order of increasing x, separated by blank lines. If -T is specified, outputs in the transposed (column-major) order instead
Often, however, you want only a one- or two-dimensional slice of multi-dimensional data. To do this, you specify coordinates in one or
more slice dimensions, via the -xyzt options.
The most basic usage is something like 'h5totxt foo.h5', which will output comma-delimited text to stdout from the data in foo.h5.
OPTIONS
-h Display help on the command-line options and usage.
-V Print the version number and copyright info for h5totxt.
-v Verbose output.
-o file
Send text output to file rather than to stdout (the default).
-s sep Use the string sep to separate columns of the output rather than a comma (the default).
-x ix, -y iy, -z iz, -t it
This tells h5totxt to use a particular slice of a multi-dimensional dataset. e.g. -x causes a yz plane (of a 3d dataset) to be
used, at an x index of ix (where the indices run from zero to one less than the maximum index in that direction). Here, x/y/z cor-
respond to the first/second/third dimensions of the HDF5 dataset. The -t option specifies a slice in the last dimension, whichever
that might be. See also the -0 option to shift the origin of the x/y/z slice coordinates to the dataset center.
-0 Shift the origin of the x/y/z slice coordinates to the dataset center, so that e.g. -0 -x 0 (or more compactly -0x0) returns the
central x plane of the dataset instead of the edge x plane. (-t coordinates are not affected.)
-T Transpose the data (interchange the dimension ordering). By default, no transposition is done.
-. numdigits
Output numdigits digits after the decimal point (defaults to 16).
-d name
Use dataset name from the input files; otherwise, the first dataset from each file is used. Alternatively, use the syntax
HDF5FILE:DATASET, which allows you to specify a different dataset for each file. You can use the h5ls command (included with hdf5)
to find the names of datasets within a file.
BUGS
Send bug reports to S. G. Johnson, stevenj@alum.mit.edu.
AUTHORS
Written by Steven G. Johnson. Copyright (c) 2005 by the Massachusetts Institute of Technology.
h5utils March 9, 2002 H5TOTXT(1)