11-23-2017
Your sample with a field separator at the end of the line and no data following doesn't seem right, does it?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have various column names within double quotes, separated by commas.
Example:
"column one", "column number two", "this is column number three", anothercolumn, yetanothercolumn
I need to eliminate the double quotes and replace the blanks within the double quotes by underscores, giving:
... (5 Replies)
Discussion started by: jgrogan
5 Replies
2. 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
3. UNIX for Dummies Questions & Answers
Hi,
I am getting the data from text file and it contains comma and double quootes.
Eg: text file like this:
Travelling up Cattai Ridge Rd, going through the "S" bends at the top.
Felt a "pull" and pain in groin area, on right side after lifting at work.
Repeat "twisting" while working manual... (4 Replies)
Discussion started by: rajesh4851
4 Replies
4. 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
5. Shell Programming and Scripting
In bash or perl, I would like to know how to substitute a null character (0x00) for every white space without changing the white spaces inside the block of double quotes and the white space immediately following a backslash.
Suppose that sample.txt consists of the following line.
"b 1" c\ 2
... (2 Replies)
Discussion started by: LessNux
2 Replies
6. Shell Programming and Scripting
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
Discussion started by: shell_boy23
5 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. 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
Hi I have a .csv file and when opened in notepad looks like this
gggg,nnnn,"last,first","llll""",nnn
So, Here I would like the ouput as below
gggg,nnnn,"last,first","llll",nnn
i.e replace all two double quotes into one. How could I do that?
This file is being processed by another... (5 Replies)
Discussion started by: dnat
5 Replies
LEARN ABOUT DEBIAN
snsplit
snsplit,v0.3.8(8) System Manager's Manual snsplit,v0.3.8(8)
NAME
snsplit - split an article stream into individual articles
SYNOPSIS
snsplit [-r] [field... -] prog...
DESCRIPTION
snsplit reads an article stream from descriptor 0 and splits it into separate articles, invoking prog... on each, with the article ava-
iable on descriptor 0. This is useful as a quick-and-dirty way of filtering an article stream.
The incoming article stream is expected to be in wire format, with lines ending in CRLF, leading dots doubled, and delimited by a dot on a
line by itself.
The article presented to prog... will have lines that end in a bare newline, will have all header lines unfolded, leading dots will be
unstuffed, and the article will be terminated by end-of-file.
ARGUMENTS
prog...
is the program (with arguments) to run on each article. If prog... exits with any kind of failure, snsplit aborts.
field...-
are optional header field names. If these are specified, the value of the first header field of that name will be exported into the
environment. This field... list must be terminated by the hyphen. See also ENVIRONMENT below.
OPTIONS
-r Expect input articles in rnews batch format instead.
ENVIRONMENT
snsplit sets some environment variables. If the environment already contains these variables, they will be overwritten.
SEQUENCE
If already set to a positive value, it is incremented for the first article. If it isn't set, is set to one for the first article.
Thereafter it is incremented for each subsequent article. The value is always a 6-digit number with leading zeroes, and it can roll
over.
BYTES contains the size of the current article.
HEAD_LINES
The number of lines in the head of the article, excluding the blank separator line.
BODY_LINES
The number of lines in the body of the article, excluding the blank separator line.
FLD_FIELD
If any fields are specified on the command line, where field is the name of an article header field, then FLD_FIELD will be set to
the value of field, where FIELD is the same as field but with lower case characters changed to upper case, and all hyphens changed
to underscores. Confusing? If field is message-id, then FLD_MESSAGE_ID will be set to the value of the first Message-ID field in
the current article, if there is one.
EXIT CODES
snsplit exits 0 on success, 1 on usage error, 2 on system error, and 3 on article format error. If prog... exits with other than 0,
snsplit will also exit that value.
N.B. Harold Tay snsplit,v0.3.8(8)