12-15-2011
Well we've reached post #10 and we know that the file is over 7Gb and you want to edit it. We know nothing about the file itself, but other posters have suggested unix text file editing techniques. Is it a unix text format file with manageable record length?
Have you edited similar (but smaller) files in the same format? If so, what did you do?
Please post what Operating System and version you have.
Please describe the process or program which wrote this file (mentioning programming language or database engine if relevant).
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How to edit large file using vi where you can't increase /usr/var/tmp anymore? (3 Replies)
Discussion started by: nazri
3 Replies
2. Shell Programming and Scripting
I am trying to edit a file that has 33k+ records. In this file I need to edit each record that has a 'Y' in the 107th position and change the 10 fields before the 'Y' to blanks. Not all records have a 'Y' in the 107th field.
ex:
... (8 Replies)
Discussion started by: jxh461
8 Replies
3. UNIX for Dummies Questions & Answers
Hello Everyone
I am new to this forum.
I am having a requirement to edit the file(the file is having some sql code).
And this file is in my colleagues login. This is readonly
Now I would like to edit this file.
In which way can I do this? (1 Reply)
Discussion started by: pradkumar
1 Replies
4. Shell Programming and Scripting
hi All,
Plz let me know how to edit a file with 2000000 records.
each record contains with 40 field seperated by |.
i want modify 455487 record, but i am uable to edit this large file using vi editor in unix.
plz let me know how to modify this file.
Thanks in advance.
-Bali Reddy (3 Replies)
Discussion started by: balireddy_77
3 Replies
5. Shell Programming and Scripting
:confused:Folks,
I have a file with 50 million records having 2 columns. I have to do the below:
1. Generate some random numbers of a fixed length.
2. Replace the second column of randomly chosen rows with the random numbers.
I tried using a little bit of perl to generate random numbers... (6 Replies)
Discussion started by: mvijayv
6 Replies
6. Shell Programming and Scripting
I have a file oratab with entry like this
SCADAG:/esitst1/oracle/product/9.2.0.8:Y
I am trying to discover a way to change the 9.2.0.8 part of this to something like 10.2.0.4 as part of an upgrade script.
I have tried
cat /etc/oratab >>/tmp/oratab... (1 Reply)
Discussion started by: sewood
1 Replies
7. Shell Programming and Scripting
Hi,
I need to make a script to edit a file. File is a large file in below format
Version: 2008120101
;$INCLUDE ./abc/xyz/Delhi
;$INCLUDE ./abc/xyz/London
$INCLUDE ./abc/xyz/New York
First line in the file is version number which is in year,month,date and serial number format. Each... (5 Replies)
Discussion started by: makkar4u
5 Replies
8. Shell Programming and Scripting
I have a requirement, which is as follows
*. Folder contains list of xmls. Script has to create new xml files by copying the existing one and renaming it by appending "_pre.xml" at the end.
*. Each file has multiple <Name>fileName</Name> entry. The script has to find the first occurance of... (1 Reply)
Discussion started by: sudesh.ach
1 Replies
9. Shell Programming and Scripting
I have a file containing dates like below
2010 1 02
2010 2 01
2010 3 05
i want the dates to be like below
20100102
20100201
20100305
i tired using
awk '{printf "%s%02s%02s",$1,$2,$3}'
But it does not work,it puts all the dates in one line,i want them in seperate lines like the... (6 Replies)
Discussion started by: tomjones
6 Replies
10. UNIX for Advanced & Expert Users
Hi All,
I have file with 200K Records and each line with 400 character. I need to edit the some part of the file.
For example, i need to edit character from 115 to 125, 135to 145 and 344 to 361
Can you please anyone help me to do this?
Regards, (1 Reply)
Discussion started by: balasubramani04
1 Replies
LEARN ABOUT FREEBSD
edit-pr
edit-pr(1) GNATS User Utilities edit-pr(1)
NAME
edit-pr - edit a problem report in the GNATS database
SYNOPSIS
edit-pr
[ -h | --help ] [ -V | --version ]
[ -d databasename | --database=databasename ]
[ -H host | --host=host ] [ -P port | --port=port ]
[ -v user | --user=user ] [ -w password | --passwd=password ]
PR
DESCRIPTION
edit-pr is used to make changes to existing PRs in a GNATS database.
edit-pr first examines the PR and locks it if it is not already locked. This is to prevent a PR from being edited by two users simultane-
ously. If the PR is already in the process of being edited, edit-pr displays the name of the person who owns the lock.
edit-pr then calls $EDITOR on PR. After the PR has been edited, it is resubmitted to the database, and the index is updated.
If you change a field that requires a reason for the change, edit-pr prompts you to supply a reason for the change. A message is then ap-
pended to the Audit-Trail field of PR with the changed values and the change reason.
Depending on how the database is configured, editing various fields in the PR may also cause mail to be sent concerning these changes. In
the default configuration, any fields that generate Audit-Trail entries will cause a copy of the new Audit-Trail message to be sent.
OPTIONS
-h, --help
Prints a brief usage message for edit-pr.
-V, --version
Prints the version number for edit-pr.
-d, --database
Specifies the database containing the PR to be edited; if no database is specified, the database named default is assumed. This
option overrides the database specified in the GNATSDB environment variable.
GNATS network options:
-H, --host
Hostname of the GNATS server.
-P, --port
The port that the GNATS server runs on.
-v, --username
Username used to log into the GNATS server.
-w, --passwd
Password used to log into the GNATS server.
ENVIRONMENT VARIABLES
The environment variable EDITOR specifies the editor to invoke on the PR. Default is vi(1).
The GNATSDB environment variable is used to determine which database to
use. For a local database, it contains the name of the database to access.
For network access via gnatsd, it contains a colon-separated list of strings that describe the remote database, in the form
server:port:databasename:username:password
Any of the fields may be omitted, but at least one colon must appear; otherwise, the value is assumed to be the name of a local database.
If GNATSDB is not set, it is assumed that the database is local and that its name is default.
FILES
/tmp/ep$$ Temporary file for PR being edited.
/tmp/ed_pr_ch$$
Holds Audit-Trail change message, if needed.
/tmp/u$$ Holds output of lock function.
SEE ALSO
Keeping Track: Managing Messages With GNATS (also installed as the GNU Info file gnats.info)
databases(5), dbconfig(5), delete-pr(8), edit-pr(1) file-pr(8), gen-index(8), gnats(7), gnatsd(8), mkcat(8), mkdb(8), pr-edit(8), query-
pr(1), queue-pr(8), send-pr(1).
COPYING
Copyright (c) 1993, 2003, Free Software Foundation, Inc.
Permission is granted to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are
preserved on all copies.
Permission is granted to copy and distribute modified versions of this manual under the conditions for verbatim copying, provided that the
entire resulting derived work is distributed under the terms of a permission notice identical to this one.
Permission is granted to copy and distribute translations of this manual into another language, under the above conditions for modified
versions, except that this permission notice may be included in translations approved by the Free Software Foundation instead of in the
original English.
GNATS
August 2003 edit-pr(1)