Using "cat": This seems to only take a tab delimited file. My import files have varying delimiters e.g. "|" with the quotes. Is there any way to get cat to work with other delimiters such as pipe.
I have tried using cut: This just puts everything in one column
I also tried using cat: This doesnt seem to work with mysqlimport options as mysqlslurp mentions that they can be passed through
any help is much appreciated
Hi gurus, hoping someone can help with a sed line that can do the following...
I have a flat file with about 1000 records, but in order to import into openoffice spreadsheet, I need to create a delimited file. I'd like to do 2 things with the SED command:
1- add a pipe character "|" at the end... (4 Replies)
Hello,
So I sorted my file as I was supposed to:
sort -n -r -k 2 -k 1 file1 | uniq > file2
and when I wrote
> cat file2
in the command line, I got what I was expecting, but in the script itself
...
sort -n -r -k 2 -k 1 averages | uniq > temp
cat file2
It wrote a whole... (21 Replies)
I want to know how to delimit a colon in a file name while scp ing from one host to other host. I used forward slash(\) but that is not working. (1 Reply)
Hi all,
Great thanks to all for support till today..today i came here for 1 new issue :-( in our organization we are developing a job portal web application for a client. using Apache-tomcat we are hosting this application, now i need to delimit the applications directory comer under the webapps... (1 Reply)
Hi
Description of input file I have:
-------------------------
1) CSV with double quotes for string fields.
2) Some string fields have Comma as part of field value.
3) Have Duplicate lines
4) Have 200 columns/fields
5) File size is more than 10GB
Description of output file I need:... (4 Replies)
Hello,
I have a huge file of over 2,00,00,00 strings in UTF8 format. I have managed to write a script in Perl which sorts them neatly as per their Unicode ranges.
However I am now stuck with a script which will pipe out all strings between 3 and 20 letters/characters. I am not very good at... (2 Replies)
Hi All,
Greetings !!! :)
Am having issues with wc -l command.
My requirement is to delimit the output with comma seperated values and use that file as input in informatica.
wc -l *.ksh
Output :
16 espress_raise.ksh
173 espresso_monitoring.ksh
189 total
... (6 Replies)
Hi All ,
I am facing a small challenge i need unix command to remove space as well as replace "|" to "," in a csv file .
original file :
A | B | c | D
E | F | G | H
I | J | K | L
P | M | N | O
Expected o/p:
A,B,c,D
E,F,G,H
I,J,K,L
P,M,N,O (4 Replies)
Discussion started by: Sweety532
4 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::mysql
SQL::ReservedWords::MySQL(3pm) User Contributed Perl Documentation SQL::ReservedWords::MySQL(3pm)NAME
SQL::ReservedWords::MySQL - Reserved SQL words by MySQL
SYNOPSIS
if ( SQL::ReservedWords::MySQL->is_reserved( $word ) ) {
print "$word is a reserved MySQL word!";
}
DESCRIPTION
Determine if words are reserved by MySQL.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either MySQL 3.2, 4.0, 4.1, 5.0 or 5.1.
is_reserved_by_mysql3( $word )
Returns a boolean indicating if $word is reserved by MySQL 3.2.
is_reserved_by_mysql4( $word )
Returns a boolean indicating if $word is reserved by either MySQL 4.0 or 4.1.
is_reserved_by_mysql5( $word )
Returns a boolean indicating if $word is reserved by either MySQL 5.0 or 5.1.
reserved_by( $word )
Returns a list with MySQL versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_mysql3
is_reserved_by_mysql4
is_reserved_by_mysql5
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://dev.mysql.com/doc/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::MySQL(3pm)