Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Grep strings from file and put in Column
Top Forums Shell Programming and Scripting Grep strings from file and put in Column Post 302265575 by thepurple on Monday 8th of December 2008 02:06:16 AM
Old 12-08-2008
Grep strings from file and put in Column
Dear Experts,

My file contains below-

GET:SUB:ISI,432350414557432;
RESP:0:MD,019352020633:ISI,432350414557432:T11,1:T21,1:T22,1:B16,1:T62,1:BAIC,0:BAOC,1:BOIC,0:BIRO,0 :BORO,0:PAID,1;
GET:SUB:ISI,432350414581060;
RESP:0:MD,019352020743:ISI,432350414581060:T11,1:T21,1:T22,1:B16,1:T62,1:BAIC,0:BAOC,0:BOIC,0:BIRO,0 :BORO,0:PAID,0;
GET:SUB:ISI,432350211029016;
RESP:11000003;
GET:SUB:ISI,432350414073552;
RESP:0:MD,019352032067:ISI,432350414073552:T11,1:T21,1:T22,1:B16,1:T62,1:BAIC,0:BAOC,0:BOIC,0:BIRO,0 :BORO,0:PAID,1;


I want make a script like below-

if find-
RESP:0:MD,019352020633:ISI,432350414557432:T11,1:T21,1:T22,1:B16,1:T62,1:BAIC,0:BAOC,1:BOIC,0:BIRO,0 :BORO,0:PAID,1;
then PAID,1 printf "paid"
else PAID,0 printf "non-paid"

if find-
RESP:11000003
then RESP:11000003 printf "not-exist"


So, after run the script output will be for the above file-

paid
non-paid
not exits
paid

//purple
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Put strings around the file name

I have a file(old file) with names in it like Jolly Mirani Han Lee stuart Lloyd I want string to be added to these names . New file should look like 'jolly mirani' 'han lee' 'stuart lloyd' I tried using sed command but doesn't work for string but it do work for paranthesis. Can some one... (3 Replies)
Discussion started by: Jolly
3 Replies

2. Shell Programming and Scripting

want to grep only strings in a file?

Hai, Just want to print only alphanumeric in a file ex:- fdsdsklf#@^%$#hf output:- fdsdsklfhf plz, help me:o (5 Replies)
Discussion started by: balan_mca
5 Replies

3. Shell Programming and Scripting

grep two strings in a file..

Hello All, I have a big file about 1000 lines. Now i am trying to grep a particular string and printing the lines from the string. say for example in 500th line i have the date as "Mon Wed 14 20:15:24 2010". now i in my case i need to grep the combination of the strings "Mon Wed 14" and the... (7 Replies)
Discussion started by: intiraju
7 Replies

4. Shell Programming and Scripting

Strings from one file which exactly match to the 1st column of other file and then print lines.

Hi, I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines). ################################# huge_file.txt a a ab b ################################## small_file.txt a 1.5 b 2.5 ab ... (4 Replies)
Discussion started by: AshwaniSharma09
4 Replies

5. Shell Programming and Scripting

Get a column from one file and put it in another

I have 2 files that I would need from one file the 3rd column and put into the second file. Preferably in KSH . For example file one has file1: Column 1 Column 2 Column 3 Column 4 Column 5 file2: Column 1 Column 2 Column 3 Column 4 Column 5 So take Column 3 and put into file1 making it... (4 Replies)
Discussion started by: bombcan1
4 Replies

6. Shell Programming and Scripting

Use grep sed or awk to extract string from log file and put into CSV

I'd like to copy strings from a log file and put them into a CSV. The strings could be on different line numbers, depending on size of log. Example Log File: File = foo.bat Date = 11/11/11 User = Foo Bar Size = 1024 ... CSV should look like: "foo.bat","11/11/11","Foo Bar","1024" (7 Replies)
Discussion started by: chipperuga
7 Replies

7. Shell Programming and Scripting

Put Header on Text file of all column

Hi I have in put file A.txt ABCDE1 JFHFJFJF3 1 1 SC1 12/10 ABCDE2 JFHFJFJF5 1 1 SC1 12/10 ABCDE3 JFHFJFJF5 1 1 SC1 12/10 ABCDE4 JFHFJFJF6 1 1 SC1 12/10 I want output in .csv with header: Name SUb_N x y No Board ABCDE1 JFHFJFJF3 1 1 SC1 12/10 ABCDE2 JFHFJFJF5 1 1 SC1... (7 Replies)
Discussion started by: pareshkp
7 Replies

8. Shell Programming and Scripting

Copy column string and put in different column

Hello Here is my input: SU3902 SU3902A NS29C (10) (00) Q1J1 0 SU3902 SU3902B VLR05 (20) (02) Q2H1 4 SU3902 SU3902C NBR22 (30) (06) Q3R5 8 SU3904 SU39047 NSV19 (11) (09) Q4k6 2 SU3904 SU39048 LB231 (12) (05) Q5k1 6 SU3904 SU39049 11VLT (13) (08) Q10C1 10 SU3904 SU3904A 25R05 (15) (06)... (3 Replies)
Discussion started by: pareshkp
3 Replies

9. Shell Programming and Scripting

Grep multiple strings in a file

Consider i have the below data in my log file. i want to grep using "Monday" and "Working" So the only output i expect is Can you help me with the grep query for Sun Sparc ? Usage: grep -hblcnsviw pattern file . . . (8 Replies)
Discussion started by: mohtashims
8 Replies

10. Shell Programming and Scripting

How to awk or grep the last column in file when date on column contains spaces?

Hi have a large spreadsheet which has 4 columns APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96034 Storage Mgmt Team APM00111803814 server_2 96152 GWP... (6 Replies)
Discussion started by: kieranfoley
6 Replies

LEARN ABOUT DEBIAN

isi2bib

ISI2BIB(1)																ISI2BIB(1)

NAME

       isi2bib - script to convert ISI format files to BibTeX format files

SYNOPSIS

       isi2bib <input.isi> <output.bib>

DESCRIPTION

       isi2bib	is a script to convert an ISI-format file into a PDF file. The conversion is a two step process: the ISI-format file is first con-
       verted into an XML-format file; that XML-format file is in turn converted into the BibTeX-format file (both utilities are  shipped  in  the
       bibutils package).

       This script is part of the cb2bib package and is located at /usr/share/cb2bib/c2btools/isi2bib.

BIBLIOGRAPHICAL REFERENCES TO BE CITED

       P. Constans (2009) "A simple extraction procedure for bibliographical author field", arXiv:0902.0755.

       P. Constans (2007) "Approximate textual retrieval", arXiv:0705.0751.

SEE ALSO

       cb2bib(1), med2bib(1), bib2pdf(1), ris2bib(1)

AUTHORS

       Pere Constans <constans@molspaces.com> and Filippo Rusconi <rusconi-debian@laposte.net>
	   Program authors.

       Filippo Rusconi <rusconi-debian@laposte.net>
	   Man-page author for the Debian distribution.

COPYRIGHT

       Copyright (C) 2004-2008 Pere Constans  Copyright (C) 2009 Filippo Rusconi

       This manual page was written for the Debian system (but may be used by others).

       Permission  is  granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 3 or (at
       your option) any later version published by the Free Software Foundation. On a Debian system the complete text of the  GNU  General  Public
       License version 3 can be found in the file `/usr/share/common-licenses/GPL-3'.

								  September 2009							ISI2BIB(1)
All times are GMT -4. The time now is 06:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy