03-17-2005
thanks for the explanation. i give another reply
perl -pi -e '$_ = "" if ($. == 1);' filename
which one is fastest?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I have a flat text file which contains blank line between each text line. Is there any command to get rid of it?
Thanks for your help (11 Replies)
Discussion started by: xfang
11 Replies
2. Shell Programming and Scripting
Hi All,
I get a flat file with its last field data splitting onto a new line.I got this program from Vgersh which when run would cancatenate the split data back to the end of the previous records.But this program fails when it encounters a page break between the split data and the previous... (5 Replies)
Discussion started by: kumarsaravana_s
5 Replies
3. Shell Programming and Scripting
Hi,
Here is wat im looking for.. i have a flat file which looks like this..
00
*
*
*
*
..
..
*
*
text
text
text
COL1 COL2
----- -----
1 a (12 Replies)
Discussion started by: meghana
12 Replies
4. Shell Programming and Scripting
I have a flat file that contains records similar to the following two lines;
1984/11/08 7 700000 123456789 2
1984/11/08 1941/05/19 7 700000 123456789 2
The 123456789 2 represents an account number, this is how I identify the duplicate record.
The ### signs represent... (4 Replies)
Discussion started by: jolney
4 Replies
5. Shell Programming and Scripting
Hi,
I have more than 30,000 records in a flat file. I want to remove footer from the file by searching a string pattern for the footer.
Example.... let the flat file test.dat contains below records.
record1
record2
record3
..
..
..
record31000
Total records 31000
I want to remove the... (6 Replies)
Discussion started by: gani_85
6 Replies
6. UNIX for Dummies Questions & Answers
HI,
can any one help me please ..
i have flat file like
qwer123rt ass3242ccf jjk654
kjh838ppp nhdg453ok hdkk34
i want remove numeric characters in the flat file
i want output like this
qwerrt assccf jjk
kjhppp nhdgok hdkk
help me... (4 Replies)
Discussion started by: rafimd1985
4 Replies
7. Shell Programming and Scripting
I have to export data from table into flat file with | delimited. In the ksh file, I am adding below to do this activity.
$DBSTRING contains the sqlplus command and $SQL_STRING contains the SQL query. File is created properly with the data as per SQL command. I am getting white spaces in the... (1 Reply)
Discussion started by: mgpatil31
1 Replies
8. Shell Programming and Scripting
Hi,
Is there a way to find out the line number from where the data starts?
like if the data contains column header, irrespective of the text in the column header we should get the line number from which contains the column header.
I am sorry if I haven't explained the problem clearly.
... (8 Replies)
Discussion started by: kedar_laveti
8 Replies
9. UNIX for Advanced & Expert Users
Hi all,
I have a issues while loading a flat file to the DB. It is taking much time.
When analyzed i found out that there are duplicates entry in the flat file.
There are 2 type of Duplicate entry.
1) is entire row is duplicate. ( i can use sort | uniq) to remove the duplicated entry.
2) the... (4 Replies)
Discussion started by: samjoshuab
4 Replies
10. Shell Programming and Scripting
We have a flat file with below data :
^@^@^@^@00000305^@^@^@^@^@^@430^@430^@^@^@^@^@^@^@^@^@09079989530As we can see ^@ is Null character in this file
I want to remove only the first few null characters before string 00000305
How can we do that, any idea. I want a new file without first few... (5 Replies)
Discussion started by: simpltyansh
5 Replies
LEARN ABOUT CENTOS
pg_test_fsync
PG_TEST_FSYNC(1) PostgreSQL 9.2.7 Documentation PG_TEST_FSYNC(1)
NAME
pg_test_fsync - determine fastest wal_sync_method for PostgreSQL
SYNOPSIS
pg_test_fsync [option...]
DESCRIPTION
pg_test_fsync is intended to give you a reasonable idea of what the fastest wal_sync_method is on your specific system, as well as
supplying diagnostic information in the event of an identified I/O problem. However, differences shown by pg_test_fsync might not make any
difference in real database throughput, especially since many database servers are not speed-limited by their transaction logs.
OPTIONS
pg_test_fsync accepts the following command-line options:
-f, --filename
Specifies the file name to write test data in. This file should be in the same file system that the pg_xlog directory is or will be
placed in. (pg_xlog contains the WAL files.) The default is pg_test_fsync.out in the current directory.
-s, --secs-per-test
Specifies the number of seconds for each test. The more time per test, the greater the test's accuracy, but the longer it takes to run.
The default is 2 seconds, which allows the program to complete in about 30 seconds.
-V, --version
Print the pg_test_fsync version and exit.
-?, --help
Show help about pg_test_fsync command line arguments, and exit.
AUTHOR
Bruce Momjian <bruce@momjian.us>
SEE ALSO
postgres(1)
PostgreSQL 9.2.7 2014-02-17 PG_TEST_FSYNC(1)