I have been messing with a2ps in order to print a text file I have that has 130 columns by 80 rows per page. It appears that a2ps automatically scales the number of rows based upon the number of columns I try to print.The file prints properly for the columns but a2ps scales the rows to be 97 rows per page. So the 80 rows print but the next 17 rows are blank. It is not scaling the font for for 80 rows.
View 1 RepliesI bet this is a Perl one-liner (or very simple python script).I have a tab separated files in which each row looks like:Unique_Eight_Character_Sequence [3 tabs] data1~moredata1~moredata1 [3 tabs] data2~ moredata2~ moredata2 ... dataN~.The output file should have each column converted into a row (with the unique character sequence copied in for the first column), and then each "~" replaced by a comma.
View 14 Replies View RelatedI would like to transform rows into columns from a file in bash.
View 4 Replies View RelatedI need to create an out put file, last two columns as a row of data (using the first columns as heading) with the file name as first row. For an example the out put file should look like; system_name,0900_in,1000_in,1100_in,1200_in,1300_in,1400_in,0900_out,1000_out,1100_out,1200_out,1300 _out,1400_out
system1,15,17,19,21,23,25,24,26,28,30,32,34
I need to run a script to do above conversion. Need your help.
I've been hitting my head against a wall for awhile with this one:As the last part of some data analysis I performing I would to construct a matrix from a series of different files. These files have the format:
file 1 file 2 file 3
AAAAA .1 AAAAA .1 BBBBB .1
BBBBB .2 BBBBB .1 CCCCC .9
[code]...
In linux terminal; how can we get the number of rows ad columns from linux kernel? I tried from environment variables(LINES,COLUMNS) but, I could not retrieve them as my editor program is a child process to linux terminal process.
View 7 Replies View Relatedif there's a tab-delimited file under /usr/desktop, how can I determine the number of rows and columns of the file in shell?And, if told the the 3rd column of the file contains only numerical values and all values in the 5th column are unique, how can I verify these in shell?
View 13 Replies View RelatedI highlight a column by selecting "D" > format cells > background > I select a color and press OK. But the color on the document remains the same.
View 3 Replies View Relatedthe color from the table I insert? All I want to do is insert a basic table with 6 columns and 3 rows. I get that, but it has a gradient blue color.
View 1 Replies View RelatedHow can i concatenate rows of 2 files.
File1:
File2:
How want file3 to be like?
I would like to compare to mysql rows as follows:
Select count(*) from stocks2.historical where close*1.05 < (select open from stocks2.historical where date = date_add(date,interval 1 day))
and year(date)=2010;
The problem is with the "date" in bold... i want that date to be the date of the previous row. is there a way to do that purely with mysql? (naturally, i can write a script to go through and compare each date; what i'm asking for is a mysql solution.)
In placing array data into while statement that will be looped to recreate more lines as information is populated.
unfortunately i'm not getting this to work.
PHP Code:
Does anyone have a solution for merging files if the number of rows in the two (or more) files is non-equivalent.To exemplify, how about merging the following 3 files:
file1:
1
2
[code]...
We're currently running a web site on CentOS 5.5 running Apache - Tomcat - Mysql. A part of the web site runs slowly or it would appear to be.
The part in question returns records from mysql about approx 200 - 400 rows of data.
The first point of call was the SQL database we've managed to fine tune this. The problem I have is with IE7 and IE8 when I run Firefox or IE6 SP2 the rows return in about 9 seconds. I use IE7 or IE8 and it takes about 20 - 25 seconds.
Could this be an APACHE problem?
How can I delete selected rows of a table in perl/CGI??
View 5 Replies View RelatedWhen you view mail in evolution in the vertical mode with the folders on the left, then the mail list in the middle and the message on the right, the mail list displays each message on two rows. But in thunderbird, the mail list is just in one row which means that much of the message header is not visible.
how to get thunderbird to display message lists using two rows per message?
I have been trying to repeat the first two rows in a Calc document but I keep getting an error.
Here are the instructions that I used.
Printing Rows or Columns on Every Page If you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page. As an example, If you want to print the top two rows of the sheet as well as the first column (A)on all pages, do the following:
1.Choose Format - Print Ranges - Edit. The Edit Print Ranges dialog appears.
2.Click the icon at the far right of the Rows to repeat area. The dialog shrinks so that you can see more of the sheet.
3.Select the first two rows and, for this example, click cell A1 and drag to A2.
In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows to repeat.
4.Click the icon at the far right of the Rows to repeat area. The dialog is restored again.
5.If you also want column A as a column to repeat, click the icon at the far right of the Columns to repeat area.
6.Click column A (not in the column header).
7.Click the icon again at the far right of the Columns to repeat area.
Rows to repeat are rows from the sheet. You can define headers and footers to be printed on each print page independently of this in Format - Page.
And here is the error.
"invalid sheet reference"
I have a problem - I have files with rows of data and I need to check if the next row (of the same type) has the NEXT date in it so I need to extract a date in YYYYMMDD format from a row (easy enough) then add one day to it and compare it to the the next date I encounter on a subsequent row.
So if I have
DATE|20100530
VAL|kahskjhd
[code]...
When Debian 6 (amd 64, testing) is loaded, before desktop appears, for a while, the screen is black and three strange green rows appear. Then, all is ok and I can see a normale desktop and start to use Debian. So, an error in video config could be possible. Linked to this fact (I think) , there is the impossibility to modify the resolution screen (that is fixed to 1024x768) and the refresh frequency. I've tried to find "xorg.conf" in order to modify it like various guides suggest me, but this file is not present.
View 1 Replies View RelatedI have a lot of files with thousands of rows and usually two columns of data. Column 1 is a coordinate, column 2 is a score. I want to delete rows that have a value in column 2 over, in this case, 50.
For example, here's a clip from a file:
2999898 39
2999899 40.9
2999900 42.7
2999901 44.7
2999902 46.7
2999903 48.9
2999904 51.1
2999905 53.3
2999906 55.7
I want the output to be this:
2999904 51.1
2999905 53.3
2999906 55.7
I know how to use sed for very basic things like deleting rows or ranges of rows but I can't figure out this ostensibly easy command.
I have a csv file that has around 3 million rows. I want to process this file so that it creates a new file that contains only the rows that have 2 characters or less in the first column column.At the moment i am using SQL Loader but its taking too long so im wondering whether this would be easier if done in Unix?
View 8 Replies View RelatedIs the maximum number of letters a database table column can contain 255?and is it a bad idea to build a table with about 15 columns?
View 1 Replies View RelatedI need to transpose a file with over a 1000 rows of 5 columns of numbers into a file with a single column of numbers. The numbers are separated by a single space and range from one digit to 5 digits each. I tried using awk, but can only get it to grab one column of numbers.
Input:
1 2 3 4 50
600 7 8 9000 10
11 12000 13 14 15
Desired output:
1
2
3
4
[code]....
Tried using: awk '{split($0,a,""); print $NF}' <filename> and got:
50
10
15
It only grabbed the last number in each row.
I installed gDevilspie and am using that to configure it, and I have Compiz running with a 2x2 viewport layout (2 horizontal and 2 vertical viewports).I have Devilspie working beautifully for any application that is assigned to either viewport 1 or 2. However, if I try to set them to viewports 3 or 4, the viewports on the bottom, Devilspie does not do anything.Devilspie does not give me any errors when I run it from the terminal. What I've noticed is that it only seems to work with horizontal viewports. I changed the viewport layout from 2x2 to 4x1 (so they were all on a single row), and then setting viewports 3 and 4 worked beautifully. However, with a 2x2 layout, I can only use viewports 1 and 2.
Furthermore, I noticed that if I had an application set to, say, viewport 1 (e.g., Firefox), then it would open in viewport 3 if I was currently viewing viewport 4. In other words, it's treating my viewports as if I have two sets of viewport 1 and viewport 2; one set on the top row, and the second on the bottom row.I'm not sure what's causing this, or if there's some sort of trickery that needs to be done to make the bottom row of viewports work, but any help would be appreciated.In case it's needed, I'm running Ubuntu 10.10, devilspie 0.22, gdevilspie 0.5, and compiz 0.8.6. Pasted below is one of the problem scripts (note that if I were to set it to viewport 1 or 2, it would work fine).
Code:
; generated_rule XChat
( if
[code]...
How can I delete rows into text file in perl?
View 4 Replies View RelatedThis suite contains a database which is pure ****; it will not import a simple csv file of 684k rows in my 64 bit linux laptop, but the same file loads flawlessly in windows 32 bit access 2002.
View 9 Replies View RelatedI have a big file full of records like this
1, 2, 4, 5, 6
1, 3, 5, 6, 3
1, 4, 5, 6, 6
2, 4, 5, 5, 5
2, 3, 4, 5, 2
anyway i need to take the average of all rows with the same 1st number(key). i.e.
1, 3, 4.66, 5.66, 5
2, 3.5, 4.5, 5, 3.5
I know this is something awk/sed would be great for, i just dont have enough experience with them to accomplish it, Also, what about averaging those columns together? so, after I output this to a file, id like to get another like:
1, 4.58
1, 4.125
The number of colums to add might not always be 4 either. EDIT: this might be easier to do in gnuplot, so I mainly just need an answer to the first part.
i am trying to get a script that i'm calling to have information from a sql populate into rows... but i'm not getting the data to output correctly into the rows. can someone please help?
<table>
<thead>
<tr>
<th>Name</th>
<th>Help</th>
<th>Folder</th>
code....
I'm not that familiar with sed and awk in order to be able to solve this problem on my own, so I'm calling on you for a bit of assistance. I'm writing a Nagios plugin to check our Oracle tablespaces and the output is given in one line like this: 1.04007771 TEMP 0 UNDOTBS1 .005340579 USERS 0 7 rows selected. I've been playing around with sed like below to delete the obsolete info and change every second space into a newline:
[code]...
how many tablespaces there are so I'd have to check all databases and 'hardcode' the tablespaces in my script. Is there any way to 'automate' this knowing that 'rows selected' preceded by a number is always the last line and using a sort of counter to auto-adjust the number to put in the -e 's/ / /2' part?
I had been playing around with various Python scripts in order to add certain columns to Nautilus, in particular bitrate, length, artist and genre for information on mp3 files. Well, I got greedy and installed something I shouldn't have and now I have massive duplicate columns available, and checking them to be visible has no effect at all. I have lost all the information that would populate the aforementioned columns.
I went to the Configuration Editor, went to apps>nautilus>list view>default visible columns and deleted the extraneous columns. I also disabled all the pythons scripts I put in ~/.nautilus/python-extensions. The extra columns never go away, and, if checked, never make visible the named information. Here is a screencap.