09-11-2014
Quote:
Originally Posted by
rbatte1
Dear
owwow14,
I have a few to questions pose in response first:-
- What have you tried so far?
- What output/errors do you get?
- What OS and version are you using?
- You've said awk but would you consider alternatives?
- What logical process have you considered? (to help steer us to follow what you are trying to achieve)
Most importantly,
What have you tried so far?
There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.
We're all here to learn and getting the relevant information will help us all.
Kind regards,
Robin
Hi, Sorry for being cryptic, I have been struggling with this for some hours now.
To answer your questions.
- I am have been using python and awk. The first approach was challenging for me, as the file is already in what would be considered a dictionary format. So, I do not know how to unnestle the information within the brackets. Also, there is a header information which is a label for the bracketted information, so I could not find a solution for this.
For the second approach awk I have been trying to isolate each individual chunk of information (i.e. between blank lines). Then, delete the punctuation by replacing it with new lines to create the column format
- I am using OSx 10.7.5
- I am open to using a UNIX-type command or python
I hope I provided more information to my question.
Thank you again, in advance.
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
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
3. 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
4. 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
5. Shell Programming and Scripting
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 ... (3 Replies)
Discussion started by: kavithakuttyk
3 Replies
6. Shell Programming and Scripting
Dear All,
I have some thousands of files in a folder and i need to change those file names without opening the file (no need to change anything in the file content, need to change the file name only). The filenames are as follows:
Myfile_name.1_parameter
Myfile_name.2_parameter... (6 Replies)
Discussion started by: Fredrick
6 Replies
7. 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
8. 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
9. 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
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
IGAWK(1) Utility Commands IGAWK(1)
NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO
gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
Free Software Foundation Nov 3 1999 IGAWK(1)