Find and Replace in multiple fields using awk Post: 302601790

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I read/find/replace fields in a csv datafile?

hello. I'm somewhat a novice here so please be patient. My stumbling block when loading csvs into ORACLE tables is this: I need to read a csv datafile, check several fields in each line, and if any of stated fields contain A ZERO only then replace it with a null/blank character. I had a...

2. Shell Programming and Scripting

awk find and replace in multiple files

Hi I use the following code to replace �.' with �N' in my files and keep both versions. awk '{ gsub(/\./,"N"); print }' file_0001.txt > path/to/new/dir/file_0001.txt I need help on how to apply the code to 100 files instead of doing them one file at a time. The files are labeled...

3. Shell Programming and Scripting

AWK multiple fields separators

I need to print the second field of a file, taking spaces, tab and = as field separators. ; for 16-bit app support MAPI=1 CMC=1 CMCDLLNAME32=mapi32.dll CMCDLLNAME=mapi.dll MAPIX=1 MAPIXVER=1.0.0.1 OLEMessaging=1 asf=MPEGVideo asx=MPEGVideo ivf=MPEGVideo m3u=MPEGVideo

4. Shell Programming and Scripting

help with search and replace in multiple fields

I have a pipe delimited file with 27 fields. Each record has 26 fields. I need to search for the 25,26,27 fields and replace "," with nothing. How can I acheive this. Sed is more preferred. e.g data row o/p

5. Shell Programming and Scripting

AWK: merge two files and replace some fields

Need some code tweak: awk 'END { for (i=1; i<=n; i++) if (f2]) print f2] } NR == FNR { f2 = $1] = $0 next } $1 in f2 { delete f2 }1' FS=, OFS=, 2.csv 1.csv > 3.csvfile 1.csv have: $1,$2,$3,$4,$5,$6,$7,$8,$9...... file 2.csv have: $1,$2,$3,$4,$5,$6

6. Shell Programming and Scripting

Script to find & replace a multiple lines string across multiple php files and subdirectories

Hey guys. I know pratically 0 about Linux, so could anyone please give me instructions on how to accomplish this ? The distro is RedHat 4.1.2 and i need to find and replace a multiple lines string in several php files across subdirectories. So lets say im at root/dir1/dir2/ , when i execute...

7. Shell Programming and Scripting

awk gsub multiple fields

Hi, I am trying to execute this line awk -F ";" -v OFS=";" '{gsub(/\./,",",$6); print}' FILE but for multiple fields $6 $7 $8 Do you have a suggstion? Tried: awk -F ";" -v OFS="";"" "function GSUB( F ) {gsub(/\./,\",\",$F); print} { GSUB( 6 ); GSUB( 7 ); GSUB( 8 ) } 1"...

8. Shell Programming and Scripting

Find fields and replace using awk

Code: Using ksh Var1=`awk -F";" {print $1}' Input2.txt` cat Input1.txt | awk -F";" '{$3="Var1"}' > Output.txt

9. Shell Programming and Scripting

Replace 0 with 1 in multiple fields with awk

Hello, I have the following input file: 1 3 3 2 3 3 4 0 4 0 5 4 5 2 2 0 5 3 4 0 6 0 3 2 I am trying to remove all zeroes in fields 2 and 4 and replace them with "1's" I tried the following, but it's not working awk -F"\t" '{ if (($2==0) || ($4==0) $2=1; $4=1; print $0 ) }' input ...

10. Shell Programming and Scripting

Print multiple fields with awk

so its common knowledge one can print multiple fields with simple commands like this: echo 12 44 45 552 24 | awk '{print $1,$4,$3}' but suppose i want to avoid specifying the "$" symbol. is that possible? can something like this be done: echo 12 44 45 552 24 | awk '{print $(1,4,3)}' ...

LEARN ABOUT SUSE

getutmp

GETUTMP(3)						     Linux Programmer's Manual							GETUTMP(3)

NAME

       getutmp, getutmpx - copy utmp structure to utmpx, and vice versa

SYNOPSIS

       #define _GNU_SOURCE
       #include <utmpx.h>

	void getutmp(const struct utmpx *ux, struct utmp *u);
	void getutmpx(const struct utmp *u, struct utmpx *ux);

DESCRIPTION

       The  getutmp() function copies the fields of the utmpx structure pointed to by ux to the corresponding fields of the utmp structure pointed
       to by u.  The getutmpx() function performs the converse operation.

RETURN VALUE

       These functions do not return a value.

VERSIONS

       These functions first appeared in glibc in version 2.1.1.

CONFORMING TO

       These functions are nonstandard, but appear on a few other systems, such as Solaris and NetBSD.

NOTES

       These functions exist primarily for compatibility with other systems where the utmp and utmpx structures contain different fields,  or  the
       size of corresponding fields differs.  On Linux, the two structures contain the same fields, and the fields have the same sizes.

SEE ALSO

       getutent(3), utmp(5)

COLOPHON

       This  page is part of release 3.25 of the Linux man-pages project.  A description of the project, and information about reporting bugs, can
       be found at http://www.kernel.org/doc/man-pages/.

Linux								    2008-07-02								GETUTMP(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I read/find/replace fields in a csv datafile?

Discussion started by: MrCarter

2. Shell Programming and Scripting

awk find and replace in multiple files

Discussion started by: jdhahbi

3. Shell Programming and Scripting

AWK multiple fields separators

Discussion started by: PamPam

4. Shell Programming and Scripting

help with search and replace in multiple fields

Discussion started by: dsravan