08-09-2011
Thanx a lot Agama
Thanks very much friend,
Basically my problem is solved upto 80%....but here are some more modifications that are needed in the o/p....
1) my csv file is very big and having around 50 fields out of which for field 39 there are 4 values say 1,2,3,4....
for each value of 39th field I have to manipulate the file like such that field 21 comes in vertical and field 26 comes in horizontal.....this 26th field is having many entries upto 15-20......for example....
cat jitendra.csv | awk -F "|" '{if ($39==3) print $0}'.....now for this manipulated file I have to work accordingly for field 21 & 26.......
2) the o/p for 21 and 26 field is not in sorted manner,,, actually I need it in sorted manner......
3) some of the values in field 21(vertical) are blank......so for that blank values I would like to print a "blank"....but no entry in hoz array is blank....
4) also the o/p is not aligned as pasted below.....
####################
COLA/COLB 9008 8739 8822
0 3281 874 389
255 123 18 11
1 3 2 0
133 6 0 0
254 120 6 3
19 240 7 17
137 110 13 3
34 22 0 0
17 4 0 0
###################
..................................................
Actually friend I had to do a lot of modifications more n this file......aside to the above queries.....
can u just help me in understanding that code....because I am a newbie and half of the code is not understandable by me.....
so that I could make some modifications by myself.....
............Any help wud be highly appreciated....thanx in advance.....
Last edited by jitendra.pat04; 08-09-2011 at 04:44 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi guys, I hope you can help me with my problem.
I have a text file that contains lines like this:
78 ANGELO -809.05
79 ANGELO2 -5,000.06
I need to find all occurences of amounts that are negative and replace them with x's
78 ANGELO xxxxxxx
79... (4 Replies)
Discussion started by: amangeles
4 Replies
2. Shell Programming and Scripting
Hi,
Need to extract a string from one file and search the same in other files.
Ex:
I have file1 of hundred lines with no delimiters not even space.
I have 3 more files.
I should get 1 to 10 characters say substring from each line of file1 and search that string in rest of the files and get... (1 Reply)
Discussion started by: mohancrr
1 Replies
3. Shell Programming and Scripting
Hi all,
I am having a problem in comparing numeric value with string.
I have a variable in my script which gets the value dynamically. It can be a numeric value or a string.
I have to do separate task based on its value numeric or sting variable VARIABLE.
I grep FILE_COUNT and obtained... (7 Replies)
Discussion started by: naren_0101bits
7 Replies
4. Shell Programming and Scripting
Hi frnds
Im facing an issues while trying to compare string using IF stmt, my code is:
chkMsgName=`Service Fee Detail`
if
then
if
then
if
then
echo "Valid File Ready for processing"
fi
fi
... (5 Replies)
Discussion started by: balesh
5 Replies
5. Shell Programming and Scripting
Hi everyone,
I am working on fetchmail + procmail to filter mails and I am having problem with parsing a long line in the body of the email.
Could anyone help me construct a reg exp for this string below. It needs to match exactly as this string.
GetRyt... (4 Replies)
Discussion started by: cwiggler
4 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I am trying to to compare a string variable with a string literal inside a loop but keep getting the
./testifstructure.sh: line 6:
#!/bin/sh
BOOK_LIST="BOOK1 BOOK2"
for BOOK in ${BOOK_LIST}
do
if
then echo '1'
else
echo '2'
fi
done
Please use next... (1 Reply)
Discussion started by: daveu7
1 Replies
7. Shell Programming and Scripting
I am attempting to grep an exact string from a series of files within a directory and append that output to the filename when it is present in the file. I've been after this all day with no luck. Thanks for your help in advance :wall:. (4 Replies)
Discussion started by: JC_1
4 Replies
8. Shell Programming and Scripting
Hi ,
I have one file like
BUD,BDL BUDCAR
BUD,BDL BUDLAMP
ABC,CDF,KLT ABISKAR
ABC,CDF,KLT CORNEL
ABC,CDF,KLT KANNAD
JKL,HNM,KTY,KJY JAGAN
JKL,HNM,KTY,KJY HOUSE
JKL,HNM,KTY,KJY KATAK
JKL,HNM,KTY,KJY KOLKA
The o/p should be like
BUD,BDL BUDCAR,BUDLAMP
ABC,CDF,KLT... (4 Replies)
Discussion started by: jagdishrout
4 Replies
9. Shell Programming and Scripting
Hi,
I have a list of zipped files. I want to grep for a string in all files and get a list of file names that contain the string. But without unzipping them before that, more like using something like gzcat.
My OS is:
SunOS test 5.10 Generic_142900-13 sun4u sparc SUNW,SPARC-Enterprise (8 Replies)
Discussion started by: apenkov
8 Replies
10. UNIX for Advanced & Expert Users
Good morning,
I need compare this string.
if || || ; then
But this line not work, somebody can say me what is the error.
Thank you for advanced. (5 Replies)
Discussion started by: systemoper
5 Replies
LEARN ABOUT REDHAT
form_field_opts
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)