awk to replace part of a column Post: 302679523

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex...

2. Shell Programming and Scripting

Replace part of a line with sed/awk

Hello I have a document and in this document I have several occurrence of "VAR == xxxxxxx" and xxxxx can be anything. I don't know what it is. I want to replace the 'xxxxx's with something I know. What I know however, is the line numbers of the VAR =='s in the file. How can I replace...

3. Shell Programming and Scripting

Changing part of column value with AWK

Hi All , Here is my req I am extracting a column value and I want to change part of its value according to user input Say the column I extracted is of 15 digits and I want to change the 11th to 14th position with user input 4 digit value Example column value 111111111111111 user input...

4. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2

5. Shell Programming and Scripting

awk compare column n replace with in one file

hi Friends need to compare columns in one file where the data looks like below laptop,IBM phone,samsung car,rental user1,laptop user2,laptop user3,phone want to get output as laptop,IBM phone,samsung car,rental user1,IBM user2,IBM user3,samsung need to seach $2 in array of $1 and...

6. Shell Programming and Scripting

How to Replace the value of a column using awk command?

Hi cat test.txt H|123|341|567|asfg D|dfg|trtyy|errt D|ert|frty|wer Here I need to replace the third column value with 100 of the first record only and while printing I need to print the full file content also..I am expecting a result like this H|123|100|567|asfg D|dfg|trtyy|errt...

7. Shell Programming and Scripting

Use grep/awk to remove part of column

hi all, how can i use grep or awk to clean the following input data: n<>the<>96427210 861521305 123257583 n<>obj<>79634223 861521305 79634223 n<>nmod<>68404733 861521305 68422718 where the desired results is to remove all non-numeric characters?: 96427210 861521305 123257583 ...

8. Shell Programming and Scripting

Grep/awk part of info of a column

I have a question that I am at a loss to solve. I have 3 column tab-separated data, such as: abs nmod+n+n-commitment-n 349.200023 abs nmod+n+n-a-commitment-n 333.306429 abs into+ns-j+vn-pass-rb-divide-v 295.57316 abs nmod+n+ns-commitment-n 182.085018 abs nmod+n+n-pledge-n ...

9. Shell Programming and Scripting

awk Match First Field and Replace Second Column

Hi Friends, I have looked around the forums and over online but couldn't figure out how to deal with this problem input.txt gene1,axis1/0/1,axis2/0/1 gene1,axis1/1/2,axis2/1/2 gene1,axis1/2/3,axis2/2/3 gene2,axis1/3/4,axis2/3/4 Match on first column and if first column is...

10. UNIX for Beginners Questions & Answers

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

I have a csv which has lot of columns . I was looking for an awk script which would extract a column twice. for the first occurance the header and data needs to be intact but for the second occurance i want to replace the header name since it a duplicate and extract year value which is in ddmmyy...

LEARN ABOUT CENTOS

iok

IOK(1)							      General Commands Manual							    IOK(1)

NAME

       iok- Indic Onscreen Keyboard

SYNOPSIS

       iok [-a] [-h] [-d 1] [-n LANGCODE]

DESCRIPTION

	   Indic  Onscreen  Keyboard  currently shows Inscript and Inscript2 keymaps for 22 official Indian languages. The languages are Assamese,
       Bengali, Bodo, Dogri, Gujarati, Hindi, Kannada, Kokani, Maithili, Malayalam, Manipuri, Marathi, Nepali, Oriya, Punjabi, Sanskrit,  Santali,
       Sindhi, Tamil, Telugu.
	   The	iok  application runs in default and advanced mode. In default mode, iok starts by loading Inscript2 keymap of the current locale.
       If keymap is not installed or available then iok shows keymap list in the default mode. User can then select any keymap from keymap list if
       he want to write using it.
	    In the advanced mode, iok allows to open non-supported keymaps. If keymap can be parsed by iok then it will be showed in iok UI other-
       wise it will show error message that iok can't load this keymap. Advanced mode also allows to create custom keymap by  either  swapping	or
       re-assigning character mappings in the existing loaded keymap in iok.
	    Another feature iok supports is Drag and Drop. This will allow user to swap character mappings using mouse.
	    The keymap list shows Inscript and Inscript2 keymaps from location /usr/share/m17n and ~/.m17n.d path.

       To start iok in normal mode from console, use following command iok

       To start iok in advanced mode from console, use following command iok -a

       To start iok in any supported Inscript2 keymap (say in Marathi) use following command iok -n mr

       As  Inscript2  keymap  naming  also uses language script code for some languages, command to open those keymaps is like this iok -n pa-guru
       where pa is a isocode name for the Punjabi language and guru is a language script code name in which keymap is written.

       To use Drag and Drop feature of iok, start iok from console as  iok  -d	1  The	Draft  version	of  Inscript2  keymaps	are  available	at
       https://fedorahosted.org/inscript2/

       This project is available at http://fedorahosted.org/iok/ or http://iok.sourceforge.net

OPTIONS

       -a     It shows the menus and combo box in iok UI

       -h     It show the help

       -d 1   This will enable Drag and Drop feature only for the single iok invocation. Otherwise iok has disabled Drag and Drop by default.

       -n LANGCODE
	      In  the place of LANGCODE,you need to specify a particular language code.  Shows iok UI for that particular language. This will also
	      requires language script	code.  e.g. for Bodo, Dogri, Kokani, Nepali, Sindhi use its langcode and  "-deva"  as  a  language  script
	      code.

	      To start iok using Kokani keymap, run "iok -n kok-deva"

AUTHOR

       Suji A <suji87.msc@gmail.com> , Parag <pnemade@fedoraproject.org>

								  March 12, 2012							    IOK(1)