11-30-2011
Quote:
Originally Posted by
Sarah_W
Thank you, that one does work a lot better!
I think the issue is that the way my raw data has been exported, it is not properly alligned in collumns itself, so when i run the script it does not have properly alligned data to work with in the first place!
I dont suppose you know of any scripts that could allign my raw data first, before running the script?
Currently my raw data, has all the items along the top, but the numbers underneath are not fitting perfectly under the headings;
...
So, as you can see the raw data itself is not alligned correctly.
Am I right in thinking, this is probably why the script is not working perfectly.
If you know of anyways to correct this I would be very happy!
Thanks
Still doesn't work? The later version should work with aligned or non-aligned data as it uses continuous spaces as delimiter, so the spaces between the columns don't a matter.
Last edited by MacMonster; 11-30-2011 at 04:06 PM..
Reason: Shorten the quote.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
----File attached.
Input file
===========
COL_1 <IP Add 1>
COL_2 <Service1>
COL_3 <ABCDEFG>
COL_4 <IP ADD:PORT>
COL_4 <IP ADD:PORT>
COL_1 <IP Add 2>
COL_2 <Service2>
COL_2 <Service3>
COL_2 <Service4>
COL_3 <AAAABBB>
COL_4 <IP ADD:PORT>
COL_4 <IP ADD:PORT>
COL_4 <IP... (27 Replies)
Discussion started by: bluethunder
27 Replies
2. Shell Programming and Scripting
Hi,
I am a beginner in bash&perl.
I have data in form of:-
A 1
B 2
C 3
D 4
E 5
I would like your help to find a simple way to change it to :-
A B C D E
1 2 3 4 5
Any help would be highly appreciated. (8 Replies)
Discussion started by: umaars
8 Replies
3. Shell Programming and Scripting
I have a file like the one given below
P1|V1|V2
P1|V1|V3
P1V1|V2
P2|V1|V4
P2|V2|V6
P2|V1|V4
I want it convert to
P1|V1|V2|V2|V3
P2|V1|V4|V2|V6
2nd and 3rd column should be considered as together and so the tird row is duplicate
Any ideas? (3 Replies)
Discussion started by: prasperl
3 Replies
4. UNIX for Dummies Questions & Answers
Hello everyone!
I have a huge dataset looking like this:
nameX nameX 0 1 2 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 ...............
nameY nameY 2 2 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 .....
nameB nameB 0 1 2 2 2 2 2 2 2 2 1 2 2 2 1 2 2 2 .....
(can be several thousands of codes)
and I need... (8 Replies)
Discussion started by: kush
8 Replies
5. Shell Programming and Scripting
I'm working on a different stage of a project that someone helped me address elsewhere in these threads.
The .docs I'm cycling through look roughly like this:
1 of 26 DOCUMENTS
Copyright 2010 The Age Company Limited
All Rights Reserved
The Age (Melbourne, Australia)
November 27, 2010... (9 Replies)
Discussion started by: spindoctor
9 Replies
6. Shell Programming and Scripting
I have 1000s of these rows that I would like to transpose to columns. However I would like the transpose every 3 consecutive rows to columns like below, sorted by column 3 and provide a total for each occurrences. Finally I would like a grand total of column 3.
21|FE|41|0B
50\65\78
15... (2 Replies)
Discussion started by: ravzter
2 Replies
7. Shell Programming and Scripting
Hello. very new to shell scripting and would like to know if anyone could help me.
I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do.
here is what the data looks like.
Server1 -- Date -- Other -- value... (7 Replies)
Discussion started by: Mikes88
7 Replies
8. Shell Programming and Scripting
Hi, I need to transpose columns of my files into rows and save it as individual files. sample contents of the file below.
0.9120 0.7782 0.6959 0.6904 0.6322 0.8068 0.9082
0.9290 0.7272 0.9870 0.7648 0.8053 0.8300 0.9520
0.8614 0.6734 0.7910 0.6413 0.7126 0.7364 0.8491
0.8868 0.7586 0.8949... (8 Replies)
Discussion started by: ida1215
8 Replies
9. Shell Programming and Scripting
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies
10. Shell Programming and Scripting
Hi,
I am trying to transpose rows to columns for thousands of records. The problem is there are records that have the same lines that need to be separated. the input file as below:-
ID 1A02_HUMAN
AC P01892; O19619; P06338; P10313; P30444; P30445; P30446; P30514;
AC Q29680; Q29837;... (2 Replies)
Discussion started by: redse171
2 Replies
pfscut(1) General Commands Manual pfscut(1)
NAME
pfscut - Extract a rectangle out of a frame in PFS stream
SYNOPSIS
pfscut [--left <columns>] [--right <columns>] [--top <rows>] [--bottom <rows>] [--width <new_width>] [--height <new_height>] [--help] [x_ul
y_ul x_br y_br]
DESCRIPTION
Extract a rectangle out of each frame in PFS stream. You can either specify x and y coordinates of upper left and lower right corner (the
coordinates start with 0 and rise in the left-to-right and up-to-botton directions) or give a combination of the options listed below.
OPTIONS
--left <columns>, -l <columns>
Number of columns to be cut out from the left edge of an image.
--right <columns>, -r <columns>
Number of columns to be cut out from the right edge of an image.
--top <rows>, -t <rows>
Number of rows to be cut out from the top edge of an image.
--bottom <rows>, -b <rows>
Number of rows to be cut out from the bottom edge of an image.
--width <new_width>, -W <new_width>
Width of an output image. Note that --width can be mixed with either --left or --right option.
--height <new_height>, -H <new_height>
Height of an output image. Note that --height can be mixed with either --top or --bottom option.
--help, -h
Print a list of commandline options.
EXAMPLES
pfsin image.hdr | pfscut --left 20 --top 5 | pfsout out.hdr
Cut out 20 columns from the left and 5 rows from the top edge of image.hdr and save frame as out.hdr.
pfsin image.hdr | pfscut --left 20 --width 400 | pfsout out.hdr
Cut out 20 columns from the left edge of image.hdr, and create output image 400 pixels in width.
pfsin image.hdr | pfscut 0 0 511 511 | pfsout out.hdr
Cut left-upper part of the image of the size 512x512 (note that coordinates start with 0 and 512 is the last row/column that is
included in the resulting image).
SEE ALSO
pfsin(1) pfsout(1)
BUGS
Please report bugs and comments to Dorota Zdrojewska <dzdrojewska@wi.ps.pl>.
pfscut(1)