Sponsored Content
Top Forums Shell Programming and Scripting How to read particular line in file from specific column? Post 302762091 by nex_asp on Monday 28th of January 2013 05:05:56 AM
Old 01-28-2013
How to read particular line in file from specific column?

Hi...friends....

I want to create inventory...information for that I need to read some specific row say 2nd row from 1st 3 column and and write data with particular file used, I have some more column also but I need only 3 column data of first entry after header

I attached sample file..those who know please help...
my input

Code:
ST_DATE    LATITUDE    LONGITUDE
05 Aug 1988 07:10:00 AM    9.983    68.033
05 Aug 1988 07:10:00 AM    9.983    68.033
05 Aug 1988 07:10:00 AM    9.983    68.033

need of output is like this

Code:
filename    date    time    lat    long
myfile.txt    05/08/98    07:10:00    9.983    68.033

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Retrieve line from a file based on a value in specific column

Hi, I have a file that has several values seperated by ":" 2006:John:Student:Football:Portugal:Cinema 2006:James:Engineer:Basket:Poland:Theatre 2007:Lucy:Diver:Gymnastic:England:Music 2007:Smith:Plumber:Basket:Spain:Poker I need make a filter based on the 5th field to find countries that... (1 Reply)
Discussion started by: efernandes
1 Replies

2. Shell Programming and Scripting

How to read the value from a specific line and column in to a csh variable

Hi All, Although its a basic question the last 2 hours of googling and trying didnt help me to achieve what i want. Maybe some one can help me I have a text file text1.txt: blablablabla A B C D E F and i would like to read to read what is on position E (line 3 column 2) in a... (2 Replies)
Discussion started by: Radamez
2 Replies

3. Shell Programming and Scripting

A script that read specific fileds from the 7th line in a file

Dear All, I need a unix script that will read the 7th line and especially these fileds from a file Mo speed 16, Mt speed 15 every 15 minutes starting from 00:00 to 23:45 on daily basis and put the result in a txt file and name it MT_MO_20090225.txt, please also note that the system date format... (2 Replies)
Discussion started by: samura
2 Replies

4. Shell Programming and Scripting

How to read the value from a specific line and column BASH

Hi All, I have the same problem as the one posted in https://www.unix.com/shell-programming-scripting/96097-how-read-value-specific-line-column-csh-variable.html but I'm using bash. Can anyone tell me how I have to modify the code to make it bash compatible? eval `awk 'NR==3{print "set... (5 Replies)
Discussion started by: f_o_555
5 Replies

5. Shell Programming and Scripting

read file line by line print column wise

I have a .csv file which is seperated with (;) inputfile --------- ZZZZ;AAAA;BBB;CCCC;DDD;EEE; YYYY;BBBB;CCC;DDDD;EEE;FFF; ... ... reading file line by line till end of file. while reading each line output format should be . i need to print only specific columns let say 5th... (2 Replies)
Discussion started by: rocking77
2 Replies

6. Shell Programming and Scripting

how read specific line in a file and write it in a new text file?

I have list of files in a directory 'dir'. Each file is of type HTML. I need to read each file and get the string which starts with 'http' and write them in a new text file. How can i do this shell scripting? file1.html <head> <url>http://www.google.com</url> </head> file2.html <head>... (6 Replies)
Discussion started by: vel4ever
6 Replies

7. Shell Programming and Scripting

Read file from nth line to specific character

Hi, I want to read the file from nth line (where n is an integer) to until I encounter @ char. Can any one please help me how to do this? Thanks. (3 Replies)
Discussion started by: laalesh
3 Replies

8. Shell Programming and Scripting

How to grep an empty line in a specific column of a file?

Suppose i have the following data : cat file.txt 12431,123334,55353,546646,14342234,4646,35234 123123,3535,123434,132535,1234134,13535,123534 123213,545465,23434,45646,2342345,4656,31243 2355425,2134324,53425,342,35235,23434,234535 3423424,234234,65465,,2344,35436,234524,234... (7 Replies)
Discussion started by: Ravi Tej
7 Replies

9. Shell Programming and Scripting

To read specific line from a file

Hi, I have a ldif file like below: version: 1 dn: cn=Test Group,ou=Applications,dc=xyz,dc=com objectClass: groupOfUniqueNames objectClass: top cn: Test Group uniqueMember: uid=abc,ou=People,o=xyz,o=Corporate,dc=xyz,dc=com dn: cn=Test Sub Group,cn=Test... (4 Replies)
Discussion started by: saurau
4 Replies

10. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies
ascii2binary(1) 					      General Commands Manual						   ascii2binary(1)

NAME
ascii2binary - Convert ASCII numbers to binary SYNOPSIS
ascii2binary [flags] DESCRIPTION
ascii2binary reads input consisting of a sequence of ASCII textual representations of numbers, separated by whitespace, and produces as output the binary equivalents. The type (unsigned integer, signed integer, or floating point number) and size of the binary output is selected by means of command line flags. The default is unsigned character. Input is checked both for format errors and to ensure that the number requested can be represented in a number of the requested binary type and size. INPUT FORMAT
The input formats supported are exactly those supported by strtod(3) for floating point numbers, by strtoll(3) for signed integers, and by strtoull(3) for unsigned integers, except that, unlike strtod(3) floating point numbers may have thousands separators. This means that by default integers may be decimal, octal, or hexadecimal, determined by the usual conventions. The command line flag -b may be used to spec- ify another base for integer conversions. COMMAND LINE FLAGS
Long options may not be available on some systems. -b,--base <base> set base in range [2,36] for integer conversions. The base may be either an integer or: (b)binary (o)octal (d)ecimal (h)exadecimal. -h,--help print help message -L,locale <locale> Set the LC_NUMERIC facet of the locale to <locale>. -s,--sizes print sizes of types on current machine and related information -t,--type <type> set type and size of output The following are the possible output types. Note that some types may not be available on some machines. d double f float sc signed char ss signed short si signed int sl signed long sq signed long long uc unsigned char us unsigned short ui unsigned int ul unsigned long uq unsigned long long -v,--version identify version -X,--explain-exit-codes print a summary of the exit status codes. EXIT STATUS
The following values are returned on exit: 0 SUCCESS The input was successfully converted. 1 INFO The user requested information such as the version number or usage synopsis and this has been provided. 2 SYSTEM ERROR An error resulted from a failure of the operating system such as an i/o error or inability to allocate storage. 3 COMMAND LINE ERROR The program was called with invalid or inconsistent command line flags. 4 RANGE ERROR This means that the input may be well-formed but cannot be represented as the required type. For example, if the input is the string 983 and ascii2binary is requested to convert this into an unsigned byte, ascii2binary will exit with a RANGE ERROR because 983 exceeds the maximum value representable in an unsigned byte, which is 255. 5 INPUT ERROR This means that the input was ill-formed, that is that it could not be interpreted as a number of the required type. For example, if the input is 0x2A and a decimal value is called for, an INPUT ERROR will be returned since 0x2A is not a valid representation of a decimal integer. AUTHOR
Bill Poser (billposer@alum.mit.edu) LICENSE
GNU General Public License, version 3 SEE ALSO
binary2ascii(1), strtod(3), strtoll(3), strtoull(3) July, 2010 ascii2binary(1)
All times are GMT -4. The time now is 06:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy