Current File:
XXX
Rows found with null for one or more non-nullable columns in the source table
OUTPUT FILE
Rows found with null for one or more non-nullable columns in the source table
Please help me
Moderator's Comments:
Please use next time code tags for your code and data
hi! I am a newbee. I would really appreciate if you can answer the following question:
I have a huge data file, 214MB with several coloumns. I need to delete the very last line of the file. Everything I know takes a lot of time to do it ( because I have to open the file in an editor or run a... (3 Replies)
Hi,
I am in a situation wherein am getting file file certailn values
suppose
1u56979hhghhklklkkkjkjkjk 0 0 0
The file will have values like above only.
I need to add another field of NULL value(of length 9) at the end of first column i.e.
It should like this after editing:... (4 Replies)
I have created a file with vi -x (file name) this is encrypted file when i again open this file it ask me to enter a password before editing it.Can i remove this password but i don't want to delete a file how to do this.
Thanks (0 Replies)
Hi all,
I have a file with following contents
# rad124
# radkus
# raddebug
# radtrace
I could like to remove the # and space present before the key word "rad".
Any ways to do this using "subsitution method(:%s/old/new/g)" will be hepful. (1 Reply)
Hi,
I am having a file which is fix length and comma seperated. And I want to replace values for one column.
I am reading file line by line in variable $LINE and then replacing the string.
Problem is after changing value and writing new file temp5.txt, formating of original file is getting... (8 Replies)
I have a text file that has data like:
Data "12345#22"
Fred
ID 12345
Age 45
Wilma
Dino
Data "123#22"
Tarzan
ID 123
Age 33
Jane
I need to figure out a way of adding 1,000,000 to the specific lines (always same format) in the file, so it becomes:
Data "1012345#22"
Fred
ID... (16 Replies)
I have a file which has 10 million records in it. When am trying to edit the file with vi, the following error occurs:
~
~
~
~
~
~
~
~
"file1" Value too large for defined data type
Is there any way that I can edit this file without using vi? Any help would be really appreciated.... (8 Replies)
Dear Guru's
I'm using Putty and want to edit a file. I know we generally use vi editor to do it. As I'm not good in using vi editor, I want to convert the vi into something like text pad. Is there any option in Putty to do the same ? Thanks for your response.
Srini (6 Replies)
Discussion started by: thummi9090
6 Replies
LEARN ABOUT CENTOS
file::inplace
File::Inplace(3) User Contributed Perl Documentation File::Inplace(3)NAME
File::Inplace - Perl module for in-place editing of files
SYNOPSIS
use File::Inplace;
my $editor = new File::Inplace(file => "file.txt");
while (my ($line) = $editor->next_line) {
$editor->replace_line(reverse $line);
}
$editor->commit;
DESCRIPTION
File::Inplace is a perl module intended to ease the common task of editing a file in-place. Inspired by variations of perl's -i option,
this module is intended for somewhat more structured and reusable editing than command line perl typically allows. File::Inplace endeavors
to guarantee file integrity; that is, either all of the changes made will be saved to the file, or none will. It also offers functionality
such as backup creation, automatic field splitting per-line, automatic chomping/unchomping, and aborting edits partially through without
affecting the original file.
CONSTRUCTOR
File::Inplace offers one constructor that accepts a number of parameters, one of which is required.
File::Inplace->new(file => "filename", ...)
file
The one required parameter. This is the name of the file to edit.
suffix
The suffix for backup files. If not specified, no backups are made.
chomp
If set to zero, then automatic chomping will not be performed. Newlines (actually, the contents of $/) will remain in strings
returned from "next_line". Additionally, the contents of $/ will not be appended when replacing lines.
regex
If specified, then each line will be split by this parameter when using "next_line_split" method. If unspecified, then this
defaults to s+.
separator
The default character used to join each line when replace_line is invoked with a list instead of a single value. Defaults to a
single space.
INSTANCE METHODS
$editor->next_line ()
In scalar context, it returns the next line of the input file, or undef if there is no line. In an array context, it returns a single
value of the line, or an empty list if there is no line.
$editor->replace_line (value)
Replaces the current line in the output file with the specified value. If passed a list, then each valie is joined by the "separator"
specified at construction time.
$editor->next_line_split ()
Line "next_line", except splits based on the "regex" specified in the constructor.
$editor->has_lines ()
Returns true if the file contains any further lines.
$editor->all_lines ()
Returns an array of all lines in the file being edited.
$editor->replace_all_lines (@lines)
Replaces all remaining lines in the file with the specified @lines.
$editor->commit ()
Completes the edit operation and saves the changes to the edited file.
$editor->rollback ()
Aborts the edit process.
$editor->commit_to_backup ()
Saves edits to the backup file instead of the original file.
AUTHOR
Chip Turner, <chipt@cpan.org>
COPYRIGHT AND LICENSE
Copyright (C) 2005 by Chip Turner
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.6.0 or,
at your option, any later version of Perl 5 you may have available.
POD ERRORS
Hey! The above document had some coding errors, which are explained below:
Around line 283:
You forgot a '=back' before '=head1'
Around line 285:
'=item' outside of any '=over'
perl v5.16.3 2005-01-29 File::Inplace(3)