I`m having a strange problem with my data set. Whenever there is a transition to another value is col1, the corresponding 3rd col goes to the next line. This is a huge file, so need to fix in a script. The file is tab delimited.
Here is what is happening when transitioning from DS11.02060 to DS11.02061, the value 1150.76 is in the next line. Happens for every transition. The file is sorted by col 1.
Gurus,
I am struggling with a issue and thought I could use some of your expertise.
Need Help with this
I have a flat file that has millions of records
24|john|account ~ info |56|
25|kuo|account ~ journal |58|
27|kim|account ~ journal |59|
28|San|account ~
journal |60|... (3 Replies)
Hello Experts,
I have a timestamp(6) column in a .csv data file , format of the data is as below:-
ETCT,P,Elec, Inc.,abc,11/5/2010 4:16:09.000000 PM,Y,Y,Y
I want the timestamp column to be properly formatted like
11/05/2010 04:16:09.000000 PM
Currently the "0" is missing with... (3 Replies)
Hi guys,
How you doing?
Need some help with this .I got a file with this kind of information
SURVIVABLE PROCESSORS
Name Type IP Address Reg Act Translations Net
Updated Rgn
Gateway001 ... (8 Replies)
Hello to all;
hope someone can assist me in getting the required output that my manager is expecting.
I have been able to generate this code which does the comparison of the files and creates the file called diff_fuss_file.txt
$ vi fussrpt.pl
#!/usr/bin/perl
#cd /tmp
#rm output.txt
... (2 Replies)
Hi All,
I need to convert an exel spreadsheet into a SAS dataset,
and the following format change is needed. Please help, this is too complex
for a biologist.
Let me describe the input.
1st row is generation.1st column in keyword 'generation', starting 2nd column there are 5... (9 Replies)
I have a file that contains 2 columns tag,pos
cat input_file
tag pos
atg 10
ata 16
agt 15
agg 19
atg 17
agg 14
I have used following command to sort the file based on second column
sort -k 2 input_file
tag pos
atg 10
agg 14
agt 15
ata 16
agg 19
atg 17 (2 Replies)
Hi..
In the below sorted input file.. I am comparing the first 3 columns of data one by one row and it is a pipeline delimitter file..
AA|BB|CC|line1
AA|BB|CC|ine4
AA|BB|CC|line2
BB|CC|DD|line3
BB|CC|DD|line5
If first 3 columns of data matches with any record in the file the... (4 Replies)
hi all
i'm new in shell scripting and now i'm working on project and i wanna make a function take input from user and test it's datatype then if correct write it to file
i wounder what is the best way to do this ?
can i use awk ?
edit by bakunin: Please give your threads a meaningful... (5 Replies)
Hello,
I am running ubuntu 14.04
My server has problems again. I need to manage system files in rescue mode, backup some files, edit /etc/crontab and rc.local files etc.
root@rescue:~# cat /proc/mdstat
Personalities :
md2 : active raid1 sda2 sdb2
4193216 blocks
md3 :... (4 Replies)
Discussion started by: baris35
4 Replies
LEARN ABOUT DEBIAN
aha
aha(1) Ansi HTML Adapter aha(1)NAME
aha - Ansi HTML Adapter
SYNOPSIS
aha [options] [-f datei]
DESCRIPTION
aha takes SGR-colored Input and prints W3C conform HTML-Code.
aha reads the Input from a file or stdin and writes HTML-Code to stdout.
OPTIONS --help , -h , -?
A help like this
--black , -b
Black Background and white "standard color"
--pink , -p
Pink Background
--iso X , -i X
Uses ISO 8859-X instead of utf-8. X must be 1..16
--title X , -t X
Gives the html output the title
--line-fix , -l
Uses a fix for inputs using control sequences to change the cursor position like htop. It's a hot fix, it may not work with any pro-
gram like htop. (See EXAMPLE)
EXAMPLE
aha --help | aha --black --title "the awesome aha help"> aha-help.htm
Creates an HTML file with the help of aha with black background
colordiff oldfile.c newfile.c | aha > colordiff.htm
Creates an HTML file with a colorful diff-output of two files "oldfile.c" and "newfile.c" with white background
ls --color=always | aha --pink > ls.htm
Creates an HTML file with a colorful ls-output with pink background.
echo a | htop | aha --black --line-fix > htop.htm
Creates an HTML file with the output of htop. You have to use --line-fix due the other new-line-commands htop uses.
AUTHOR
Copyleft Alexander Matthes aka Ziz 2011
zizsdl@googlemail.com
SEE ALSO
http://ziz.delphigl.com/tool_aha.php
August 31, 2011 aha(1)