Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Grep Commands
Top Forums Shell Programming and Scripting Grep Commands Post 302848061 by smkremer on Wednesday 28th of August 2013 11:23:29 AM
Old 08-28-2013
Grep Commands
I have a text file that has multiple lines in it with multiple dates and years. I was trying to figure out the best way to remove the line that had 2010 and 2011 to an archive file. We only need to keep the 2012 and 2013 lines in the original file. The following is a sample line in the txt file:

Code:
20126789|Active|08/28/2013 08:42:28 AM

If I do the following command it will take all of the 2010's and place it in the archive file and leave the original file alone:

Code:
egrep '[0-9][0-9]/[0-9][0-9]/2010' "textfile.txt" >> "textfile_2010.txt"

What is the correct format to also grab 2011? I tried [2010][2011] and that did not work.

I also tried the following to grab everything but 2010 to put in a new file:

Code:
egrep -v '[0-9][0-9]/[0-9][0-9]/2010' "textfile.txt" >> "textfile_archive.txt"

However, I would prefer to only have one or two commands to do what I need. Therefore, what's the simplest way to do the following:

1) Delete the lines that have a date of ##/##/2010 and ##/##/2011 in textfile.txt and place them in textfile_archive.txt

Results would be:

textfile.txt
Code:
20126789|Active|01/01/2012 08:42:28 AM
20126789|Active|12/31/2013 08:40:28 AM

textfile_archive.txt
Code:
20136789|Active|01/01/2010 11:42:28 AM
20126789|Active|12/31/2011 05:40:28 PM

Any help is appreciated!

Thanks!
Last edited by Scott; 08-28-2013 at 12:25 PM.. Reason: Please use code tags for code and data
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

find and grep commands

I'm having trouble with the following commands i. count the number of lines which end in a 4 letter word grep '{4\}$' bfile <<seems to print out everything abc abc abcd joe joe john bob bill gregory greg greg gregory the grep command prints out the lines with 4 letter words and the... (3 Replies)
Discussion started by: StrengthThaDon
3 Replies

2. Shell Programming and Scripting

Grep commands in loop

Hi All, Reference to my previous post I need to compare all the lines in the file1 with file2 for this condition if file1 {$3,$5} ==file2 {$3,$5} then grep file2{$1}latest date. need output in file3 10/04/2008 09/04/2008 09/04/2008 08/04/2008 can anyone suggest me Thanks... (0 Replies)
Discussion started by: karthikn7974
0 Replies

3. UNIX for Dummies Questions & Answers

grep commands

I need your's help to display user with greep command form /etc/passwd 1. to display all login to begin and finishing with letter a or b etc.users admina bserb broota 2. beginning and finishing with the same sign etc. users aghata:.... roootr:....3. to contain what the least three... (1 Reply)
Discussion started by: ViruS89
1 Replies

4. Shell Programming and Scripting

Difference between 2 grep - commands

Hi, I need to know the difference between this commands: grep * *search* grep "*" *search* As far as i know does the 2nd command search for files which have a name with *search* and greps then all which have chars from a-z in the file content. But was does the first command?? Best... (1 Reply)
Discussion started by: xus
1 Replies

5. Shell Programming and Scripting

echo and grep commands

Hey im new in this...anything will be helpful... The user will input the word or phrase .... I want to search the user input in file (by lines) but not all then with this line search on another file ( with the specific line) and show to the user. Example: file1.txt ======= a aa aaa... (2 Replies)
Discussion started by: Sundown
2 Replies

6. Shell Programming and Scripting

Grep commands & format

I have these grep commands and need to put them next each other (in horizontal layout). cat /tmp/dsmc.out |grep Done cat /tmp/dsmc.out |grep "Elapsed processing time:" cat /tmp/dsmc.out |grep "Client date/time:" cat /tmp/dsmc.out |grep "Total number of bytes transferred:" so that it... (6 Replies)
Discussion started by: Daniel Gate
6 Replies

7. Shell Programming and Scripting

Join two commands sed and grep

Hi all, I have two separate commands which I would like to join. Basically, I want to match a line and insert a character at the end of the previous line to the matched line Here is what I have gotgrep -B1 '^>' sed 's/$/*/' Any help is much appreciated thanks (5 Replies)
Discussion started by: kaav06
5 Replies

