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 REDHAT
file::basename
File::Basename(3pm) Perl Programmers Reference Guide File::Basename(3pm)NAME
fileparse - split a pathname into pieces
basename - extract just the filename from a path
dirname - extract just the directory from a path
SYNOPSIS
use File::Basename;
($name,$path,$suffix) = fileparse($fullname,@suffixlist)
fileparse_set_fstype($os_string);
$basename = basename($fullname,@suffixlist);
$dirname = dirname($fullname);
($name,$path,$suffix) = fileparse("lib/File/Basename.pm",qr{.pm});
fileparse_set_fstype("VMS");
$basename = basename("lib/File/Basename.pm",qr{.pm});
$dirname = dirname("lib/File/Basename.pm");
DESCRIPTION
These routines allow you to parse file specifications into useful pieces using the syntax of different operating systems.
fileparse_set_fstype
You select the syntax via the routine fileparse_set_fstype().
If the argument passed to it contains one of the substrings "VMS", "MSDOS", "MacOS", "AmigaOS" or "MSWin32", the file specification
syntax of that operating system is used in future calls to fileparse(), basename(), and dirname(). If it contains none of these sub-
strings, Unix syntax is used. This pattern matching is case-insensitive. If you've selected VMS syntax, and the file specification
you pass to one of these routines contains a "/", they assume you are using Unix emulation and apply the Unix syntax rules instead, for
that function call only.
If the argument passed to it contains one of the substrings "VMS", "MSDOS", "MacOS", "AmigaOS", "os2", "MSWin32" or "RISCOS", then the
pattern matching for suffix removal is performed without regard for case, since those systems are not case-sensitive when opening
existing files (though some of them preserve case on file creation).
If you haven't called fileparse_set_fstype(), the syntax is chosen by examining the builtin variable $^O according to these rules.
fileparse
The fileparse() routine divides a file specification into three parts: a leading path, a file name, and a suffix. The path contains
everything up to and including the last directory separator in the input file specification. The remainder of the input file specifi-
cation is then divided into name and suffix based on the optional patterns you specify in @suffixlist. Each element of this list can
be a qr-quoted pattern (or a string which is interpreted as a regular expression), and is matched against the end of name. If this
succeeds, the matching portion of name is removed and prepended to suffix. By proper use of @suffixlist, you can remove file types or
versions for examination.
You are guaranteed that if you concatenate path, name, and suffix together in that order, the result will denote the same file as the
input file specification.
EXAMPLES
Using Unix file syntax:
($base,$path,$type) = fileparse('/virgil/aeneid/draft.book7',
qr{.bookd+});
would yield
$base eq 'draft'
$path eq '/virgil/aeneid/',
$type eq '.book7'
Similarly, using VMS syntax:
($name,$dir,$type) = fileparse('Doc_Root:[Help]Rhetoric.Rnh',
qr{..*});
would yield
$name eq 'Rhetoric'
$dir eq 'Doc_Root:[Help]'
$type eq '.Rnh'
"basename"
The basename() routine returns the first element of the list produced by calling fileparse() with the same arguments, except that it
always quotes metacharacters in the given suffixes. It is provided for programmer compatibility with the Unix shell command base-
name(1).
"dirname"
The dirname() routine returns the directory portion of the input file specification. When using VMS or MacOS syntax, this is identical
to the second element of the list produced by calling fileparse() with the same input file specification. (Under VMS, if there is no
directory information in the input file specification, then the current default device and directory are returned.) When using Unix or
MSDOS syntax, the return value conforms to the behavior of the Unix shell command dirname(1). This is usually the same as the behavior
of fileparse(), but differs in some cases. For example, for the input file specification lib/, fileparse() considers the directory
name to be lib/, while dirname() considers the directory name to be .).
perl v5.8.0 2002-06-01 File::Basename(3pm)