Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

how to remove the first line from a flat file ?

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers how to remove the first line from a flat file ?
# 22  
Old 12-16-2008
Quote:
Originally Posted by reborg
That does not remove the line from the file, is streams the file to stdout with the first line removed. It would need to be redirected into a temporary file and moved back to replace the original file.

Also if I am correct, and I remember correctly the flatfile xli is talking about is pretty huge (millions of lines), and do it that way could be pretty slow.
I think it will edit the original file as he has mentioned "-i" option to sed. Yes I am agree with you this is suitable for a huge file which is in current picture.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove first NULL Character in Flat File

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

2. UNIX for Advanced & Expert Users

Remove duplicates in flat file

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

3. Shell Programming and Scripting

Get line number in flat file

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

4. Shell Programming and Scripting

Remove white spaces from flat file generated from Oracle table...

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

5. UNIX for Dummies Questions & Answers

How to remove numeric characters in the flat file

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

6. Shell Programming and Scripting

Remove the footer from a flat file by searching a pattern

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

7. Shell Programming and Scripting

Remove somewhat Duplicate records from a flat file

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

8. Shell Programming and Scripting

remove specific lines from flat file using perl

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

9. Shell Programming and Scripting

How to remove page breaks from a flat file???

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

10. Shell Programming and Scripting

how to get rid of blank line in a flat text file

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
Login or Register to Ask a Question

LEARN ABOUT MOJAVE

jrunscript

jrunscript(1)						      General Commands Manual						     jrunscript(1)

NAME

       jrunscript - command line script shell

SYNOPSIS

       jrunscript [ options ] [ arguments... ]

PARAMETERS

       options
	  Options, if used, should follow immediately after the command name.

       arguments
	  Arguments, if used, should follow immediately after options or command name.

DESCRIPTION

       jrunscript  is  a command line script shell. jrunscript supports both an interactive (read-eval-print) mode and a batch (-f option) mode of
       script execution. This is a scripting language independent shell. By default, JavaScript is the language used, but the  -l  option  can	be
       used  to  specify  a  different	language.  Through Java to scripting language communication, jrunscript supports "exploratory programming"
       style.

       NOTE: This tool is experimental and may not be available in future versions of the JDK.

OPTIONS

       -classpath path
	  Specify where to find the user's .class files that are accessed by the script.

       -cp path
	  This is a synonym for -classpath path

       -Dname=value
	  Set a Java system property.

       -Jflag
	  Pass flag directly to the Java virtual machine on which jrunscript is run.

       -l language
	  Use the specified scripting language. By default, JavaScript is used. Note that to use other scripting languages, you also need to spec-
	  ify the corresponding script engine's jar file using -cp or -classpath option.

       -e script
	  Evaluate the given script. This option can be used to run "one liner" scripts specified completely on the command line.

       -encoding encoding
	  Specify the character encoding used while reading script files.

       -f script-file
	  Evaluate the given script file (batch mode).

       -f -
	  Read and evaluate a script from standard input (interactive mode).

       -help
	  Output help message and exit.

       -?
	  Output help message and exit.

       -q
	  List all script engines available and exit.

ARGUMENTS

       If  [arguments...] are present and if no -e or -f option is used, then the first argument is the script file and the rest of the arguments,
       if any, are passed as script arguments. If [arguments..] and -e or -f option are used, then all [arguments..] are passed  as  script  argu-
       ments.  If [arguments..], -e and -f are missing, interactive mode is used. Script arguments are available to a script in an engine variable
       named "arguments" of type String array.

EXAMPLES

       Executing inline scripts

	  jrunscript -e "print('hello world')"
	  jrunscript -e "cat('http://java.sun.com')"

       Use specified language and evaluate given script file

	  jrunscript -l js -f test.js

       Interactive mode

	  jrunscript
	  js>print('hello world');
	  hello world
	  js>34 + 55
	  89
	  js> thread(function() { print('hello world'); }
	  hello world
	  js>

       Run script file with script arguments

	  jrunscript test.js arg1 arg2 arg3

       test.js is script file to execute and arg1, arg2 and arg3 are passed to script as script arguments. Script can access  these  using  "argu-
       ments" array.

SEE ALSO

       If JavaScript is used, then before evaluating any user defined script, jrunscript initializes certain built-in functions and objects. These
       JavaScript built-ins are documented in jsdocs.

								    06 Aug 2006 						     jrunscript(1)