8. Shell Programming and Scripting

Help with ls, grep commands

Oracle Linux 6.4/Bash shell I have six files as shown below. Using ls/grep (or anything) , I need to list all files which start with the pattern stomper but not the ones which ends with 1. $ touch stompera $ touch stomperb $ touch stomperc $ touch stompera1 $ touch stomperb1 $ touch... (7 Replies)
Discussion started by: kraljic
7 Replies

9. Homework & Coursework Questions

Grep commands: need some practice help please

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Use the less command to view the words file. To see the results of a grep that returns many rows, pipe the... (3 Replies)
Discussion started by: asaint
3 Replies

10. UNIX for Beginners Questions & Answers

Task grep and awk commands

Hi everyone, I have a question, please help me. awk -F: '$3<75' /etc/passwd grep -ir nashorn ./ | grep "^*\.java" what do these commands do ? Thanks (2 Replies)
Discussion started by: burak171
2 Replies

LEARN ABOUT REDHAT

mac2unix

dos2unix(1)						      General Commands Manual						       dos2unix(1)

NAME

       dos2unix - DOS/MAC to UNIX text file format converter

SYNOPSYS

       dos2unix [options] [-c convmode] [-o file ...] [-n infile outfile ...]

       Options:

       [-hkqV] [--help] [--keepdate] [--quiet] [--version]

DESCRIPTION

       This manual page documents dos2unix, the program that converts plain text files in DOS/MAC format to UNIX format.

OPTIONS

       The following options are available:

       -h --help
	      Print online help.

       -k --keepdate
	      Keep the date stamp of output file same as input file.

       -q --quiet
	      Quiet mode. Suppress all warning and messages.

       -V --version
	      Prints version information.

       -c --convmode convmode
	      Sets conversion mode. Simulates dos2unix under SunOS.

       -o --oldfile file ...
	      Old file mode. Convert the file and write output to it. The program default to run in this mode. Wildcard names may be used.

       -n --newfile infile outfile ...
	      New  file  mode.	Convert the infile and write output to outfile. File names must be given in pairs and wildcard names should NOT be
	      used or you WILL lost your files.

EXAMPLES

       Get input from stdin and write output to stdout.

	      dos2unix

       Convert and replace a.txt. Convert and replace b.txt.

	      dos2unix a.txt b.txt

	      dos2unix -o a.txt b.txt

       Convert and replace a.txt in ASCII conversion mode.  Convert and replace b.txt in ISO conversion mode.  Convert	c.txt  from  Mac  to  Unix
       ascii format.

	      dos2unix a.txt -c iso b.txt

	      dos2unix -c ascii a.txt -c iso b.txt

	      dos2unix -c mac a.txt b.txt

       Convert and replace a.txt while keeping original date stamp.

	      dos2unix -k a.txt

	      dos2unix -k -o a.txt

       Convert a.txt and write to e.txt.

	      dos2unix -n a.txt e.txt

       Convert a.txt and write to e.txt, keep date stamp of e.txt same as a.txt.

	      dos2unix -k -n a.txt e.txt

       Convert and replace a.txt. Convert b.txt and write to e.txt.

	      dos2unix a.txt -n b.txt e.txt

	      dos2unix -o a.txt -n b.txt e.txt

       Convert c.txt and write to e.txt. Convert and replace a.txt.  Convert and replace b.txt. Convert d.txt and write to f.txt.

	      dos2unix -n c.txt e.txt -o a.txt b.txt -n d.txt f.txt

DIAGNOSTICS

BUGS

       The program does not work properly under MSDOS in stdio processing mode.  If you know why is that so, please tell me.

AUTHORS

       Benjamin Lin - <blin@socs.uts.edu.au>

       Bernd Johannes Wuebben (mac2unix mode) <wuebben@kde.org>

MISCELLANY

       Tested environment:

	      Linux 1.2.0 with GNU C 2.5.8

	      SunOS 4.1.3 with GNU C 2.6.3

	      MS-DOS 6.20 with Borland C++ 4.02

       Suggestions and bug reports are welcome.

SEE ALSO

       unix2dos(1) mac2unix(1)

1995.03.31							   dos2unix v3.0						       dos2unix(1)
All times are GMT -4. The time now is 10:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy