02-29-2016
Quote:
Originally Posted by
rohit_shinez
...
Then reference table ranges should be like above considering greatest of 500 or T1 max_amt here its 600 if you say greatest (500 ,600)
...
Sorry, it's still unclear. 500 was the hard-coded value. You cannot have both 500 as well as 600 in the reference_table. So even if you determine the value 600, you will have to hard-code 500 in the greatest() function.
Quote:
Originally Posted by
rohit_shinez
...
And cant this be done without pivot
Not clear again.
If you do not pivot, your results will not be pivoted.
But you do want your results pivoted.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI all
I'm trying to write an awk script to print the min and max value in a range(s) contained in another file - the range values are in $2
EG
114,7964,1,y,y,n
114,7965,1,y,y,n
114,7966,1,y,y,n
114,7967,1,y,y,n
114,7969,1,y,y,n
114,7970,1,y,y,n
114,7971,1,y,y,n
114,7972,1,y,y,n... (3 Replies)
Discussion started by: Mudshark
3 Replies
2. Shell Programming and Scripting
Hi,
I have writtena script that will recursivly go into subdirecotries and report out what files there are in there that have not been accessed over various date ranges.
I do this using a number of find commands:
find . -path './.snapshot' -prune -o -type f -atime -8
find... (4 Replies)
Discussion started by: littleIdiot
4 Replies
3. Shell Programming and Scripting
Hi people,
I have 2 files, one with a list of non consecutive ranges (File1.txt), where each range begins with the value in column 1
and finishes with the value in column 2 in the same line, as can be seen above.
215312581156279 215312581166279
215312582342558 215312582357758... (4 Replies)
Discussion started by: cgkmal
4 Replies
4. Shell Programming and Scripting
Hi,
Please anyone help to achive this using perl or unix scripting .
This is date in my table 20090224,based on the date need to check the files,If file exist for that date then increment by 1 for that date and check till max date 'i.e.20090301 and push those files .
files1_20090224... (2 Replies)
Discussion started by: akil
2 Replies
5. Shell Programming and Scripting
hi !
how can i get files in a directory between certain date ranges ?
say all files created/modified between Jan24 - Jan31
thanks (10 Replies)
Discussion started by: aliyesami
10 Replies
6. Shell Programming and Scripting
Hi, I need to create weekly files from daily records stored in individual monthly filenames from 1999-2010. my sample file structure is like the ones below:
daily record stored per month:
199901.xyz, 199902.xyz, 199903.xyz, 199904.xyz ...199912.xyz
records inside 199901.xyz (original data... (4 Replies)
Discussion started by: ida1215
4 Replies
7. Shell Programming and Scripting
Hi,
I have two files
file1 chr1_22450_22500
chr2_12300_12350
chr1_34500_34550
file2 11000_13000
15000_19000
33000_44000
If the file 1 ranges fall between file2 ranges then assign the value of file2 in column 2 to file1
output:
chr2_12300_12350 11000_13000
chr1_34500_34550 ... (7 Replies)
Discussion started by: Diya123
7 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file with multiple columns. The second and third columns include numbers that have not been sorted. I want to extract rows where the second column includes a value between -0.01 and 0.01 (including both numbers) and the first third column includes a value between... (1 Reply)
Discussion started by: evelibertine
1 Replies
9. Shell Programming and Scripting
Need to get saturday's date of the previous week.
Input will be the sysdate (today's date)
Output should be previous weeks's saturday format
Your help is required extremely.
I have done all the date arthimetic calculation, but not getting the desired output. Please help (10 Replies)
Discussion started by: help_scr_seeker
10 Replies
10. Shell Programming and Scripting
Hi There, Good Day !!
I have txt file containing data in the below format. There are many lines, here i have mentioned for example.
cat remo.txt
2/3/2017 file1
3/4/2016 file2
6/6/2015 file5
1/1/2018 file3
4/3/2014 file4
-
-
-
I need to grep the file names for given date rage... (11 Replies)
Discussion started by: kumar85shiv
11 Replies
GCVT(3) Linux Programmer's Manual GCVT(3)
NAME
gcvt - convert a floating-point number to a string
SYNOPSIS
#include <stdlib.h>
char *gcvt(double number, size_t ndigit, char *buf);
Feature Test Macro Requirements for glibc (see feature_test_macros(7)):
gcvt():
Since glibc 2.12:
_SVID_SOURCE ||
(_XOPEN_SOURCE >= 500 ||
_XOPEN_SOURCE && _XOPEN_SOURCE_EXTENDED) &&
!(_POSIX_C_SOURCE >= 200112L || _XOPEN_SOURCE >= 600)
Before glibc 2.12:
_SVID_SOURCE || _XOPEN_SOURCE >= 500 || _XOPEN_SOURCE && _XOPEN_SOURCE_EXTENDED
DESCRIPTION
The gcvt() function converts number to a minimal length null-terminated ASCII string and stores the result in buf. It produces ndigit sig-
nificant digits in either printf(3) F format or E format.
RETURN VALUE
The gcvt() function returns the address of the string pointed to by buf.
CONFORMING TO
Marked as LEGACY in POSIX.1-2001. POSIX.1-2008 removes the specification of gcvt(), recommending the use of sprintf(3) instead (though
snprintf(3) may be preferable).
SEE ALSO
ecvt(3), fcvt(3), sprintf(3)
COLOPHON
This page is part of release 3.44 of the Linux man-pages project. A description of the project, and information about reporting bugs, can
be found at http://www.kernel.org/doc/man-pages/.
2010-09-20 GCVT(3)