I've got the following data in a file - basically hundred of passes.
Code:
Pass Id : PASSID1
Pass Name : 7 day pass 10 Gb
Pass Group : uk
Short Name : pmbbrh2
type : restrict
Validity : 168 hours
Pass Id : BBFFF009
Pass Name : World pass 24hr
Pass Group : World
Short Name : CsRHhh3
type : block
Validity : 24 hours
What id like is something like the following.
Code:
Pass Id Pass Name Pass Group Short Name type Validity
PASSID1 7 day pass 1 Gb uk pmbbrh2 restrict 168 hours
BBFFF009 World pass 24hr EU CsRHhh3 block 24 hours
I know this is something simple, but it actually hurts my mind trying to solve it. I cant use grep or awk or sed for this. any other ideas ?
The data in the first column is the same throughout the file but the data in the second column is sometimes the same.
Thanks in advanced
Jeffers
Last edited by vgersh99; 03-26-2010 at 04:07 PM..
Reason: code tags, please!
Hi all,
I have created a script which adding two columns and removing two columns for all files.
Filename: Cust_information_1200_201010.txt
Source Data:
"1","Cust information","123","106001","street","1-203 high street"
"1","Cust information","124","105001","street","1-203 high street"
... (0 Replies)
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Hello everyone,
I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble.
I have many files each having two columns and hundreds of rows.
first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Hi friends
please help me on below,
i have 5 files like below
file1 is
x 10
y 20
z 15
file2 is
x 100
z 245
file3 is
y 78
z 23
file4 is
x 100 (3 Replies)
hi all,
i have a file like thsi
a 1 3;4
b 2 4;7
c 4 5;6
d 4 5;8
now i want 1st, 2nd and in 3rd column i want only 1st column
the output should be like below
a 1 3
b 2 4
c 4 5
d 4 5
I need it in perl; please dont write in Shell scripting (1 Reply)
Hi,
I have a requirement.for eg: i have a text file with pipe symbol as delimiter(|) with 4 columns a,b,c,d. Here a and b are primary key columns..
i want to process that file to find the duplicates and null values are in primary key columns(a,b) . I want to write the unique records in which... (5 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
HI All,
I'm embedding SQL query in Script which gives following output:
Assignee Group Total
ABC Group1 17
PQR Group2 5
PQR Group3 6
XYZ Group1 10
XYZ Group3 5
I have saved the above output in a file.
How do i sum up the contents of this output so as to get following output:
... (4 Replies)
Hi,
We have a requirement like, to check the datatypes of columns against database.
After loading the sample data in to one of the database, need to compare the datatypes of the columns are matching with the provided files.
Is there a way that we can achieve through shell scripting.
We... (7 Replies)
Discussion started by: Samah
7 Replies
LEARN ABOUT DEBIAN
wml::std::tags
wml::std::tags(3) EN Tools wml::std::tags(3)NAME
wml::std::tags - Standard Support Tags
SYNOPSIS
#use wml::std::tags
# Pass 2: advanced if constructs
<ifdef varname thenval elseval>
# Pass 3: support tag
<perl> ... </perl>
<say> ... </say>
# Pass 4: support tag
<m4> ... </m4>
# Pass 4: symbols
<symbol name value>
<symbol name undef>
# Pass 5: diversions
<dump NAME>
<enter NAME> ... <leave>
<divert NAME> ... </divert>
# Pass 6: support tag
<asubst ...> ... </asubst>
# Client-Side JavaScript: support tag
<javascript [version=..] [language=..]
[type=..] [src=...] [defer] [nohead] [nolang]>
...
</javascript>
# Resynchronize line numbers for more accurate pass 3 warnings
<sync-lines>
DESCRIPTION
This include file defines some standard support tags one needs all the time. All tags are self-explanatory and briefly mentioned in
wml_intro(1), except the last two which are described below.
"<javascript>":
This tag was primarily a shorthand for "<script type="text/javascript" language="JavaScript">" but it has evolved. If the "<head>" tag is
defined and is a complex macro, e.g. when calling "wml::std::page", then Javascript code is automatically passed to this macro and should
be diverted to the HEAD section of HTML documents. This diversion preserve lang slices in multi-lingual documents. Those features may be
disabled by the ``nohead'' and ``nolang'' attributes.
"<sync-lines>":
WML tries to print information on input file and line numbers when warnings or errors are reported in passes 2 and 3. Some special
sentences containing file names and line numbers are inserted during pass 1. So pass 2 have an accurate knowledge of where warnings appear
in input file. But it also filters it without preserving lines, so after pass 2 information is almost unusable. By putting "<sync-lines>"
in input file, it forces pass 2 to resynchronize information on line numbers. So for debugging pass 3, it could be of some help to insert
"<sync-lines>" before ePerl code.
AUTHORS
Ralf S. Engelschall
rse@engelschall.com
www.engelschall.com
Denis Barbier
barbier@engelschall.com
REQUIRES
Internal: P1, P2, P3, P4, P6
External: --
SEE ALSO wml(1)EN Tools 2014-04-16 wml::std::tags(3)