Figured out what was causing the problem. The CSV file has some hidden characters at the end. I was able to strip them off using grep and now it works.
---------- Post updated at 02:14 AM ---------- Previous update was at 02:07 AM ----------
Didn't re-fresh my screen soon enough, you are correct elixir, it probably is the line terminators. I used the grep command;
Code:
grep -o '..........:.....:.....' infile >outfile
This strips off any extra characters but the tr command looks more straight forward.
Thanks,
Last edited by Franklin52; 11-23-2012 at 03:16 AM..
Reason: Please use code tags for data and code samples
Hi all,
Till now i was able to do apt-get update. but today i started to the following error:
# apt-get update
E: Could not open lock file /var/lib/apt/lists/lock - open (2 No such file or directory)
E: Unable to lock the list directory
#
Could any one let me know how to solve it.
... (1 Reply)
Dear All,
I have writen a Pro*c program that does a data base select,insert,update statements and I have scheduled the program to run from crontab,
It is runing fine for the select insert and commit statement till it reaches the update statement , it throws the following error:
SQL On IPB... (2 Replies)
Hi,
I have a oracle source with a field my_date =06/02/2009
I am trying to update the table to SYSDATE with a myscript.sql where I have
UPDATE table set my_date=to_DATE(SYSDATE,'MM/DD/YYYY');
Now I try to run it with myupdate.SH script where I have
sqlplus nolog @myscript.sql
... (4 Replies)
Hello
I reinstalled my OS today and after going through the registration the updatemanager pops up, as expected. The problem is all i get is an error message box that's completely blank.
The icon in the sytem tray is a blue question mark and when hovering over it, it says i'm not... (4 Replies)
Hi guys,
im having real difficulty getting my head around perl and rrdtool and was hoping someone could help
I want to run a perl script from cron which retrieves the data every 5 mins, creates .rrd's if not already created, and updates the DS from the reultsHash or $key, then creates the... (2 Replies)
Hello,
I have registered an SLES11SP1 server with my spacewalk server however when I perform a 'yum repolist', I do not see my spacewalk server as one of the available repositories. So when I perform yum update (any-package), it does not find an update available. HOwever within the Spacewalk GUI... (3 Replies)
Hello all,
Not sure if this question has been answered already.
I have some xml Element variable as below:
child19 = core_elem_dcache.find('stat')
child20 = core_elem_dcache.find('stat')
child21 = core_elem_dcache.find('stat')
child22 = core_elem_dcache.find('stat'Next I... (2 Replies)
Hello all,
I would like to unzip some files with a for-loop.
Is there anyone who could tell me how I should do this - in a correct way?
for file in $(ls); do echo gzip -d < $file | tar xf -; done
The problem is the pipe - I believe. But how could I do it? I need it for the command... (4 Replies)
I have this code that gives this error on Linux and will be grateful if you can help
import rrdtool
try:
ret_asd = rrdtool.update(myfile.rrd,'N:%s:%s' %(metric1, metric2));
except rrdtool.error, e:
print e
When i run the above i get the below error
except... (1 Reply)
Im trying to update an informix database table for each occurance of a head_barcode in a file called mw within a for loop
please see below - cant get the syntax correct. any help please?
for a in `cat /tmp/mw`
do
sql image - << STOP > /dev/null 2>&1
update doc_table set status =... (4 Replies)
Discussion started by: worky
4 Replies
LEARN ABOUT NETBSD
zfgrep
ZGREP(1) BSD General Commands Manual ZGREP(1)NAME
zgrep, zegrep, zfgrep -- print lines matching a pattern in gzip-compressed files
SYNOPSIS
zgrep [grep-flags] [--] pattern [files ...]
zegrep [grep-flags] [--] pattern [file ...]
zfgrep [grep-flags] [--] pattern [file ...]
DESCRIPTION
zgrep runs grep(1) on files or stdin, if no files argument is given, after decompressing them with zcat(1).
The grep-flags and pattern arguments are passed on to grep(1). If an -e flag is found in the grep-flags, zgrep will not look for a pattern
argument.
zegrep calls egrep(1), while zfgrep calls fgrep(1).
EXIT STATUS
In case of missing arguments or missing pattern, 1 will be returned, otherwise 0.
SEE ALSO egrep(1), fgrep(1), grep(1), gzip(1), zcat(1)AUTHORS
Thomas Klausner <wiz@NetBSD.org>
BSD December 28, 2003 BSD