|
|
Sponsored Content
Top Forums
Web Development
split the fields in a column into 3 columns
Post 302290469 by Neo on Monday 23rd of February 2009 11:38:42 AM
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hey guys...
Im looking to do the following:
1
2
3
4
5
6
7
8
9
Change to:
1 4 7
2 5 8
3 6 9
Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want. (3 Replies)
Discussion started by: zaneded
3 Replies
2. Shell Programming and Scripting
hey,
i have the following data:
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000
0.000000 (7 Replies)
Discussion started by: zaneded
7 Replies
3. Shell Programming and Scripting
Hello;
I have a file consists of 4 columns separated by tab. The problem is the third fields. Some of the them are very long but can be split by the vertical bar "|". Also some of them do not contain the string "UniProt", but I could ignore it at this moment, and sort the file afterwards. Here is... (5 Replies)
Discussion started by: yifangt
5 Replies
4. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
5. UNIX for Dummies Questions & Answers
Hey everyone,
I have an issue with a client that is passing me a list of values in one column, and occasionally the combination of all the values results in more than an 255 character string. My DB has a 255 character limit, so I am looking to take the column (comma delimited file), and if it... (1 Reply)
Discussion started by: perekl
1 Replies
6. Shell Programming and Scripting
Hi,
I need help to split a long text in a column which is separated by ; and i need to print them out in multiple columns. My input file is tab-delimited and has 11 columns as below:-
aRg02004 21452 asdfwf 21452 21452 4.6e-29 5e-29 -1 3 50 ffg|GGD|9009 14101.10 High class -node. ; ffg|GGD|969... (3 Replies)
Discussion started by: redse171
3 Replies
7. Shell Programming and Scripting
input:
chr1 1 2 3
chr1 1 2 4
chr1 2 4 5
chr2 3 6 9
chr2 3 6 10
Code:
awk '{a+=$4}END{for (i in a) print i,a}' input
Output:
chr112 7
chr236 19
chr124 5
Desired output:
chr1 1 2 7
chr2 3 6 19
chr1 2 4 5 (1 Reply)
Discussion started by: jacobs.smith
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a text file 'Item_List.txt' containing only 1 column. This column lists different products, each separated by the same generic string header "NEW PRODUCT, VERSION 1.1". After this the name of the product is given, then a delimiter string "PRODUCT FIELD", and then the name of the... (11 Replies)
Discussion started by: mmab
11 Replies
9. Shell Programming and Scripting
I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end
Source file will have
001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C
Need Output from every 5 tab and remove the comma from end of each row
... (4 Replies)
Discussion started by: ranjancom2000
4 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I am trying to split the following output into two columns, where each column has Source: Destination:
OUTPUT TO FILTER
$ tshark -r Capture_without_mtr.pcap -V | awk '/ (Source|Destination): /' | more
Source: x.x.x.x
Destination: x.x.x.x
Source:... (2 Replies)
Discussion started by: sand1234
2 Replies
LEARN ABOUT DEBIAN
postal-list
postal-list(1) Postal postal-list(1) NAME
postal-list - program to show how postal expands user names SYNOPSIS
postal-list user-list-filename conversion-filename DESCRIPTION
This program shows the expansion that the postal program uses on email addresses. This can be used to make sure that you're configuration files do what you expect them to, and can also be used to produce a list of user-names for an account creation script (in case you want to create a million test accounts in a conveniant fashion). The user-list-filename is the name of a file which contains a list of user's email addresses. This can be just user-names or fully quali- fied email addresses. The conversion-filename parameter will be the name of a file containing the conversions to apply to email addresses. Each line in the file can either be a comment (starting with "#") or is to contain two parameters. The first parameter is the regular expression. For each email that is to be sent a randomly selected user-name will be checked against all regular expressions, the first match will determine the translation that is to be applied. The translation will be the second parameter on the line. It will contain a number of "." characters specifying characters in the name that are not to be translated. To specify the translations a range of characters can be specified inside square brackets. For example to have every address starting with "a" have a character from "01234567890abc" as it's second character and a character from "xyz" as it's third character you would have the following: ^a .[0-9abc][xyz] RETURN CODES
0 No Error 1 Bad Parameters AUTHOR
This program, it's manual page, and the Debian package were written by Russell Coker <russell@coker.com.au>. AVAILABILITY
The source is available from http://doc.coker.com.au/projects/postal/ . See http://etbe.coker.com.au/category/benchmark for further information. SEE ALSO
postal(8),rabid(8),regex(7) russell@coker.com.au 0.70 postal-list(1)