Use gawk, nawk or /usr/xpg4/bin/awk on Solaris.
Are you sure you want the final comma?
Re-reading the post, I'm not sure I understand the requirement ...
Hi All,
I have two comma separated value(CSV) files, say FileA and FileB.
The contents looks like that shown below.
FileA
EmpNo,Name,Age,Sex,
1000,ABC,23,M,
1001,DES,24,F, ... (2 Replies)
I've been using a lot of awk lately for csv files.
But I've been using awk for csv files that contain 32 fields per line.
For the first time, I've been given a csv file that contains one field per line (13 fields in each csv file).
I need to check that a specific field, or line contains a... (2 Replies)
Hi,
How can I remove the line beak in the following case if the line begin with the special char “;”?
TEXT
Text;text
;text
Text;text;text
I want to convert the text to:
Text;text;text
Text;text;text
I have already tried to use... (31 Replies)
Hi Guys,
I have a file like this:
aaa b c d e f
fsss g h i k l
qqq r t h n
I want:
aaa b c d e f
fsss g h i k l
qqq r t h , n
ggg p t e d u
qqq i o s , k (2 Replies)
How would I do something like this when field 4 contains "John". I only want to print field 1 and 4 when when field 4 contains"John".
awk -F" " '{print $1 $4} (3 Replies)
Hi all !
I almost did it but got a small problem.
input:
cars red
cars blue
cars green
truck black
Wanted:
cars red-blue-green
truck black
Attempt:
gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input
But I also got the intermediate records... (2 Replies)
I have several questions about using awk. I'm hoping someone could lend me a hand. (I'm also hoping that my questions make sense.)
I have a file that contains pipe separated data. Each line has similar data but the number of fields and the field position on each line is variable. ... (3 Replies)
Hi,
I am trying to pass awk field to a command line executed within awk (need to convert a timestamp into formatted date).
All my attempts failed this far.
Here's an example.
It works fine with timestamp hard-codded into the command
echo "1381653229 something" |awk 'BEGIN{cmd="date -d... (4 Replies)
Trying to use awk to remove a line only if $1 contains either ; or :. Thje awk below runs but no lines are removed. Thank you :).
awk
awk '$1 !~ /;/ || $1 !~ /:/ { print }' file
file
AARS2;TMEM151B 1
AASS 2
ABAT 3
ABCA1 3
ABCA10 1
ABCA12 2
ABCA13 1
ABCA13:AX746840 2
ABCA2 5 (5 Replies)
My file (the output of an experiment) starts off looking like this,
_____________________________________________________________
Subjects incorporated to date: 001
Data file started on machine PKSHS260-05CP
**********************************************************************
Subject 1,... (9 Replies)
Discussion started by: samonl
9 Replies
LEARN ABOUT NETBSD
form_field_just
FORMS(3) BSD Library Functions Manual FORMS(3)NAME
field_just, set_field_just -- form library
LIBRARY
Curses Form Library (libform, -lform)
SYNOPSIS
#include <form.h>
int
field_just(FIELD *field);
int
set_field_just(FIELD *field, int justification);
DESCRIPTION
Field justification is only applied to static fields, a dynamic field will not be justified. The default justification for a field is
NO_JUSTIFICATION. The field_just() will return the current justification value of the given field and the justification may be set by call-
ing the set_field_just() function.
PARAMETERS
The following are the valid justifications for a field:
NO_JUSTIFICATION No justification is to be applied to the field. In practice, this is the same as JUSTIFY_LEFT.
JUSTIFY_RIGHT The field will be right justified. That is, the end of each line will be butted up against the right hand side of the
field.
JUSTIFY_LEFT The field will be left justified. That is, the start of each line will be butted up against the left hand side of the
field.
JUSTIFY_CENTER The field will be centre justified, padding will be applied to either end of the line to make the line centred in the
field.
RETURN VALUES
The functions will return one of the following error values:
E_OK The function was successful.
E_CURRENT The field specified is the currently active one on the form.
E_BAD_ARGUMENT A bad argument was passed to the function.
SEE ALSO curses(3), forms(3)NOTES
The header <form.h> automatically includes both <curses.h> and <eti.h>.
BSD January 1, 2001 BSD