01-11-2011
Suggest you write an sql program to output the fields to a file (not a pipe) in a more useable format. Maybe the whole process can be done in sql? Really depends what you are going to do with the data.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All
At the moment the following code works but ideally i do not want to have to change the original $1
tr "\r" "\n" < "$1" > "$1.fix"
printf "\n" >> "$1.fix"
mv "$1.fix" "$1"
FILE=$1
coffee_out="splitmovie"
coffee_fill="-splitAt"
coffee_end="-self-contained -o output.mov $2"... (1 Reply)
Discussion started by: babajuma
1 Replies
2. Shell Programming and Scripting
Hey there - a bit of background on what I'm trying to accomplish, first off. I am trying to load the data from a pipe delimited file into a database. The loading tool that I use cannot handle embedded newline characters within a field, so I need to scrub them out.
Solutions that I have tried... (7 Replies)
Discussion started by: bbetteridge
7 Replies
3. Shell Programming and Scripting
I have a requirement where i have to read from a .sh file a text lying bet characters like 'SELECT' & ';'...Please help me out in this. I am new to shell scripting. (2 Replies)
Discussion started by: goutam_igate
2 Replies
4. UNIX for Dummies Questions & Answers
Hi ,
I am working on Linux, with ksh93 installed.
The following statement
echo \\n
just prints
\n on this shell.
However on pdksh
echo \\n gives a blank new line as a output.
What is the correct way of printing a new line character on the ksh93? (4 Replies)
Discussion started by: neeto
4 Replies
5. Programming
Hi,
My program uses gl_get_line from libtecla to get user input from terminal. It works fine as long as I enter English at the terminal prompt. However, if I enter other languages, such as Chinese characters, either by typing in or cut-and-paste, the input characters get cleared from terminal... (5 Replies)
Discussion started by: tdw
5 Replies
6. Shell Programming and Scripting
Hi,
I have file in which fields are pipe (|) separated and the record separator is new line (\n). But sometime I am getting a field value which is spread across multiple line. Basically I am getting a file from another system in the below format and needs to process the file and load data into a... (3 Replies)
Discussion started by: satyaatcgi
3 Replies
7. Windows & DOS: Issues & Discussions
I have a txt like this:
638.301 (0.00973985) @ 50+55
the thing I want to do is read the last seven characters from the end of the first line.
how do I do this ?
Thanks in advance and sorry for being DOS only here. (2 Replies)
Discussion started by: pasc
2 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have the file which has the data :
accctaaccctaaccctaaccctaaccctaaccctaaccctaaccctaac
cctaacccaaccctaaccctaaccctaaccctaaccctaaccctaacccc
taaccctaaccctaaccctaaccctaacctaaccctaaccctaaccctaa
ccctaaccctaaccctaaccctaaccctaacccctaaccctaaccctaaa... (24 Replies)
Discussion started by: rajivn786
24 Replies
9. Programming
Hi,
I want to read extended ASCII characters from keyboard using c language on unix/linux. How to read extended characters from keyboard or by copy-paste in terminal irrespective of locale set in the system. I want to read the input characters from keyboard, store it in an array or some local... (3 Replies)
Discussion started by: sanzee007
3 Replies
10. Programming
Hello,
I have snippet code from Lippman's <<C++ primer>>.
The program is to convert regular decimal (0 ~ 15) numbers to basic hexdecimals. The instruction tells the program will execute by hitting newline at the end. When I tried to run the compiled program, hitting ENTER did not work as... (3 Replies)
Discussion started by: yifangt
3 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::view
SQL::Translator::Schema::View(3pm) User Contributed Perl Documentation SQL::Translator::Schema::View(3pm)
NAME
SQL::Translator::Schema::View - SQL::Translator view object
SYNOPSIS
use SQL::Translator::Schema::View;
my $view = SQL::Translator::Schema::View->new(
name => 'foo', # name, required
sql => 'select id, name from foo', # SQL for view
fields => 'id, name', # field names in view
);
DESCRIPTION
"SQL::Translator::Schema::View" is the view object.
METHODS
new
Object constructor.
my $view = SQL::Translator::Schema::View->new;
fields
Gets and set the fields the constraint is on. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
field names and keep them in order by the first occurrence of a field name.
$view->fields('id');
$view->fields('id', 'name');
$view->fields( 'id, name' );
$view->fields( [ 'id', 'name' ] );
$view->fields( qw[ id name ] );
my @fields = $view->fields;
tables
Gets and set the tables the SELECT mentions. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
table names and keep them in order by the first occurrence of a field name.
$view->tables('foo');
$view->tables('foo', 'bar');
$view->tables( 'foo, bar' );
$view->tables( [ 'foo', 'bar' ] );
$view->tables( qw[ foo bar ] );
my @tables = $view->tables;
options
Gets and sets a list of options on the view.
$view->options('ALGORITHM=UNDEFINED');
my @options = $view->options;
is_valid
Determine whether the view is valid or not.
my $ok = $view->is_valid;
name
Get or set the view's name.
my $name = $view->name('foo');
order
Get or set the view's order.
my $order = $view->order(3);
sql
Get or set the view's SQL.
my $sql = $view->sql('select * from foo');
schema
Get or set the view's schema object.
$view->schema( $schema );
my $schema = $view->schema;
equals
Determines if this view is the same as another
my $isIdentical = $view1->equals( $view2 );
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
perl v5.14.2 2012-05-01 SQL::Translator::Schema::View(3pm)