Sponsored Content
Top Forums Shell Programming and Scripting Manipulating column in a file in UNIX Post 302887828 by sea on Tuesday 11th of February 2014 04:40:34 AM
Old 02-11-2014
To get a little practice myself....

Code:
OLD_IFS="$IFS"
IFS="|"
while read ColA ColB ColC ColD;do
    newB=$(echo "$ColB / 2" | bc)
    printf "$IFS$ColA$IFS$newB$IFS$ColC$IFS$ColD"
done
IFS="$OLD_IFS"

Hope this helps
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Manipulating output file

I have a file containing two fields, Name and Time, with about 57 lines in this file. I am struggling to create a loop that will cut out the first ten lines of this file and echo it to the screen. Can anybody help me please. (1 Reply)
Discussion started by: mariner
1 Replies

2. Shell Programming and Scripting

Manipulating a text file

hey guys, need ur expert help. m a core banker got stuck in someting techie and cant find a solution have manged to extract a file from oracle apps in a format that looks something like this... REC- A b c d x INV- A b... (6 Replies)
Discussion started by: komalkg
6 Replies

3. Solaris

Manipulating File

Help...please. I have a log that contains Warning Authentication Failed: User GHDT88998HS doesn't exit: The User GHDT88998HS could not be found Mar 22, 2008 5:22:22AM com.hometel.ttm.auth.userlogin. about maybe a thousand entries failed user acct message How can I grab just the username... (2 Replies)
Discussion started by: rivendell500
2 Replies

4. UNIX for Dummies Questions & Answers

Help!! manipulating file

Hi all, I need help manipulating the file below. Here is what I needed to do. First, I have to replace INSUPD to DELETE. Then I need to change the content of the file around by flipping the contents in the file from the bottom to the top (start from "CMD") How should I attack this? Here... (2 Replies)
Discussion started by: sirrtuan
2 Replies

5. Shell Programming and Scripting

Manipulating a file

Hi everybody, I need an urgent help with a BASH script. I have file which contains (besides the other data) the lines with the following structure identified by with keyword PCList: <PARAMETER NAME="PCList" TYPE="LIST_STRUCTURE" MODEL="{,}" ... (1 Reply)
Discussion started by: sameucho
1 Replies

6. Shell Programming and Scripting

Manipulating csv file

We need to convert a field in a csv file which is in cents to dollars.(divide by 100) in our shell script. Can some body help me? (3 Replies)
Discussion started by: Deepthz
3 Replies

7. Shell Programming and Scripting

need help on manipulating a file

Hi, I need a shell/command to achieve this task. I've a delimited unloaded file from oracle in a scrambled format as shown below with many blank lines in it, I'm just trying to tailor it in a format that would be compatible to view and load it to a IDS db. Here is the problem ... (1 Reply)
Discussion started by: divak
1 Replies

8. Shell Programming and Scripting

Help with manipulating environmental variables in UNIX

I am wondering if there is away to increment a date in c shell. What I need to do is basic, but I lack the knowledge. I have they following environmental variable in my job scripts setenv YYYY `date '+%Y'` I then set YYYY to be part of my output dataset name: setenv dd_OUTPUTP... (1 Reply)
Discussion started by: jclanc8
1 Replies

9. UNIX for Advanced & Expert Users

Copy a column to another column in UNIX fixedwidth file

Hi All, I have a fixedwidth file of length 3000. Now i want to copy a column of 4 chars i.e( length 1678-1681) to column 1127 – 1171 to the same file. Please let me know how can i achive using a single command in fixed width file. Also source column length is 4 chars and target column length... (4 Replies)
Discussion started by: kiranparsha
4 Replies

10. UNIX for Beginners Questions & Answers

Manipulating UNIX and sqlite db

Hi there, I have multiple rows of data. For example: S/N | Name| Age I would like to store them into sqlite database after doing some grepping in CSV and output them into console/html format. Will it be possible? (1 Reply)
Discussion started by: alvinoo
1 Replies
ENVIRON(7)						 Miscellaneous Information Manual						ENVIRON(7)

NAME
environ - user environment SYNOPSIS
extern char **environ; DESCRIPTION
An array of strings called the `environment' is made available by execve(2) when a process begins. By convention these strings have the form `name=value'. The following names are used by various commands: PATH The sequence of directory prefixes that sh, time, nice(1), etc., apply in searching for a file known by an incomplete path name. The prefixes are separated by `:'. Login(1) sets PATH=:/usr/ucb:/bin:/usr/bin. HOME A user's login directory, set by login(1) from the password file passwd(5). TERM The kind of terminal for which output is to be prepared. This information is used by commands, such as nroff or plot(1G), which may exploit special terminal capabilities. See /etc/termcap (termcap(5)) for a list of terminal types. SHELL The file name of the users login shell. TERMCAP The string describing the terminal in TERM, or the name of the termcap file, see termcap(5),termcap(3X). EXINIT A startup list of commands read by ex(1), edit(1), and vi(1). USER The login name of the user. PRINTER The name of the default printer to be used by lpr(1), lpq(1), and lprm(1). Further names may be placed in the environment by the export command and `name=value' arguments in sh(1), or by the setenv command if you use csh(1). Arguments may also be placed in the environment at the point of an execve(2). It is unwise to conflict with certain sh(1) variables that are frequently exported by `.profile' files: MAIL, PS1, PS2, IFS. SEE ALSO
csh(1), ex(1), login(1), sh(1), execve(2), system(3), termcap(3X), termcap(5) 4.2 Berkeley Distribution May 20, 1985 ENVIRON(7)
All times are GMT -4. The time now is 05:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy