Extracting differences between two columns dataset (SQL command)
Hi,
I have a table in my sqlite, here is an example (tab separated)
The 10th and 11th columns have information in a comma separated format (not tab).
.
I want to know if there's a sql command I can use to find the difference between the first value of column 10 and the first value in column 11, and the same for the second column, etc.?
for example
1920-1872
2090-2041
2560-2475
.
.
.
3533-3315
Hi,
I've already posted elsewhere but am posting again here coz im a newbie. I hope you forgive me this time.
I want to know if its possible to delete or ignore columns in a large dataset using 'sed'. For example, I have the following dataset: -
... (0 Replies)
Hi ,
I have a file having around 8 columns spereated by space . Now that I need to extract columns from this. The problem is this functionality is needed in a script and the required columns are dynamic and can range from 2 columns to 8 columns at a time .
What I tried without luck is ... (6 Replies)
Hi,
I want to know if its possible to delete or ignore columns in a large dataset using 'sed'. For example, I have the following dataset: -
20060714,X.XX,1,043004,Q,T,24.0000,1,25.5000,4,
20060714,X.XX,1,081209,Q,T,24.0000,1,25.5000,5,
As you can see, there are 10 columns here and the... (4 Replies)
Hi All,
I have a text file which looks like below.
################################################
Name:xxxxxxx
Version:1.0
Class: 2
City : Bangalore
Component Part Action Nb New Part Naming Part Name
12345 default 12345.12345 Bad
23456 ... (6 Replies)
Hi All,
I want to write a script to create flar images on multiple servers. In non zfs filesystem I am using -X option to refer a file to exclude mounts on different servers.
but on ZFS -X option is not working. I want multiple mounts to be ignore on ZFS base system during flarecreate.
I... (0 Replies)
Though, its not new, I am a newbie to shell scripting. Please help me with the below.
There are two steps.
First one is to read a table and create a file with the distinct values. I am able to get this done.
Second step is to read the file (which has the single value, like a number) and... (1 Reply)
Dear All,
I have two sets of files. File 1 can be any number between 1 and 20 followed by a frequency of that number in a give documents... the lines in the file will be dependent to the analysed document. e.g.
file1
1,5
4,1
then I have file two which is basicall same numbers but with... (2 Replies)
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Hi all,
Is Der any unix command which will create a empty dataset ..?(in .ds ).I know we can use orchadmin dump command to view dataset data.. but how to create a dataset..?
like
sampledataset.ds
thanks in advance
hemanthsaikumar (1 Reply)
Dear folks
I have a large data set which contains 400K columns. I decide to select 50K determined columns from the whole 400K columns. Is there any command in unix which could do this process for me? I need to also mention that I store all of the columns id in one file which may help to select... (5 Replies)
Discussion started by: sajmar
5 Replies
LEARN ABOUT XFREE86
vdltodmx
vdltodmx(1) General Commands Manual vdltodmx(1)NAME
vdltodmx - dmx configuration file parser and printer
SYNOPSIS
vdltodmx infile outfile
DESCRIPTION
vdltodmx reads the input file, which should be in VDL configuration file format. After a successful parse, a file in Xdmx configuration
file format is written to the output file.
The VDL file format is used with xmovie, which is available from http://www.llnl.gov/icc/lc/img/xmovie/xmovie.html
EXAMPLE
Given the following VDL-format file:
0
2
2560 2048 Left two-thirds [restrict=*:2]
2
:2.1 1280 2048 0 0 0 0
:2.2 1280 2048 1280 0 0 0
4
1280 1024 0 0
1280 1024 0 1024
1280 1024 1280 0
1280 1024 1280 1024
2560 2048 Right two-thirds [restrict=*:2]
2
:2.2 1280 2048 0 0 0 0
:2.3 1280 2048 1280 0 0 0
4
1280 1024 1280 0
1280 1024 1280 1024
1280 1024 2560 0
1280 1024 2560 1024
the following DMX-format file will be produced:
virtual "Left two-thirds" 2560x2048 {
display :2.1 1280x2048;
display :2.2 1280x2048 @1280x0;
}
virtual "Right two-thirds" 2560x2048 {
display :2.2 1280x2048;
display :2.3 1280x2048 @1280x0;
}
BUGS
If the VDL file is not in the expected format, the program will probably dump core.
SEE ALSO Xdmx(1), xdmxconfig(1), vdl(3), xmovie(1)XFree86 Version 4.7.0 vdltodmx(1)