06-28-2007
Filter data from text file
Hi All
We have got a text file, which has data dumped from 60 tables.
From these 60 tables of data we need data from 4 tables only.
I tried assigning line numbers to filter out data, but it is not working as intended.
below is the sample file
----Table1-----
3,dfs,43,df
4,sd,5,edd
56,df,6,fgdg
---Table2---
54,fdgfg,fgdfg
65,dgdfg,yuytr
76,tyuuu,ytur
---Table3----
98,rere,78
87,gdg,87
45,hgff,98
---Table4---
sdfsd,tyut,676
ffsdf,ggfd,879
ghgf,iyuty,877
Say from the file, i need to filter out data for Table2 and Table 3 only ...
Can any suggest a solution for this ..
Thanks in Advance
Sri....
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a data file:
abc Text Text Text Unique Text
123 Text word Line Unique Text
fgh Text data Line Unique Text
789 Text Text Line Unique Text
543 Text Text Data Unique Text
and a filter file
123
789
I want to extract out from the data file the two records that contain the keys... (1 Reply)
Discussion started by: tumblez
1 Replies
2. Shell Programming and Scripting
hi all,
I have this file with some user data.
example:
$cat myfile.txt
FName|LName|Gender|Company|Branch|Bday|Salary|Age
aaaa|bbbb|male|cccc|dddd|19900814|15000|20|
eeee|asdg|male|gggg|ksgu|19911216|||
aara|bdbm|male|kkkk|acke|19931018||23|
asad|kfjg|male|kkkc|gkgg|19921213|14000|24|... (4 Replies)
Discussion started by: srimal
4 Replies
3. UNIX for Advanced & Expert Users
i have file server 1 (filesvr01acess.log) and disc server 1 (discsvr01acess.log) in unix box(say ip adress of the box 10.39.66.81)
Similiarly i have file server 2 (filesvr01acess.log) and disc server 2(discsvr01acess.log) in another unix box(say ip adress of the box 10.39.66.82).
Now my... (1 Reply)
Discussion started by: nripa1
1 Replies
4. Shell Programming and Scripting
Hi All ,
I have one file like below ,
Owner name = abu2-kxy-m29.hegen.app
Item_id = AX1981, special_id = *NULL*, version = 1
Created = 09/01/2010 12:56:56 (1283389016)
Enddate = 03/31/2011 00:00:00 (1301554800)
From the above file I need to get the output in the below format ,i need... (3 Replies)
Discussion started by: gnanasekar_beem
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a file with hundreds of records.
There are four fields on each line, separated by semicolons.
Name
Height (meters)
Country
Continent (Africa,Asia,Europe,North America,Oceania,South
America,The Poles)
I need to Write the command to find display how many mountains appear... (1 Reply)
Discussion started by: erora
1 Replies
6. Shell Programming and Scripting
I have a .kml file. So I want filter the .kml to get only the tags that have this numeric codes that they are in a text file
11951
11952
74014
11964
11965
11969
11970
11971
11972
60149
74018
74023
86378
11976
11980
11983
11984
11987 (5 Replies)
Discussion started by: pcoj33
5 Replies
7. Shell Programming and Scripting
Hi...
I would like to filter out my data file....in two different way
1st way is like this, I will take one example..here...
The script should ask like this.
Enter min value in first column
Enter max value in first column
Enter min value in second column
Enter max value in... (5 Replies)
Discussion started by: nex_asp
5 Replies
8. UNIX for Dummies Questions & Answers
Hello,
I am very now to this, hope you can help,
I am looking into editing a file in Solaris, with dinamic collums (lenght varies) and I need 2 things to be made, the fist is to filter the first column and third column from the file bellow file.txt, and create a new file with the 2 filtered... (8 Replies)
Discussion started by: jpbastos
8 Replies
9. UNIX for Dummies Questions & Answers
sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies
10. UNIX for Dummies Questions & Answers
Hi Folks,
I have a text file with lots of rows with duplicates in the first column, i want to filter out records based on filter columns in a different filter text file.
bash scripting is what i need.
Data.txt
Name OrderID Quantity
Sam 123 300
Jay 342 498
Kev 78 2500
Sam 420 50
Vic 10... (3 Replies)
Discussion started by: tech_frk
3 Replies
LEARN ABOUT DEBIAN
paracode
PARACODE(1) General Commands Manual PARACODE(1)
NAME
paracode - command line Unicode conversion tool
SYNOPSIS
paracode [-ttables] string
DESCRIPTION
This manual page documents the paracode command.
paracode exploits the full power of the Unicode standard to convert the text into visually similar stream of glyphs, while using completely
different codepoints. It is an excellent didactic tool demonstrating the principles and advanced use of the Unicode standard.
paracode is a command line tool working as a filter, reading standard input in UTF-8 encoding and writing to standard output.
OPTIONS
-ttables
--tables
Use given list of conversion tables, separated by a plus sign.
Special name 'all' selects all the tables.
Note that selecting 'other', 'cyrillic_plus' and 'cherokee' tables (and 'all') makes use of rather esoteric characters, and not all
fonts contain them.
Special table 'mirror' uses quite different character substitution, is not selected automatically with 'all' and does not work well
with anything except plain ascii alphabetical characters.
Example:
paracode -t cyrillic+greek+cherokee
paracode -t cherokee <input >output
paracode -r -t mirror <input >output
Possible tables are:
cyrillic
cyrillic_plus
greek
other
cherokee
all
-r
Display text in reverse order after conversion, best used together with -t mirror.
SEE ALSO
iconv(1)
AUTHOR
Radovan Garabik <garabik @ kassiopeia.juls.savba.sk>
2005-04-16 PARACODE(1)