|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Printing another column using awk and input data
Post 302640393 by bartus11 on Monday 14th of May 2012 05:18:55 PM
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I'm hoping someone can help me on this. I have a data file that greatly simplified might look like this:
sec;src;dst;proto
421;10.10.10.1;10.10.10.2;tcp
426;10.10.10.3;10.10.10.4;udp
442;10.10.10.5;10.10.10.6;tcp
sec;src;fac;dst;proto
521;10.10.10.1;ab;10.10.10.2;tcp... (3 Replies)
Discussion started by: eric4
3 Replies
2. Shell Programming and Scripting
I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this).
For example, i have a input file1.txt:
cat inputfile1.txt
218299910417
1172051195
1172070231
1172073514
1183135117
1183135118
1183135119
1281440202
... (3 Replies)
Discussion started by: poliver
3 Replies
3. Shell Programming and Scripting
nawk -F "|" 'FNR==NR {a=$2 OFS $3 OFS $4 OFS $5 OFS $6;next}\
{if ($5 in a)print $1,"test",$5,a, $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 ; \
else print $1,"Database",$5 OFS OFS OFS OFS OFS OFS $2,$3,$4 OFS OFS OFS OFS OFS OFS OFS OFS $2-$3-$4 }' OFS="|" \
file1 file2 > file3
This... (5 Replies)
Discussion started by: pinnacle
5 Replies
4. Shell Programming and Scripting
I want to print the 1st field in a comma seperated file to lower case and the rest the case they are.
I tried this
nawk -F"," '{print tolower($0)}' OFS="," file
this converts whole line in to lower case i just want the first column to be converted.
The below doesnt work because in... (11 Replies)
Discussion started by: pinnacle
11 Replies
5. Shell Programming and Scripting
Hi everyone,
Ok here's the scenario.
I have a control file like this.
component1,file1,file2,file3,file4,file5
component2,file1,file2,file3,file4,file5I want to do a while loop here to read all files for each component.
file_count=2
while ]
do
file_name=`cat list.txt | grep... (2 Replies)
Discussion started by: The Gamemaster
2 Replies
6. Shell Programming and Scripting
I was trying to simplify this from what I'm actually doing, but I started getting even more confused so I gave up. Here is the content of my input file:
Academic year,Term,Course name,Period,Last name,Nickname
2012-2013,First Semester,English 12,7th Period,Davis,Lucille
When I do this:
... (3 Replies)
Discussion started by: nextyoyoma
3 Replies
7. Shell Programming and Scripting
Experts,
i have a following file containing data in following manner.
1 2480434.4 885618.6 0.00 1948.00
40.00 1952.00
... (6 Replies)
Discussion started by: Amit.saini333
6 Replies
8. Open Source
I have a process that requires me to read data from huge log files and find the most recent entry on a per-user basis. The number of users may fluctuate wildly month to month, so I can't code for it with names or a set number of variables to capture the data, and the files are large so I don't... (7 Replies)
Discussion started by: rbatte1
7 Replies
9. Shell Programming and Scripting
Hello:
I've input data:
Input data
--- 3:60069:C:T 60069 C T 1 0 0 1 0 0 1 0 0 1 0 0 1
--- 3:60079:A:G 60079 A G 1 0 0 0.988 0.012 0 1 0 0 1 0 0 1
--- rs186476240:60157:G:A 60157 G A 1 0 0 1 0 0 1 0 0 1 0 0 1
I edit/make first few columns before numbers (6th column) and want to... (4 Replies)
Discussion started by: genome
4 Replies
10. UNIX for Beginners Questions & Answers
In the f1 file below I am trying to clean it up removing lines the have _tn_ in them. Next, removing the characters in $2 before the ninth /. Then I remove the ID_(digit- always 4). Finally, the charcters after and including the first _. It is curently doing most of it but the cut is removing $1... (5 Replies)
Discussion started by: cmccabe
5 Replies
LEARN ABOUT OPENSOLARIS
iconv_maz
iconv_maz(5) Standards, Environments, and Macros iconv_maz(5) NAME
iconv_maz - code set conversion tables for Mazovia DESCRIPTION
The following code set conversions are supported: +--------------------------------------------------------------------+ | Code Set Conversions Supported | +--------------+--------+--------------+--------+--------------------+ | Code |Symbol |Target Code |Symbol | Target | +--------------+--------+--------------+--------+--------------------+ |Output | | | | | +--------------+--------+--------------+--------+--------------------+ |Mazovia |maz |ISO 8859-2 |iso2 | ISO Latin 2 | +--------------+--------+--------------+--------+--------------------+ |Mazovia |maz |MS 1250 |win2 | Windows Latin 2 | +--------------+--------+--------------+--------+--------------------+ |Mazovia |maz |MS 852 |dos2 | MS-DOS Latin 2 | +--------------+--------+--------------+--------+--------------------+ |Mazovia |maz |DHN |dhn | Dom Hanlowy Nauki | +--------------+--------+--------------+--------+--------------------+ CONVERSIONS
The conversions are performed according to the following tables. All values in the tables are given in octal. Mazovia to ISO 8859-2 For the conversion of Mazovia to ISO 8859-2, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | Mazovia | ISO 8859-2 | Mazovia | ISO 8859-2 | |24-177 | 40 |230 |246 | |200 | 307 |231 |326 | |201 | 374 |232 |334 | |202 | 351 |233 |40 | |203 | 342 |234 |243 | |204 | 344 |235 |40 | |205 | 40 |236 |266 | |206 | 261 |237 |40 | |207 | 347 |240 |254 | |210 | 40 |241 |257 | |211 | 353 |242 |363 | |212-213 | 40 |243 |323 | |214 | 356 |244 |361 | |215 | 346 |245 |321 | |216 | 304 |246 |274 | |217 | 241 |247 |277 | |220 | 312 |250-340 |40 | |221 | 352 |341 |337 | |222 | 263 |342-365 |40 | |223 | 364 |366 |367 | |224 | 366 |367 |40 | |225 | 306 |370 |260 | |226-227 | 40 |371-376 |40 | |256 | 201 | | | +---------------+----------------+----------------+---------------+ Mazovia to MS 1250 For the conversion of Mazovia to MS 1250, all characters not in the following table are mapped unchanged. +---------------+----------------+----------------+---------------+ | Mazovia | MS 1250 | Mazovia | MS 1250 | |200 | 307 |236 |234 | |201 | 374 |237 |40 | |202 | 351 |240 |217 | |203 | 342 |241 |257 | |204 | 344 |242 |363 | |205 | 40 |243 |323 | |206 | 271 |244 |361 | |207 | 347 |245 |321 | |210 | 40 |246 |237 | |211 | 353 |247 |277 | |212-213 | 40 |250-251 |40 | |214 | 356 |252 |254 | |215 | 346 |253-255 |40 | |216 | 304 |256 |253 | |217 | 245 |257 |273 | |220 | 312 |260-340 |40 | |221 | 352 |341 |337 | |222 | 263 |342-345 |40 | |223 | 364 |346 |265 | |224 | 366 |347-360 |40 | |225 | 306 |361 |261 | |226-227 | 40 |362-365 |0 | |230 | 214 |366 |367 | |231 | 326 |367 |40 | |232 | 334 |370 |260 | |233 | 40 |371 |40 | |234 | 243 |372 |267 | |235 | 40 |373-376 |40 | |274 | 212 | | | +---------------+----------------+----------------+---------------+ Mazovia to MS 852 For the conversion of Mazovia to MS 852, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | Mazovia | MS 852 | Mazovia | MS 852 | |205 | 40 |234 |235 | |206 | 245 |235 |40 | |210-213 | 40 |236 |230 | |215 | 206 |237 |40 | |217 | 244 |240 |215 | |220 | 250 |241 |275 | |221 | 251 |243 |340 | |222 | 210 |244 |344 | |225 | 217 |245 |343 | |226-227 | 40 |246 |253 | |230 | 227 |247 |276 | |233 | 40 |250-375 |40 | |227 | 327 | | | +---------------+----------------+----------------+---------------+ Mazovia to DHN For the conversion of Mazovia to DHN, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | Mazovia | DHN | Mazovia | DHN | |200-205 | 40 |234 |203 | |206 | 211 |236 |217 | |207-214 | 40 |240 |207 | |215 | 212 |241 |210 | |216 | 40 |242 |216 | |217 | 200 |243 |205 | |220 | 202 |244 |215 | |221 | 214 |246 |220 | |225 | 201 |247 |221 | |230 | 206 | | | +---------------+----------------+----------------+---------------+ FILES
/usr/lib/iconv/*.so conversion modules /usr/lib/iconv/*.t conversion tables /usr/lib/iconv/iconv_data list of conversions supported by conversion tables SEE ALSO
iconv(1), iconv(3C), iconv(5) SunOS 5.10 18 Apr 1997 iconv_maz(5)