How to remove extra double quotes from string in a delimited file??
Hi Unix Gurus..
I am new to Unix. Please help me. The file I am getting is as follows: Input File
I want to remove the extra " present and the output file should look like this: Output File
Please help... and thanks in advance.
Jay
Last edited by Franklin52; 07-07-2011 at 03:31 PM..
Reason: Please use code tags for data and code samples, thank you
Hi
I have to create a windows batch file which will read an input file and remove "double quotes" from each line of the file.
For eg.If input file name is abcd.csv and contents is :
"asasd,123123,213213,asd"
"esfrf,dsfsdf,234324,sdfsdf"
Then the batch file should remove "" from the... (11 Replies)
I have a flat file sample like this -
"COURSE"|"ddddd " " dddd"|"sssddd
sdsdsdsdx" dddddddd ffffff
"aaaaa" dddddddd ffffff
sdsdsd"|"xxxxxxx"|
"COURSE"|"ffff " " bbbb"|"lllll"|
The delimiter is pipe character (|) and the text are enclosed in double quotes... (5 Replies)
Hi, I am looking for a unix command which inserts double quotes around all values in a delimited file. For example,
Input File
153665031,abc,abc ,abc
131278839,def,def ,dec
179821481,efg,efg ,lmn ... (6 Replies)
I have a csv data file :
A,B,C,D,"A,B",E,"GG,H"
E,F,G,H,I,J,"S,P"
I need to replace all "," with "|" except the ones between double quotes i.e
A|B|C|D|"A,B"|E|"GG,H"
E|F|G|H|I|J|"S,P"
CAn someone assist? (8 Replies)
Hi,
I am little new to forum and new on unix side. I have a small issue below:
I am reading a file that has 5 columns something like below.
col1,col2,col3,col4,col5
Some records are having double quoted values something like below:
"value1","value2","value3","value4","value5"
I need... (8 Replies)
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)
Hi Froum.
I have tried in vain to find a solution for this problem - I'm trying to replace any double quotes within a quoted string with a single quote, leaving everything else as is.
I have the following data:
Before:
... (32 Replies)
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)
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)
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... (1 Reply)
Discussion started by: Sathyapts
1 Replies
LEARN ABOUT DEBIAN
hbpldecode
hbpldecode(1) General Commands Manual hbpldecode(1)NAME
hbpldecode - Decode a HBPL stream into human readable form.
SYNOPSIS
hbpldecode [options] <hbpl-file
DESCRIPTION
hbpldecode decodes a HBPL stream into human readable form.
A HBPL stream is the printer langauge used by the Fuji-Xerox cp105b and the Dell 1250c printers.
COMMAND LINE OPTIONS
These are the options that can appear on the command line.
-d basename
Basename of .pbm file for saving decompressed planes.
-h Print hex file offsets.
-o Print file offsets.
-D level
Set Debug level [0].
EXAMPLES
Decode an HBPL stream file.
$ hbpldecode -h 1250c-mono.prn
0: 33%-12345X@PJL JOB MODE=PRINTER
1f: @PJL SET STRINGCODESET=UTF8
3b: @PJL COMMENT DATE=06/01/2011
58: @PJL COMMENT TIME=13:28:30
73: @PJL COMMENT DNAME=empty - Notepad
96: @PJL SET JOBATTR="@LUNA=rick"
b4: @PJL SET COPIES=1
c6: @PJL SET QTY=1
d5: @PJL SET JOBATTR="@TRCH=OFF"
f2: @PJL SET DUPLEX=OFF
106: @PJL SET BINDING=LONGEDGE
120: @PJL SET RENDERMODE=GRAYSCALE
13e: @PJL SET ECONOMODE=OFF
155: @PJL SET RET=ON
165: @PJL SET JOBATTR="@IREC=OFF"
182: @PJL SET JOBATTR="@HOAD=I0A00020F"
1a5: @PJL SET JOBATTR="@JOAU=rick"
1c3: @PJL SET JOBATTR="@CNAM=RICK-VB"
1e4: @PJL SET IWAMANUALDUP=OFF
1fe: @PJL SET IWAJAMRECOVERY=AUTO
21b: @PJL SET JOBATTR="@MSIP=NORMAL"
23b: @PJL SET PAPERDIRECTION=SEF
257: @PJL SET RESOLUTION=600
26f: @PJL SET BITSPERPIXEL=8
287: @PJL SET JOBATTR="@DRDM=RASTER"
2a7: @PJL SET JOBATTR="@TCPR=33"
2c3: @PJL SET JOBATTR="@TUCR=33"
2df: @PJL SET JOBATTR="@TTRC=33"
2fb: @PJL SET JOBATTR="@TSCR=33"
317: @PJL SET JOBATTR="@GCPR=33"
333: @PJL SET JOBATTR="@GUCR=33"
34f: @PJL SET JOBATTR="@GTRC=33"
36b: @PJL SET JOBATTR="@GSCR=33"
387: @PJL SET JOBATTR="@ICPR=34"
3a3: @PJL SET JOBATTR="@IUCR=34"
3bf: @PJL SET JOBATTR="@ITRC=34"
3db: @PJL SET JOBATTR="@ISCR=34"
3f7: @PJL SET JOBATTR="@TDFT=0"
412: @PJL SET JOBATTR="@GDFT=0"
42d: @PJL SET JOBATTR="@IDFT=0"
448: @PJL ENTER LANGUAGE=HBPL
461: RECTYPE 'A' [0x41]:
462: 81 a1: 0x0
465: 82 a2: 0x7
469: 83 a2: 0x1
46d: RECTYPE 'C' [0x43]:
46e: 91 a1: 0x0
471: 92 a1: 0x1
474: 93 a1: 0x1
477: 94 a1: 0x0
47a: 95 c2: 0x0
480: 96 a1: 0x0
483: 97 c3: 0x0
489: 98 a1: 0x0
48c: 99 a4: 1 [PAGECNT]
492: 9a c4: 5104x6600 [WxH]
49c: 9b a1: 0x0
49f: 9c a1: 0x1
4a2: 9d a1: 0x9
4a5: 9e a1: 0x2
4a8: 9f a1: 0x5
4ab: a0 a1: 0x8
4ae: a1 a1: 0x0
4b1: a2 c4: 5104x6600 [WxH]
4bb: RECTYPE 'Q' [0x51]:
4bc: RECTYPE 'R' [0x52]:
4bd: a3 a1: 0x0
4c0: a4 a2: 6457 (0x1939) bytes of data...
1dfe: RECTYPE 'S' [0x53]:
1dff: RECTYPE 'D' [0x44]:
1e00: RECTYPE 'B' [0x42]:
1dff: 33%-12345X@PJL EOJ
FILES
/usr/bin/hbpldecode
AUTHOR
Rick Richardson <rick.richardson@comcast.net>