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 DEBIAN
excel::template::element::image
Excel::Template::Element::Image(3pm) User Contributed Perl Documentation Excel::Template::Element::Image(3pm)NAME
Excel::Template::Element::Image - Excel::Template::Element::Image
PURPOSE
To insert an image into the worksheet
NODE NAME
IMAGE
INHERITANCE
ELEMENT
EFFECTS
This will consume one column in the current row.
DEPENDENCIES
None
USAGE
<image path="/Some/Full/Path" />
<image path="/Some/Full/Path" offset="2,5" />
<image path="/Some/Full/Path" scale="2,0.4" />
<image path="/Some/Full/Path" offset="4,0" scale="0,2" />
Please see "" in Spreadsheet::WriteExcel for more information about the offset and scaling options as well as any other restrictions that
might be in place. This node does NOT perform any sort of validation upon your parameters. You are assumed to know what you are doing.
Note that the offset and scaling values are "X,Y". You must provide both values, even if the Y value is 0. If you provide a 0 value for
either scaling option, "" in Spreadsheet::WriteExcel will default that to 1.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
Nothing
perl v5.14.2 2010-06-17 Excel::Template::Element::Image(3pm)