Getting required fields from a text file in UNIX

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to search a text in file and retrieve required lines following it with UNIX command?

I have requirement to search for a text in the file and retrieve required lines that is user defined with unix command. Eg: Find the text UNIX in the below file and need to return Test 8 & Test 9 Test 1 Test 2 Test 3 Test 4 UNIX Test 5 Test 6 Test 7 Test 8 Test 9 Result can...

2. Shell Programming and Scripting

Rearrange fields of delimited text file

I want to rearrange the fields of delimited text file after sorting first line (only): input file: a_13;a_2;a_1;a_10 13;2;1;10 the result should be: a_1;a_2;a_10;a_13 1;2;10;13 any help would be appreciated andy

3. Shell Programming and Scripting

How to identify varying unique fields values from a text file in UNIX?

Hi, I have a huge unsorted text file. We wanted to identify the unique field values in a line and consider those fields as a primary key for a table in upstream system. Basically, the process or script should fetch the values from each line that are unique compared to the rest of the lines in...

4. Shell Programming and Scripting

How to Modify a file content in UNIX and sort for only required fields ?

I have the below contents in a file after making the below curl call curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "Disconnected" > test "state" : "Disconnected",, "Rno" : "5554f1d2" "state" : "Disconnected",, "Rno" : "10587563" "state" : "Disconnected",, "Rno" :...

5. Shell Programming and Scripting

Parse file for fields and specific text

I have a file of ~500,000 entries in the following: file.txt chr1 11868 12227 ENSG00000223972.5 . + HAVANA exon . gene_id "ENSG00000223972.5"; transcript_id "ENST00000456328.2"; gene_type "transcribed_unprocessed_pseudogene"; gene_status "KNOWN"; gene_name "DDX11L1"; transcript_type...

6. Shell Programming and Scripting

How to search for blank fields in a text file from a certain position?

7. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help.

8. Shell Programming and Scripting

how to convert fields from a text file to excel columns

i have this file which has the following contents: ,-0.3000 ,-0.3000 ,-0.3000 ,-0.9000 ,-0.9000 ,-0.9000 i would like to get this: -0.3-0.9-0.3-0.9-0.3-0.9 so far i am trying: awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2 any help...

9. UNIX for Dummies Questions & Answers

extract fields from text file using delimiter!!

Hi All, I am new to unix scripting, please help me in solving this assignment.. I have a scenario, as follows: 1. i have a text file(read1.txt) with the following data sairam,123 kamal,122 etc.. 2. I have to write a unix...

10. Shell Programming and Scripting

Need a Help with sort a text file with some fields

Ive got a file called listacdrs with this structure: 01/09/2006 12:13 p.m. 1.046.528 CF0155.DAT 01/09/2006 12:13 p.m. 1.046.528 CF0156.DAT 01/09/2006 12:13 p.m. 1.046.528 CF0157.DAT 01/09/2006 12:13 p.m. 1.046.528 CF0158.DAT 01/09/2006 12:14 p.m. ...

LEARN ABOUT HPUX

read

read(1) 						      General Commands Manual							   read(1)

NAME

       read - read a line from standard input

SYNOPSIS

       var ...

DESCRIPTION

       reads  a single line from standard input.  The line is split into fields as when processed by the shell (refer to shells in the first field
       is assigned to the first variable var, the second field to the second variable var, and so forth.  If there are more fields than there  are
       specified  var  operands,  the remaining fields and their intervening separators are assigned to the last var.  If there are more vars than
       fields, the remaining vars are set to empty strings.

       The setting of variables specified by the var operands affect the current shell execution environment.

       Standard input to can be redirected from a text file.

       Since affects the current shell execution environment, it is usually provided as a normal shell special (built-in) command.  Thus, if it is
       called  in  a  subshell	or  separate utility execution environment similar to the following, it does not affect the shell variables in the
       caller's environment:

   Options
       recognizes the following options:

	      Do not treat a backslash character in any special way.
		     Consider each backslash to be part of the input line.

   Opperands
       recognizes the following operands:

	      var    The name of an existing or nonexisting shell variable.

EXTERNAL INFLUENCES

   Environment Variables
       determines the internal field separators used to delimit fields.

RETURN VALUE

       exits with one of the following values:

	       0     Successful completion.

	      >0     End-of-file was detected or an error occurred.

EXAMPLES

       Print a file with the first field of each line moved to the end of the line.

	      while read -r xx yy
	      do
		      printf "%s %s 
" "$yy" "$xx"
	      done < input_file

SEE ALSO

       csh(1), ksh(1), sh(1), sh-posix(1).

STANDARDS CONFORMANCE

																	   read(1)

Shell Programming and Scripting