06-11-2009
Changing the text file format
Hi,
I have a shell script to unload all the empname who have salary >50000 from the emp table into a text file(empname.txt) .
m_db unload "$dbc_file" -column_delimiter ',' -select "SELECT empname FROM emp where salary > 50000" >> empname.txt
Now my text file have data in the following format
cat empname.txt
kkk,
abc,
efg,
hij,
lmn,
...,
etc
I want to change all these values in the below mentioned format and each string should have single codes.
cat empname.txt
'kkk','abc','efg','hij','lmn','...','...',etc
How can I change this in the shell script?.If anybody knows please help me to resolve this.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have an input file which looks like this:
601 a
602 a
603 a
601 b
610 c
615 c
603 d
601 d
612 d
I need the utput to look like this
601 a 602 603
602 a 601 603
603 a 601 602
601 b
610 c 615
615 c 610
603 d 601 612 (1 Reply)
Discussion started by: wahi80
1 Replies
2. Shell Programming and Scripting
i have an variable mydate=2008Nov07
i want o/p as in variable mymonth=11 (i.e nov comes on 11 number month)
i want some command to do this for any month without using any loop.
plz help me (1 Reply)
Discussion started by: RahulJoshi
1 Replies
3. Shell Programming and Scripting
Hi Experts,
Please help me to get the following from script for Unix ENvironment(shell, perl, tr, sed, awk).
INPUT FILE:
20K,ME,592971
20K,YOU,2
20K,HE,1244998
50K,YOU,480110
50K,ME,17
50K,HIS,10
50K,HE,1370391
OUTPUT FILE:
K,ME,YOU,HE,HIS
20K,592971,2,1244998,0... (5 Replies)
Discussion started by: ashis.tewari
5 Replies
4. Shell Programming and Scripting
Hi, I need to edit a file Protein Data Bank (pdb) and then open that file with the program VMD but when I edit the file with awk, it changes pdb format and the VMD program can not read it.
I need to subtract 34 to field 6 ($ 6).
this is a pdb file :
ATOM 918 N GLY B 103 -11.855 8.675... (8 Replies)
Discussion started by: bio_
8 Replies
5. Shell Programming and Scripting
I have a file as below and want to change it using awk
I want to find the entries such as
Iteration No.788
Best Value 0.00408152
Next-Worst Value 0.00522935
Worst Value 0.00523487
and change it to
Iteration No.788
788. Best Value = 0.00408152
788. ... (8 Replies)
Discussion started by: kristinu
8 Replies
6. Shell Programming and Scripting
Hi...
I have an inputfile name as :- abc_test_20120213.dat (date in yyyymmdd format)
I need the output file name as abc_test_13022012.dat (date in ddmmyyyy format)
Please help me on this...
Thanks in advance. (5 Replies)
Discussion started by: gani_85
5 Replies
7. UNIX for Dummies Questions & Answers
Hello, I have a situation where I want to change a line of text in multiple files, but the problem is that I want to change the text to something unique for each file.
For example, let's say I have five files named bob.txt, joe.txt, john.txt, tom.txt, and zach.txt. Each of these files has a... (5 Replies)
Discussion started by: Scatterbrain26
5 Replies
8. Shell Programming and Scripting
I have a CSV file with a date format like this;
11/19/2012 17:37:00,1.372,121.6
11/19/2012 17:38:00,0.743,121.6
Want to change the time stamp to seconds after 1970 so I can get the data in rrdtool. For anyone interested, this is data from a TED5000 unit and is Kwatts and volts.
Needs to... (3 Replies)
Discussion started by: ottsm
3 Replies
9. Shell Programming and Scripting
Hi all,
I have a file that looks like this:
Closest words to: manifesto >>>>
Closest words to: passport >>>>
and I want to reformat this with awk with the following desired result:
manifesto
0.99999999999999978, 'manifesto'
0.72008211381623111, 'communiqu\xe9'... (5 Replies)
Discussion started by: owwow14
5 Replies
10. UNIX for Dummies Questions & Answers
Hello all,
I am tryign to change the format of files (which are many in numbers). They at present are named like this:
SomeProcess_M-130_100_1_3BR.root
SomeProcess_M-130_101_2_3BX.root
SomeProcess_M-130_103_3_3RY.root
SomeProcess_M-130_105_1_3GH.root
SomeProcess_M-130_99_1_3LF.root... (7 Replies)
Discussion started by: emily
7 Replies
LEARN ABOUT CENTOS
gencfu
GENCFU(1) ICU 50.1.2 Manual GENCFU(1)
NAME
gencfu - Generates Unicode Confusable data files
SYNOPSIS
gencfu [ -h, -?, --help ] [ -V, --version ] [ -c, --copyright ] [ -v, --verbose ] [ -d, --destdir destination ] [ -i, --icudatadir direc-
tory ] -r, --rules rule-file -w, --wsrules whole-script-rule-file -o, --out output-file
DESCRIPTION
gencfu reads confusable character definitions in the input file, which are plain text files containing confusable character definitions in
the input format defined by Unicode UAX39 for the files confusables.txt and confusablesWholeScript.txt. This source (.txt) format is also
accepted by ICU spoof detectors. The files must be encoded in utf-8 format, with or without a BOM. Normally the output data file has the
.cfu extension.
OPTIONS
-h, -?, --help
Print help about usage and exit.
-V, --version
Print the version of gencfu and exit.
-c, --copyright
Embeds the standard ICU copyright into the output-file.
-v, --verbose
Display extra informative messages during execution.
-d, --destdir destination
Set the destination directory of the output-file to destination.
-i, --icudatadir directory
Look for any necessary ICU data files in directory. For example, the file pnames.icu must be located when ICU's data is not built
as a shared library. The default ICU data directory is specified by the environment variable ICU_DATA. Most configurations of ICU
do not require this argument.
-r, --rules rule-file
The source file to read.
-w, --wsrules whole-script-rule-file
The whole script source file to read.
-o, --out output-file
The output data file to write.
VERSION
1.0
COPYRIGHT
Copyright (C) 2009 International Business Machines Corporation and others
ICU MANPAGE
24 May 2009 GENCFU(1)