10-29-2010
awk help - delimited file
Hi,
I have a delimited file with 10 fields. I have to replace a character in field 1 and field 5. It is possible to do using awk where i can read a row at a time field by field and if the field value is 1 or 5 then i will replace the character.
But this operation is cumbersome since the file size is huge and if the columns are more than 100.
Is there an option where i can do the operation on the field without looping through every field ie Directly act on the field 1 and field 5 without reading all the other field values as in my previous case.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
2. Shell Programming and Scripting
Hi all, I need help to split a tab-delimited list into separate files by the filename-field. The list is already sorted ascendingly by filename, an example list would look like this;
filename001 word1 word2
filename001 word3 word4
filename002 word1 word2
filename002 word3 word4... (4 Replies)
Discussion started by: perkele
4 Replies
3. Shell Programming and Scripting
I've got a semicolon delimited file. I would like to search for fields that match a pattern, and not hardcoded eg "mth".
*th=something
If the delimited field fulfills this condition, eg. mth=value
I would like to print out both key and value for some number comparison.
eg. if value > "12"... (5 Replies)
Discussion started by: alienated
5 Replies
4. Shell Programming and Scripting
using awk to substitute data in a column delimited text file
hello i would like to use awk to do the following calculation from the following snippet.
input file
C;2390 ;CV BOUILLOTTE 2L 2FACES NERVUREES ;1.00 ;3552612239004;13417 ;25 ;50 ; 12;50000 ; ; ... (3 Replies)
Discussion started by: iindie
3 Replies
5. Shell Programming and Scripting
Hi All,
I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted...
AA ATIU2345098809 009697 005374
BB ATIU2345097809 005445 006518
CC ATIU9685098809 003215 003571
DD... (7 Replies)
Discussion started by: nithins007
7 Replies
6. Shell Programming and Scripting
text file example
1,222222222222,333,444444444444444
111111111,22,33333333,444
desired output
1 222222222222 333 444444444444444
111111111 22 33333333 444I have a delimeted file which I want to print in a table like format. The... (10 Replies)
Discussion started by: Calypso
10 Replies
7. Shell Programming and Scripting
Hello folks, I have another doozy. I have two files. The first file has four fields in it. These four fields map to different locations in my second file. What I want to do is read the master file (file 2 - 23 fields) and compare each line against each record in file 1. If I get a match in all four... (4 Replies)
Discussion started by: dagamier
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am a newbie to awk. Here is my problem. Looking for an awk 1-liner to solve it:
My Computing Environment:
- Solaris10
- I prefer to use csh or sh shells
1. Lets say my input file is File1.dat (delimter = | ) and looks as follows:
(File1.dat)
... (1 Reply)
Discussion started by: andy b
1 Replies
9. UNIX for Beginners Questions & Answers
Hi there,
I would like to use awk to reformat a tab-delimited file containing three columns as follows:
Data file:
sample 1 173
sample 269 530
sample 687 733
sample 1699 1779
Desired output file:
sample 174..265, 531..686, 734..1698
I need the value... (5 Replies)
Discussion started by: emiley
5 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I need to split a pipe de-limited file based on the COLUMN 7 value . If the column value changes I need to split the file
Source File
Payment|ID|DATE|TIME|CONTROLNUMBER|NUMBER|NAME|INDICATOR
42156974|1137937|10/1/2018|104440|4232|2054391|CARE|1... (9 Replies)
Discussion started by: rosebud123
9 Replies
LEARN ABOUT REDHAT
field_opts_on
form_field_opts(3X) form_field_opts(3X)
NAME
form_field_opts - set and get field options
SYNOPSIS
#include <form.h>
int set_field_opts(FIELD *field, OPTIONS opts);
int field_opts_on(FIELD *field, OPTIONS opts);
int field_opts_off(FIELD *field, OPTIONS opts);
OPTIONS field_opts(const FIELD *field);
DESCRIPTION
The function set_field_opts sets all the given field's option bits (field option bits may be logically-OR'ed together).
The function field_opts_on turns on the given option bits, and leaves others alone.
The function field_opts_off turns off the given option bits, and leaves others alone.
The function field_opts returns the field's current option bits.
The following options are defined (all are on by default):
O_VISIBLE
The field is displayed. If this option is off, display of the field is suppressed,
O_ACTIVE
The field is visited during processing. If this option is off, the field will not be reachable by navigation keys. Please notice that
an invisible field appears to be inactive also.
O_PUBLIC
The field contents are displayed as data is entered.
O_EDIT
The field can be edited.
O_WRAP
Words that don't fit on a line are wrapped to the next line. Words are blank-separated.
O_BLANK
The field is cleared whenever a character is entered at the first position.
O_AUTOSKIP
Skip to the next field when this one fills
O_NULLOK
Allow a blank field.
O_STATIC
Field buffers are fixed to field's original size.
O_PASSOK
Validate field only if modified by user.
RETURN VALUE
Except for field_opts, each routine returns one of the following:
E_OK The routine succeeded.
E_SYSTEM_ERROR
System error occurred (see errno).
E_CURRENT
The field is the current field.
SEE ALSO
curses(3X), form(3X).
NOTES The header file <form.h> automatically includes the header file <curses.h>.
PORTABILITY
These routines emulate the System V forms library. They were not supported on Version 7 or BSD versions.
AUTHORS
Juergen Pfeifer. Manual pages and adaptation for new curses by Eric S. Raymond.
form_field_opts(3X)