Sponsored Content
Top Forums Shell Programming and Scripting Selecting rows from a pipe delimited file based on condition Post 302564214 by jayan_jay on Thursday 13th of October 2011 05:58:26 AM
Old 10-13-2011
just a try .. (not 100%)
Code:
$ grep "..|0[0-8]..||" infile
2345|98|0809||y|0|537
9685|98|0809||y|0|234
2315|98|0809||x|564|0

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert a pipe delimited file to a':" delimited file

i have a file whose data is like this:: osr_pe_assign|-120|wg000d@att.com|4| osr_evt|-21|wg000d@att.com|4| pe_avail|-21|wg000d@att.com|4| osr_svt|-11|wg000d@att.com|4| pe_mop|-13|wg000d@att.com|4| instar_ready|-35|wg000d@att.com|4| nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
Discussion started by: priyanka3006
6 Replies

2. Shell Programming and Scripting

Selecting rows based on values in columns

Hi My pipe delimited .txt file contains rows with 10 columns. Can anyone advise how I output to file only those rows with the letters ‘ci' as the first 2 characters in the 3rd column ? Many thanks (4 Replies)
Discussion started by: malts18
4 Replies

3. Shell Programming and Scripting

How to convert a space delimited file into a pipe delimited file using shellscript?

Hi All, I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted... AA ATIU2345098809 009697 005374 BB ATIU2345097809 005445 006518 CC ATIU9685098809 003215 003571 DD... (7 Replies)
Discussion started by: nithins007
7 Replies

4. Shell Programming and Scripting

Help with converting Pipe delimited file to Tab Delimited

I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use cat file | sed 's/|//t/g' The above command substituted "/t" not tab in the place of pipe. Sample file: abc|123|2012-01-30|2012-04-28|xyz have to convert to: abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies

5. UNIX for Dummies Questions & Answers

Extracting rows from a space delimited text file based on the values of a column

I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies

6. Shell Programming and Scripting

How to ignore Pipe in Pipe delimited file?

Hi guys, I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file for eg: file 1: xx|yy|"xyz|zzz"|zzz|12... using below awk command awk 'BEGIN {FS=OFS="|" } print $3 i would get xyz But i want as : xyz|zzz to consider as whole column... (13 Replies)
Discussion started by: rohit_shinez
13 Replies

7. Shell Programming and Scripting

Convert rows to columns based on condition

I have a file some thing like this: GN Name=YWHAB; RC TISSUE=Keratinocyte; RC TISSUE=Thymus; CC -!- FUNCTION: Adapter protein implicated in the regulation of a large CC spectrum of both general and specialized signaling pathways GN Name=YWHAE; RC TISSUE=Liver; RC ... (13 Replies)
Discussion started by: raj_k
13 Replies

8. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies

9. Shell Programming and Scripting

awk to ignore multiple rows based on a condition

All, I have a text file(Inputfile.csv) with millions of rows and 100 columns. Check the sample for 2 columns below. Key,Check A,1 A,2 A, A,4 B,0 B,1 B,2 B,3 B,4 .... million rows. My requirement is to delete all the rows corresponding to all the keys which ever has at least one... (4 Replies)
Discussion started by: ks_reddy
4 Replies

10. Shell Programming and Scripting

How to remove new line characters from data rows in a Pipe delimited file?

I have a file as below Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber 1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000 2345|FirstName2|MiddleName3|LastName4| Add1 || ADD2| 234|000000000 OUTPUT : ... (1 Reply)
Discussion started by: styris
1 Replies
fattach(3C)															       fattach(3C)

NAME
fattach() - attach a STREAMS file descriptor to an object in the file system name space SYNOPSIS
DESCRIPTION
The function attaches the fd file descriptor to an object in the file system name space designated by path. fd specifies an open file descriptor to a STREAMS device or STREAMS-based pipe. path specifies the pathname of an existing object in the file system. A STREAMS device or pipe can be attached to more than one node in the file system name space. In other words, a STREAMS device or pipe is allowed to have several associated names. Until the STREAMS device or pipe is detached from the node (with fdetach(3C) or fdetach(1M)), all opera- tions on path will act on the STREAMS device or pipe instead of the file system object path. The stream's attributes (see the stat(2) reference page) are set according to the following scheme: o The group ID, user ID, times, and permissions are set to those of path. o The size as well as the device number are set to those of the STREAMS device or pipe designated by the fd parameter. Note that although the attributes of the STREAMS device or pipe may change (see the chmod(2) reference page), the attributes of the underlying file system object path will not be changed. o The number of links is set to 1. RETURN VALUE
Upon successful completion, the function returns a value of 0 (zero). Otherwise, it returns a value of -1, and is set to indicate the error. ERRORS
If any of the following conditions occurs, the function sets to the value that corresponds to the condition. [EACCES] Although the user is the owner of path, the user has no write permissions for it. [EBADF] The fd parameter is an invalid file descriptor. [EBUSY] The existing object specified by the path parameter is already mounted or has a file descriptor attached to it. [EFAULT] The path parameter points to a location outside of the allocated address space of the process. [EINVAL] The fd parameter does not refer to a STREAMS device or STREAMS-based pipe. [ELOOP] When path was translated, too many symbolic links were found. [ENOENT] path does not exist. [ENOTDIR] The directory portion of the path parameter does not exist. [ENAMETOOLONG] The size of a pathname component is longer than when is in effect, or the pathname length is longer than [EPERM] The current effective user ID is not the owner of the existing object specified by the path parameter. SEE ALSO
fdetach(3C), isastream(3C), chmod(2), stat(2), fdetach(1M), streamio(7). STANDARDS COMPLIANCE
fattach(3C)
All times are GMT -4. The time now is 07:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy