06-24-2015
Remove pipe(|) symbol ina file, except the ones which are enclosed in double quotes
I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes.
If your quote file is:
|Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|"
It should return:
Life is Beautiful"|"Indeed life is beautiful too"|"But unix is fun is not "|"
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi i am new on Unix..........
I have to write a ddl and for tables and I am using single quotes in the comment for the table and its column...........but when i see on the unix server the ' dont show .
e.g. DROP TABLE DMR_PURGED;
CREATE TABLE DMR_PURGED
(
HEALTH_SERVICE_ID ... (9 Replies)
Discussion started by: agarwalniru
9 Replies
2. UNIX for Advanced & Expert Users
I want to remove the comma which is present within the double quoted string. All other commas which is present outside double quotes should be present.
Input : a,b,"cc,dd,ee",f,ii,"jj,kk",mmm
output : a,b,"ccddee",f,ii,"jjkk",mmm (3 Replies)
Discussion started by: mohan_tuty
3 Replies
3. Shell Programming and Scripting
hi guys i have 6000 rows column
the text in the column has the symbol vertical bar |.
i tried some of the commands to remove it but none of the commands are reconzng this symbol. would u plz help to remove this symbol from the text with any kind of unix command
u r help would be appreciated
... (9 Replies)
Discussion started by: bogu0001
9 Replies
4. Shell Programming and Scripting
How to remove characters enclosed in single quotes?
My data is something like this
(03/22/2011 08:17:26.650) : ( -> '1' -> '1-1-3' -> '6' -> '1' -> 'SALMOR58BB4' aaaaa bbbbbb ccccc ((dddd))
I want the output to be
(03/22/2011 08:17:26.650) : ( -> -> -> -> -> aaaaa... (2 Replies)
Discussion started by: rdhanek
2 Replies
5. Shell Programming and Scripting
Hi Unix Gurus..
I am new to Unix. Please help me. The file I am getting is as follows:
Input File
"2011-07-06 03:53:23","0","I","NOT SET ",,,,"123985","SAW CUT CONCRETE SLAB 20"THICK",,"98.57","","EACH","N"
"2011-07-06 03:53:23","0","I","NOT SET ",,,,"204312","ARMAFLEX-1 3/8 X... (2 Replies)
Discussion started by: BICC
2 Replies
6. Shell Programming and Scripting
I have a file that looks like this:
102| #2 X 1/4-INCH| 30188| EA| FTW| A| NOT SERIAL TRACKING| NOT LOT TRACKING| TRUE| #2 X 1/4-INCH
102| #2 X 1/4-INCH| 30188| EA| VPS| A| NOT SERIAL TRACKING| NOT LOT TRACKING| TRUE| #2 X 1/4-INCH
102| #6 X 1/2"| ... (2 Replies)
Discussion started by: djehresmann
2 Replies
7. Shell Programming and Scripting
Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote.
Please see the sample file as below:
column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10... (8 Replies)
Discussion started by: dhruuv369
8 Replies
8. Shell Programming and Scripting
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Discussion started by: mathias23
5 Replies
9. Shell Programming and Scripting
Hi All,
I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.
Sample Data :
"221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies
10. Shell Programming and Scripting
I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes.
If your quote file is:
|Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|"
It should return:
Life is Beautiful"|"Indeed life is... (9 Replies)
Discussion started by: Sathyapts
9 Replies
LEARN ABOUT CENTOS
funimagerowget
funimagerowget(3) SAORD Documentation funimagerowget(3)
NAME
FunImageRowGet - get row(s) of an image
SYNOPSIS
#include <funtools.h>
void *FunImageRowGet(Fun fun, void *buf, int rstart, int rstop,
char *plist)
DESCRIPTION
The FunImageRowGet() routine returns one or more image rows from the specified section of a Funtools data file. If the input data are of
type image, the array is generated by extracting the specified image rows and then binning them according to the specified bin factor. If
the input data are contained in a binary table or raw event file, the rows are binned on the columns specified by the bincols= keyword
(using appropriate default columns as needed), after which the image section and bin factors are applied.
The first argument is the Funtools handle returned by FunOpen(). The second buf argument is a pointer to a data buffer to fill. If NULL is
specified, FunImageGet() will allocate a buffer of the appropriate size.
The third and fourth arguments specify the first and last row to retrieve. Rows are counted starting from 1, up to the value of
FUN_YMAX(fun). The final plist (i.e., parameter list) argument is a string containing one or more comma-delimited keyword=value parame-
ters. It can be used to specify the return data type using the bitpix= keyword. If no such keyword is specified in the plist string, the
data type of the image is the same as the data type of the original input file, or is of type int for FITS binary tables.
If the bitpix=value is supplied in the plist string, the data type of the returned image will be one of the supported FITS image data
types:
o 8 unsigned char
o 16 short
o 32 int
o -32 float
o -64 double
For example:
double *drow;
Fun fun;
... open files ...
/* get section dimensions */
FunInfoGet(fun, FUN_SECT_DIM1, &dim1, FUN_SECT_DIM2, &dim2, 0);
/* allocate one line's worth */
drow = malloc(dim1*sizeof(double));
/* retrieve and process each input row (starting at 1) */
for(i=1; i <= dim2; i++){
if( !FunImageRowGet(fun, drow, i, i, "bitpix=-64") )
gerror(stderr, "can't FunImageRowGet: %d %s
", i, iname);
/* reverse the line */
for(j=1; j<=dim1; j++){
... process drow[j-1] ...
}
}
...
On success, a pointer to the image buffer is returned. (This will be the same as the second argument, if NULL is not passed to the latter.)
On error, NULL is returned. Note that the considerations described above for specifying binning columns in FunImageGet() also apply to
FunImageRowGet().
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funimagerowget(3)