05-16-2018
Hi Rudic,
Thanks a lot for your email.
I have tested with sample data, it's working as expected. I will test multiple flat files and let you know in case of any other issues.
Could you please explain me how above awk command replacing double double quotes where ever the double quotes inside the string value for each columns.
Thanks again.
Regards,
Srini
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: GKnight
3 Replies
2. Shell Programming and Scripting
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)
Discussion started by: joanneho
2 Replies
3. Shell Programming and Scripting
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)
Discussion started by: prabhutkl
3 Replies
4. Shell Programming and Scripting
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)
Discussion started by: vee789
11 Replies
5. Shell Programming and Scripting
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)
Discussion started by: Bhuvaneswari
2 Replies
6. Shell Programming and Scripting
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)
Discussion started by: sam05121988
3 Replies
7. Shell Programming and Scripting
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)
Discussion started by: pchang
32 Replies
8. Shell Programming and Scripting
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)
Discussion started by: thanush9sep
6 Replies
9. Programming
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)
Discussion started by: preethy
3 Replies
10. 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
LEARN ABOUT REDHAT
pdl::gslsf::gamma
GAMMA(3) User Contributed Perl Documentation GAMMA(3)
NAME
PDL::GSLSF::GAMMA - PDL interface to GSL Special Functions
DESCRIPTION
This is an interface to the Special Function package present in the GNU Scientific Library.
SYNOPSIS
Functions
FUNCTIONS
gsl_sf_lngamma
Signature: (double x(); double [o]y(); double [o]s(); double [o]e())
Log[Gamma(x)], x not a negative integer Uses real Lanczos method. Determines the sign of Gamma[x] as well as Log[|Gamma[x]|] for x < 0. So
Gamma[x] = sgn * Exp[result_lg].
gsl_sf_gamma
Signature: (double x(); double [o]y(); double [o]e())
Gamma(x), x not a negative integer
gsl_sf_gammastar
Signature: (double x(); double [o]y(); double [o]e())
Regulated Gamma Function, x > 0 Gamma^*(x) = Gamma(x)/(Sqrt[2Pi] x^(x-1/2) exp(-x)) = (1 + 1/(12x) + ...), x->Inf
gsl_sf_gammainv
Signature: (double x(); double [o]y(); double [o]e())
1/Gamma(x)
gsl_sf_lngamma_complex
Signature: (double zr(); double zi(); double [o]x(); double [o]y(); double [o]xe(); double [o]ye())
Log[Gamma(z)] for z complex, z not a negative integer. Calculates: lnr = log|Gamma(z)|, arg = arg(Gamma(z)) in (-Pi, Pi]
gsl_sf_taylorcoeff
Signature: (double x(); double [o]y(); double [o]e(); int n)
x^n / n!
gsl_sf_fact
Signature: (x(); double [o]y(); double [o]e())
n!
gsl_sf_doublefact
Signature: (x(); double [o]y(); double [o]e())
n!! = n(n-2)(n-4)
gsl_sf_lnfact
Signature: (x(); double [o]y(); double [o]e())
ln n!
gsl_sf_lndoublefact
Signature: (x(); double [o]y(); double [o]e())
ln n!!
gsl_sf_lnchoose
Signature: (n(); m(); double [o]y(); double [o]e())
log(n choose m)
gsl_sf_choose
Signature: (n(); m(); double [o]y(); double [o]e())
n choose m
gsl_sf_lnpoch
Signature: (double x(); double [o]y(); double [o]s(); double [o]e(); double a)
Logarithm of Pochammer (Apell) symbol, with sign information. result = log( |(a)_x| ), sgn = sgn( (a)_x ) where (a)_x := Gamma[a +
x]/Gamma[a]
gsl_sf_poch
Signature: (double x(); double [o]y(); double [o]e(); double a)
Pochammer (Apell) symbol (a)_x := Gamma[a + x]/Gamma[x]
gsl_sf_pochrel
Signature: (double x(); double [o]y(); double [o]e(); double a)
Relative Pochammer (Apell) symbol ((a,x) - 1)/x where (a,x) = (a)_x := Gamma[a + x]/Gamma[a]
gsl_sf_gamma_inc_Q
Signature: (double x(); double [o]y(); double [o]e(); double a)
Normalized Incomplete Gamma Function Q(a,x) = 1/Gamma(a) Integral[ t^(a-1) e^(-t), {t,x,Infinity} ]
gsl_sf_gamma_inc_P
Signature: (double x(); double [o]y(); double [o]e(); double a)
Complementary Normalized Incomplete Gamma Function P(a,x) = 1/Gamma(a) Integral[ t^(a-1) e^(-t), {t,0,x} ]
gsl_sf_lnbeta
Signature: (double a(); double b(); double [o]y(); double [o]e())
Logarithm of Beta Function Log[B(a,b)]
gsl_sf_beta
Signature: (double a(); double b();double [o]y(); double [o]e())
Beta Function B(a,b)
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 GAMMA(3)