logic is every row should be 5 comma's if not just concatenate to next line..
NEVER make assumptions without quoting them!
This line contains 6 commas, one inside quotes!
As we do NOT have a decent subset of your data how can we possibly know
if there are more or less commas per line?
Context:
I need to remove unwanted newlines from a data file listing books and associated data. Here is a sample listing ( line numbers included ):
1 360762| Skip-beat! 14 /| 9781421517544| nb | 2008.| Nakamura, Yoshiki.| NAKAMUR | Kyoko Mogami followed
2 her true love Sho to Tokyo to... (6 Replies)
Hi Guys,
I have data in a file as follows:
a 1 2 3
b 4 5 6
a 6 7 8
a 4 7 9
b 6 8 5
c 0 8 7
So the number of rows which have data is variable (2 for the first group, one for the second group and three for the third group), but the delimiters between the... (10 Replies)
Hello, there. I have a file that's a horrible, horrible mess. (Basically, it's an export from a firewall config.) The people who generated the file didn't think that putting a newline in the middle of a hostname would ever be a problem. It is.
Here's an example of the stuff in the file:
... (2 Replies)
Hi all,
i am getting count from oracle 11g by spooling it to a file.
Now there are some newline characters and blank spaces i need to remove these.
pl provide me a awk/sed solution.
the spooled file is attached.
i tried this.. but not getting req o/p (6 Replies)
Hi All,
I have a file which looks like this:
abc 3456
computer 3214
printer 0.9823
computer 3214
Can anyone please let me know how I can format my text like this?
abc 3456 computer 3214 printer 0.9823 computer 3214
I know how to space to newlines using tr but don't know how to do... (4 Replies)
Hello! This is my first post here.
I have a file with text like:
A</title>
B
C</title>
D
I need to format it to:
AB
CD
I am trying to use sed: sed 's/<//title>\n/ /g' file > newfile
to delete </title> and the newline character, but the file is unchanged because there are... (3 Replies)
Good morning,
I need some help with getting rid of newlines with the output from a MYSQL query and putting the information into the right format that I need.
Here is the script as it is today:
#!/usr/bin/perl
my $uda = system("/opt/incontrol/mysql/bin/mysql -u root -ppassword... (2 Replies)
I want to list all html files present in a directory tree, the remove the newline and get one string with a space between files
find /home/chrisd/Desktop/seg/geohtml/ -name '*.html' | awk BEGIN{FS=\r} '{print}'
---------- Post updated at 06:47 PM ---------- Previous update was at 06:25 PM... (5 Replies)
I need to remove new lines and carriage returns from csv file.
Is there anything other than sed and gwak by which we could achieve this ? Any suggestions ? (3 Replies)
Hi Friends,
I have a data file with new lines.
How to remove the newlines and should be showed in one line.
I tried using the command
tr -d '\n' filename
sed 's/\n//g' file name
Ex: 1 abc hyd is actual record
but in our scenario showing it as
1 abc
hydthis record should be like... (5 Replies)
Discussion started by: victory
5 Replies
LEARN ABOUT OSX
page_util_quote
page_util_quote(n) Parser generator tools page_util_quote(n)
__________________________________________________________________________________________________________________________________________________NAME
page_util_quote - page character quoting utilities
SYNOPSIS
package require page::util::quote ?0.1?
package require snit
::page::util::quote::unquote char
::page::util::quote::quote'tcl char
::page::util::quote::quote'tclstr char
::page::util::quote::quote'tclcom char
_________________________________________________________________DESCRIPTION
This package provides a few utility commands to convert characters into various forms.
API
::page::util::quote::unquote char
A character, as stored in an abstract syntax tree by a PEG processor (See the packages grammar::peg::interpreter, grammar::me, and
their relations), i.e. in some quoted form, is converted into the equivalent Tcl character. The character is returned as the result
of the command.
::page::util::quote::quote'tcl char
This command takes a Tcl character (internal representation) and converts it into a string which is accepted by the Tcl parser, will
regenerate the character in question and is 7bit ASCII. The string is returned as the result of this command.
::page::util::quote::quote'tclstr char
This command takes a Tcl character (internal representation) and converts it into a string which is accepted by the Tcl parser and
will generate a human readable representation of the character in question. The string is returned as the result of this command.
The string does not use any unprintable characters. It may use backslash-quoting. High UTF characters are quoted to avoid problems
with the still prevalent ascii terminals. It is assumed that the string will be used in a double-quoted environment.
::page::util::quote::quote'tclcom char
This command takes a Tcl character (internal representation) and converts it into a string which is accepted by the Tcl parser when
used within a Tcl comment. The string is returned as the result of this command.
BUGS, IDEAS, FEEDBACK
This document, will undoubtedly contain bugs and other problems. Please report such in the category page of the Tcllib SF Trackers
[http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may have.
KEYWORDS
page, parser generator, quoting, text processing
CATEGORY
Page Parser Generator
COPYRIGHT
Copyright (c) 2007 Andreas Kupries <andreas_kupries@users.sourceforge.net>
page 1.0 page_util_quote(n)