Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search and delete a row which is delimited by |^
Top Forums UNIX for Beginners Questions & Answers Search and delete a row which is delimited by |^ Post 303043376 by Tuxidow on Monday 27th of January 2020 03:34:59 AM
Old 01-27-2020
Search and delete a row which is delimited by |^
I have a sample text file like this.
Code:
CampaignId|^CampaignCd|^InsertionOrderCd|^OwningAdvertiserCd|^CampaignName
998201|^T15-06|^T15|^|^GTA 160x160
998277|^T15-07|^T15|^TEST|^GTA 160x160
998297|^T15-07|^T15|^TEST2|^GTA 160x160

I want to delete the line only when the 4th field is empty. Here the delimiter is |^. Here 2nd line is to be deleted. First line is the heading. One condition here but, if the 3rd column is empty it shouldn't delete that line. Deletion should happen only if the 4th column is empty. I tried this which is not solving the real purpose.

Code:
sed -i '/|^|^/d' <your file>

--- Post updated at 01:34 AM ---

tried this myself. To an extent its working. Any other methods?

Code:
awk -F "^"  '$4!="|"' test.txt

Last edited by RavinderSingh13; 01-27-2020 at 05:12 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Delete last value from pipe delimited file

I have a large(ish) pipe delimited file. The last line of the file contains a total row count and a checksum: END|1537451|1328569446 After making other adjustments to the file, I need to strip out the checksum and apply a new value - I have a script to generate the checksum and 'cat' it... (3 Replies)
Discussion started by: relentl3ss
3 Replies

2. UNIX for Dummies Questions & Answers

How do you delete cells from a space delimited text file given row and column number?

How do you delete cells from a space delimited text file given row and column number? Letś say the row number is r and the column number is c. Thanks! (5 Replies)
Discussion started by: evelibertine
5 Replies

3. UNIX for Dummies Questions & Answers

Delete header row and reformat from tab delimited to fixed width

Hello gurus, I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned. Below is a sample of the file:... (4 Replies)
Discussion started by: chumsky
4 Replies

4. Shell Programming and Scripting

search column and delete row if greater than value

Hi, as the title states i need to find a way to search a column for values great than 1000, and if it is, then delete that row. An example 1 7.021 6.967 116.019 4 U 6.980E+07 0.000E+00 e 0 0 0 0 2 8.292 7.908 118.063 3 U 1.440E+07 0.000E+00 e 0 821 814 ... (3 Replies)
Discussion started by: olifu02
3 Replies

5. Shell Programming and Scripting

Comma delimited row into multiple rows, repeat first value

i am building a database to keep track of unix groups. Using the command "ypcat group" I get an output similar to the following group1:GROUP:9999:user1,user2,user3 groupA:GROUP:1111:usera,userb,userc I want to convert this output so it looks like this group1:user1 group1:user2... (2 Replies)
Discussion started by: newreverie
2 Replies

6. Shell Programming and Scripting

Converting a list to a row delimited

Hello, I have a large database with the following structure: set of clustered names followed by a hard return and followed by a second set of clustered names and so on. Sometimes the clusters can be as many as 150. Since the data is in an Indian language, a theoretical example will make this... (9 Replies)
Discussion started by: gimley
9 Replies

7. Shell Programming and Scripting

Parse tab delimited file, check condition and delete row

I am fairly new to programming and trying to resolve this problem. I have the file like this. CHROM POS REF ALT 10_sample.bam 11_sample.bam 12_sample.bam 13_sample.bam 14_sample.bam 15_sample.bam 16_sample.bam tg93 77 T C T T T T T tg93 79 ... (4 Replies)
Discussion started by: empyrean
4 Replies

8. Shell Programming and Scripting

awk read one delimited file, search another delimited file

Hello folks, I have another doozy. I have two files. The first file has four fields in it. These four fields map to different locations in my second file. What I want to do is read the master file (file 2 - 23 fields) and compare each line against each record in file 1. If I get a match in all four... (4 Replies)
Discussion started by: dagamier
4 Replies

9. Shell Programming and Scripting

Search row by row from one file to another file if match is found print few colums of file 2

this is the requirement list.txt table1 table2 table3 testfile.txt name#place#data#select * from table1 name2#place2#data2#select * from table 10 innerjoin table3 name2#place2#data2#select * from table 10 output name place table1 name2 place table3 i tried using awk (7 Replies)
Discussion started by: vamsekumar
7 Replies

10. UNIX for Beginners Questions & Answers

awk to parse current and next row in tab-delimited file

Hi there, I would like to use awk to reformat a tab-delimited file containing three columns as follows: Data file: sample 1 173 sample 269 530 sample 687 733 sample 1699 1779 Desired output file: sample 174..265, 531..686, 734..1698 I need the value... (5 Replies)
Discussion started by: emiley
5 Replies

LEARN ABOUT SUSE

catman

CATMAN(8)							Manual pager utils							 CATMAN(8)

NAME

       catman - create or update the pre-formatted manual pages

SYNOPSIS

       catman [-dhV] [-M path] [-C file] [section] ...

DESCRIPTION

       catman  is  used to create an up to date set of pre-formatted manual pages known as cat pages.  Cat pages are generally much faster to dis-
       play than the original manual pages, but require extra storage space.  The decision to support cat pages is that of the	local  administra-
       tor, who must provide suitable directories to contain them.

       The options available to catman are the manual page hierarchies and sections to pre-format.  The default hierarchies are those specified as
       system hierarchies in the man-db configuration file, and the default sections are either the colon-delimited contents  of  the  environment
       variable $MANSECT or the standard set compiled into man if $MANSECT is undefined.  Supplying catman with a set of whitespace-delimited sec-
       tion names will override both of the above.

       catman makes use of the index database cache associated with each hierarchy to determine which files need to be formatted.

OPTIONS

       -d, --debug
	      Print debugging information.

       -M path, --manpath=path
	      Specify an alternate colon-delimited manual page hierarchy search path.  By default, this is all paths indicated as  system  hierar-
	      chies in the man-db configuration file.

       -C file, --config-file=file
	      Use this user configuration file rather than the default of ~/.manpath.

       -h, --help
	      Print a help message and exit.

       -V, --version
	      Display version information.

ENVIRONMENT

       MANSECT
	      If  $MANSECT is set, its value is a colon-delimited list of sections and it is used to determine which manual sections to search and
	      in what order.

       MANPATH
	      If $MANPATH is set, its value is interpreted as the colon-delimited manual page hierarchy search path to use.

FILES

       /etc/manpath.config
	      man-db configuration file.

       /usr/man/index.(bt|db|dir|pag)
	      A traditional global index database cache.

       /var/catman/index.(bt|db|dir|pag)
	      An alternate or FSSTND compliant global index database cache.

SEE ALSO

       man(1), manpath(5), mandb(8).

AUTHOR

       Wilf. (G.Wilford@ee.surrey.ac.uk).
       Fabrizio Polacco (fpolacco@debian.org).

2.5.2								    2008-05-05								 CATMAN(8)
All times are GMT -4. The time now is 12:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy