Replace double quotes inside the string data for all the columns
Moderator's Comments:
Please use code tags
Hi,
I have input data is below format and n of column in the multiple flat files. the string data has any double quotes(") values replaced to double double quotes for all the columns{"").
Also, my input flat file each column string data has carriage of new line too. this new lines also should replace double double quotes if data has presence single double quotes.
Please advise me how to handle this using awk or sed comand.
Thanks,
Regard,
Srini
Last edited by jim mcnamara; 05-16-2018 at 12:52 AM..
I'm having a strange problem with escaping double-quotes. I have a script that looks like this:
#!/bin/bash
for HOST in `cat $INFILE | grep -v ^#`
do
for VFILER in `some_command`
do
echo " "
echo -e '\E
The problem with ssh command... (3 Replies)
I have a csv file with lines like the followings
123456,"ABC CO., LTD","XXX"
789012,"DEF LIMITED", "XXX"
before I bcp this file to database, the comma in "CO.," need to be removed first.
My script is cat <filename> | sed 's/"CO.,"/"CO."/g'
but it doesn't work. Can anyone here able to... (2 Replies)
Hi,
I have a requirement to replace the comma's inside the double quotes. The comma's inside the double quotes will get changed dynamically.
Input Record:
"Washington, DC,Prabhu,aju",New York
Output Record:
"Washington| DC|Prabhu|aju",New York
I tried with the below command but it... (3 Replies)
Hi i have a file with follw data
"20090427","0","","16371311","-100200","","","","16371311","JUL","09"
In the 10th column i need to convert the month name into month number in this case JUL will be 7 and append the 10th and 11th column which shows me the output as 709. Can you suggest a shell... (11 Replies)
Hi,
I have data as
"01/22/97-"aaaaaaaaaaaaaaaaa""aaa""aabbbbbbbbcccccc""zbcd""dddddddddeeeeeeeeefffffff"
I want to remove only the Consequitive double quotes and not the one which occurs single.
My O/P must be ... (2 Replies)
Hi,
I have an input file like this
$ cat infile
hi,i,"am , sam", y
hello ,good, morning
abcd, " ef, gh " ,ij
no, "good,morning", yes, "good , afternoon"
from this file I have to split the fields on basis of comma"," however, I the data present inside double qoutes should be treated as... (3 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)
Hi All,
I have been trying to replace a string using the sed command
string value contain blackslash and double quotes. I am not a expert writer of unix script but do try not to ask question. I have almost given up. Hope you all can give me some suggestion
I want to replace a place string... (6 Replies)
Hi All,
I want to replace the commas which are not inside parenthesis,quotes
if input is
abc,,lm,(no,pq,rs),{tu,vw,xy},zs,"as,as,fr",'ab,cd,ef'
output should be
abc lm (no,pq,rs) {tu,vw,xy} zs "as,as,fr" 'ab,cd,ef'
I tried this str.replaceAll("\\(.*?\\)|(,)", " "); say my string... (3 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)
Discussion started by: mlavanya
6 Replies
LEARN ABOUT REDHAT
pdl::gslsf::expint
EXPINT(3) User Contributed Perl Documentation EXPINT(3)NAME
PDL::GSLSF::EXPINT - PDL interface to GSL Special Functions
DESCRIPTION
This is an interface to the Special Function package present in the GNU Scientific Library.
SYNOPSIS FunctionsFUNCTIONS
gsl_sf_expint_E1
Signature: (double x(); double [o]y(); double [o]e())
E_1(x) := Re[ Integrate[ Exp[-xt]/t, {t,1,Infinity}] ]
gsl_sf_expint_E2
Signature: (double x(); double [o]y(); double [o]e())
E_2(x) := Re[ Integrate[ Exp[-xt]/t^2, {t,1,Infity}] ]
gsl_sf_expint_Ei
Signature: (double x(); double [o]y(); double [o]e())
Ei(x) := PV Integrate[ Exp[-t]/t, {t,-x,Infinity}]
gsl_sf_Shi
Signature: (double x(); double [o]y(); double [o]e())
Shi(x) := Integrate[ Sinh[t]/t, {t,0,x}]
gsl_sf_Chi
Signature: (double x(); double [o]y(); double [o]e())
Chi(x) := Re[ M_EULER + log(x) + Integrate[(Cosh[t]-1)/t, {t,0,x}] ]
gsl_sf_expint_3
Signature: (double x(); double [o]y(); double [o]e())
Ei_3(x) := Integral[ Exp[-t^3], {t,0,x}]
gsl_sf_Si
Signature: (double x(); double [o]y(); double [o]e())
Si(x) := Integrate[ Sin[t]/t, {t,0,x}]
gsl_sf_Ci
Signature: (double x(); double [o]y(); double [o]e())
Ci(x) := -Integrate[ Cos[t]/t, {t,x,Infinity}]
gsl_sf_atanint
Signature: (double x(); double [o]y(); double [o]e())
AtanInt(x) := Integral[ Arctan[t]/t, {t,0,x}]
AUTHOR
This file copyright (C) 1999 Christian Pellegrin <chri@infis.univ.trieste.it> All rights reserved. There is no warranty. You are allowed to
redistribute this software / documentation under certain conditions. For details, see the file COPYING in the PDL distribution. If this
file is separated from the PDL distribution, the copyright notice should be included in the file.
The GSL SF modules were written by G. Jungman.
perl v5.8.0 2003-01-29 EXPINT(3)