Sponsored Content
Full Discussion: column handling in awk
Top Forums Shell Programming and Scripting column handling in awk Post 302245445 by Mish_99 on Friday 10th of October 2008 06:34:55 AM
Old 10-10-2008
Hi, Osrry for that hope this helps clarify issues

Code:
File 1
1
2
3
4
5
6

Code:
File 2
 9    66 8  a
 8    3  9  b
 66   4  25 c
 66   2  6  d 
 4    3  3  e
 4    5  45 f

Code:
output
  1    66 8  a
  2    3  9  b
  3    4  25 c
  4    2  6  d 
  5    3  3  e
  6    5  45 f

kindest regards


Mish
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK handling of single quote

Hi, Can someone let me know how I can acheive the following. I have ~ delimited file and I need to convert into something like SQL insert statements. SrcFile : 1~sjdsdj~asasas~ 2~aaaaa~qwqwqwq~qwq ..... I tried AWK -F"~" '{print "INSERT INTO XX VALUES("$1 " ,\' "$2" \' , \' "$3 }'... (3 Replies)
Discussion started by: braindrain
3 Replies

2. Shell Programming and Scripting

Handling regular expressions in awk

Script is: accept filename as argument(also handle CTRL+C).to check whether th file exist in the current directory,it it then using awk find the employees who are either born in 1990 or drawing a salary greater than 25000. In my database file 1st field is of id ,2nd field is name,5th field is of... (5 Replies)
Discussion started by: Priyanka Bhati
5 Replies

3. UNIX for Dummies Questions & Answers

Sum up a decimal column in a tab separated text file and error handling

Hi, I have a small requirement where i need to sum up a column in a text file. Input file 66ab 000000 534385 -00000106350.00 66cd 000000 534485 -00013364511.00 66ad 000000 534485 -00000426548.00 672a 000000 534485 000000650339.82... (5 Replies)
Discussion started by: pssandeep
5 Replies

4. Shell Programming and Scripting

handling arrays with awk

Hi, I have an issue that I am trying to resolve using arrays in awk. I have two files, the first one is a dictionary with this format: FILE 1 (dictionary) 'Abrir' 'Open' 'Aceptar' 'Accept' Every line has two fields, a word in two languages. The second file is a simple list of... (3 Replies)
Discussion started by: gmartinez
3 Replies

5. UNIX for Advanced & Expert Users

awk function in handling quotes

Hi all, I have input lines like below empno,ename,sal,description ---------------------------- 311,"jone,abc",2000,manager 301,david,200,"president,ac" I need to sum the salary of them i.e. 2000+200 anything suggested Thanks, Shahnaz. Use code tags. (5 Replies)
Discussion started by: shahnazurs
5 Replies

6. Shell Programming and Scripting

Data handling using AWK

Hi, I have requirement to fetch lines with a particular character in one column e.g. 2.5M asdsad 3.5M sadsadas 12323M ssdss i tried following so far #echo 2.3M asdsad | nawk -F " " '{print substr($1,length($1))}' M So far i have tried following # echo 2.3M asdsad | nawk... (4 Replies)
Discussion started by: mtomar
4 Replies

7. Shell Programming and Scripting

handling asterix in AWK

I have a file like below. colA^col2^col3^col4^col5 aa^11^aaa^a1a^111^aa* bb*^22^bbb*^bb2^222^bb cc^33^ccc*^3cc^333^ccc dd^44^d*dd*^d4d^444^ddd ee^55^e*ee^e5e*^555^e*e NOTE: '^' is the field separator. I need to get the output as colA^col2^col3^col4^col5 aa^11^aaa^a1a^111^aa... (5 Replies)
Discussion started by: rinku11
5 Replies

8. UNIX for Dummies Questions & Answers

Awk - Handling different types of newlines

Hi. We have some data that's generated from a webpage. Part is pretty well-formatted, but part of it preserves newlines in a way that breaks the record separating in awk. Here's 2 records, filtered through cat -e: Jones,Bob,20,Q: What is your favorite ice cream?$ A: Butter Pecan$ Q: Do you... (6 Replies)
Discussion started by: treesloth
6 Replies

9. Shell Programming and Scripting

Handling 2 files simultaneously with awk

Hello, Is it possible to handle data from two different files at once in awk (latest version and platform is Fedora). I found on the net that we cannot nest awk. My requirement is that I have two similar files : File 1: Name: abc Val = 58 Name: cdf Val = 1; .................. File... (7 Replies)
Discussion started by: fifteate
7 Replies

10. Shell Programming and Scripting

Handling embedded double quotes within column data

I have a text file where each field is enclosed in double quotes and separated by a comma. But in certain rows we have embedded double quotes within column data For e.g """TRUSPICE CENTRE"" CLAYTON AU" The above value is for a single column but there are embedded quotes within... (2 Replies)
Discussion started by: abhilashnair
2 Replies
TEXIFY(1)						      General Commands Manual							 TEXIFY(1)

NAME
texify - format code for use with LaTeX SYNOPSIS
texify<input-type> [OPTION]... DESCRIPTION
texify translates source code written in any of several different languages to latex(1) source files. The purpose is to make source code embedded in documents more readable, by providing syntax highliting. OPTIONS
-i FILE Read from FILE instead of standard input. -o FILE Write to FILE instead of standard output. -l LENGTH Limit line length to LENGTH. -t LENGTH Make a tab correspond to LENGTH spaces. Default is 6. -num INTERVAL Prefix output lines with the corresponding line number from the input, skipping INTERVAL lines between each time a prefix is added. An interval of 1 will ensure that every line is prefixed. -numsize exsize Replace the TeX code used to set the size of the line numbers. The default is footnotesize. INPUT TYPES
abel ABEL source code ada Ada source code asm Assembly code axiom AXIOM code B B source code beta BETA source code bison Bison source code c C source code c++ C++ source code idl OMG/CORBA IDL source code java Java source code lex Lex source code lisp LISP source code logla LOGLA source code matlab MATLAB script ml ML source code perl Perl source code promela Promela source code python Python source code scheme Scheme soruce code sim SIMULA source code sql SQL queries ruby Ruby source code vhdl VHDL description This manual page was written for the Debian operating system because the original program does not have a manual page. EXAMPLES
Say you want to format a Java source file. Just type: texifyjava < input.java > output.tex You can also format the output of some program without storing its output in a temporary file. If you want to format the output of a Post- greSQL database dump, just type: pg_dump foobar | texifysql > output.tex AUTHOR
This manual page was written by Morten Hustveit <morten@debian.org>. January 2003 TEXIFY(1)
All times are GMT -4. The time now is 03:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy