11-21-2006
Modifying a csv file from Shell Script
Hi all,
I have some script that creates a temp csv file. What I need to do is do some search and replace and modify the file from my shell script. I know the commands to open the file and then apply the reg ex but wasnt sure how I could do this from a script and modify the file?
Any help would be much appreciated,
Thanks,
Last edited by not4google; 11-21-2006 at 05:42 AM..
Reason: More descriptive Title
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies
2. Shell Programming and Scripting
I have a CSV file which contains number series as one of the fields. Some of the records of the field look like :
079661/3
I have to convert the above series as
079661
079662
079663
and store it as 3 different records.
Looking for help on how to achieve this. Am a newbie at Shell... (10 Replies)
Discussion started by: mihirk
10 Replies
3. UNIX for Advanced & Expert Users
i have a report.csv file from oracle datavase
In that file data is like this with report heading and date
SALES DAILY REPORT
DATE: 06-26-2007
REPORT NAME: SALES DATA
AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END
ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END... (3 Replies)
Discussion started by: raosurya
3 Replies
4. Shell Programming and Scripting
I have a file in multiple directory which has some records in the following format
File: a/latest.txt , b/latest.txt, c/latest.txt ->
Name=Jhon
Age=27
Gender=M
Street=LA Road
Occupation=Service
I want to generate a csv file from the above file as follows
File: output.csv ->
... (9 Replies)
Discussion started by: rjk2504
9 Replies
5. UNIX for Dummies Questions & Answers
Hello !
I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.
Here is a sample of the file:
... (4 Replies)
Discussion started by: Grhyll
4 Replies
6. Shell Programming and Scripting
Hello All,
I have a csv file that looks like below
ProdId_A,3.3.3,some text,some/text,sometext_1.2.3
ProdId_B,3.3.3,some text,some/text,sometext_1.2.3
ProdId_C,3.3.3,some text,some/text,sometext_1.2.3
ProdId_A,6.6.6,some text,some/text,sometext_9.9.9
I will get ProdId from... (5 Replies)
Discussion started by: anand.shah
5 Replies
7. Shell Programming and Scripting
Hello all,
I have a Kconfig file that looks like something below ...
================================
menu "Application type"
config GUI_TYPE_STANDARD
bool "Standard Application"
source "cfg/config/std.in"
source... (12 Replies)
Discussion started by: anand.shah
12 Replies
8. Shell Programming and Scripting
I have a shell script which creates a CSV files. there are 3 fields, field1, field2 and comp. I will generates the values for field1 and field2 and Want to compare both. If field1>filed2 then comp should be success written in green in CSV file, else it should fail in red color. How can I change the... (5 Replies)
Discussion started by: sauravrout
5 Replies
9. Shell Programming and Scripting
Hi All,
I am trying to create a CSV file within a shell script test.ksh and the code snippet is something like below:
#!/usr/bin/ksh
# Set required variables.
. $HOME/.prof
# Output file path
Group1=/tmp/G1.csv
Group2=/tmp/G2.csv
Group3=/tmp/G3.csv
$ORACLE_HOME/bin/sqlplus -s... (2 Replies)
Discussion started by: swasid
2 Replies
10. Shell Programming and Scripting
Hello Unix Shell Script Experts,
I have a script that would mask the columns in .csv file or .txt file.
First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder.
Two parameters are passed
... (5 Replies)
Discussion started by: Mahesh G
5 Replies
LEARN ABOUT DEBIAN
gitaction
gitaction(1) General Commands Manual gitaction(1)
NAME
gitaction - GNU Interactive Tools - per file type action script
SYNTAX
gitaction directory file
.gitaction directory file
DESCRIPTION
gitaction is a script that executes a different action for each file type specified. It is called by the gitfm program when pressing F2 or
^Xa (see the gnuitrc.TERM configuration files in the gnuit manual). The first parameter is the current directory name and the second one is
the file name to be matched against the default patterns. The matching is done using the shell 'case' statement. If you press F2 or ^Xa on
a *.html file, gitfm will invoke a browser to view it, if you press F2 or ^Xa on a *.tar.gz file, gitfm will list the tar archive contents,
if you press the same keys on a *.gz file, gitfm will display its uncompressed contents on the screen, etc ...
If you press F2 or ^Xa on a *.gif file or *.jpg file and you have the zgv utility installed, you will be able to see it. If you want to
change the gif/jpeg viewer, all you need to do is to change its name in the gitaction script.
There are many more file types and viewers that gitaction knows about. In addition, if you are running under GNOME, gnome-open is used,
and on MacOS, open(1) is used. see(1) and metamail(1) are also used as fallbacks.
If all else fails, the file is displayed using $GNUIT_PAGER. Feel free to change this. If you want to find out what the default action for
each file type is (or if you want to modify it), just read/modify the gitaction script.
The script can be easily enhanced. Just read it.
The .gitaction script is a local version of the gitaction script. When started, gitaction tries to search a script called .gitaction in the
current directory and, if it finds it, it starts it. If .gitaction's exit code is 0 ( .gitaction couldn't find a matching pattern), gitac-
tion starts its own case statement trying to match the current file name (the second parameter) against its default patterns.
The .gitaction script *must* be executable. An example of .gitaction can be found in the directory gitfm is installed into. (usually
/usr/local/bin or /usr/bin) Debian users can find it in /usr/share/doc/gnuit/examples/. You should copy the example to the current direc-
tory or your home directory and then modify it.
BUGS
Please send bug reports to:
gnuit-dev@gnu.org
SEE ALSO
gitfm(1) gitps(1) gitview(1) gitmount(1) gitkeys(1) gitrgrep(1) gitunpack(1)
AUTHORS
Tudor Hulubei <tudor@cs.unh.edu>
Andrei Pitis <pink@pub.ro>
Ian Beckwith <ianb@erislabs.net> (current maintainer).
gitaction(1)