Date is retrieved from SQL it is in this format YYYY-MM-DD HH24MI i.e 2019-12-12 0001 and is having data for 1 hour i.e 2019-12-12 0001 to 2019-12-12 0060
the whole output of the query consists of 3 columns date_time calling_app and count of requests
SQL script output is like given below
Want output like this, Also please note that there can be entries in between the timestamps for other applications as well
Also pleas let me know if any more inputs or data is required from my end.
Thanks,
TNT47
Moderator's Comments:
Please do wrap your samples/codes in your posts in CODE TAGS as per forum rules.
Last edited by RavinderSingh13; 12-16-2019 at 01:31 AM..
Hi,
I want to compare two files. Files will look like as follows:
file1:
ASDFGHJU|1234567890123456
QWERTYUI|3456789098900890
file2:
ZXCVBVNM|0987654321234567
POLKIJUYH|1234789060985478
output file should be:
ASDFGHJU|1234567890123456
QWERTYUI|3456789098900890
Thnaks in advance (6 Replies)
Hi all,
I need to create a matrix of variable rows and columns. Right now i have 3 rows and two columns and following values.
Output something like
TypeA TypeB
TestCase1 Pass Fail
TestCase2 Pass ... (2 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi ,
This is my first thread ; facing some issues withmy sed script
I need to insert the code from my log file which is between two keywords.
content is like this ........
log
############################
log1 log2
231 "Ban" "tom" and the line one of the cross line
friend... (2 Replies)
Hi all,
I am beginner in UNIX...I want to use unix shell script to create text.file...I know how to use using by command...can anybody tell me for the script?
Thanks
i changed the threads title from "tex file" to "text file", because "tex" would probably be misunderstood as reference to... (4 Replies)
Hi ,
I am having two files like this
FILE1
####################
input SI_TESTONLY_R_00;
input CE0_SE_INPUT_TESTONLY;
input CE0_TCLK_TESTONLY;
input SI_JTGCLOCKDR_JTAG_R_00;
input CE0_TCLK_JTGCLOCKDR_JTAG;
input CE0_SE_INPUT_JTGCLOCKDR_JTAG;
output SO_TESTONLY_R_00;
output... (2 Replies)
Hi Team,
Could you please help me on below query:
I want to retrieve XML elements from one .xml file. This .xml file has commented tags as well. so i am planning to write Unix command/script which 1.will chekc for this .xml file
2. it will ignore the commented XML lines. i.e. XML tags between... (3 Replies)
Hi folks,
I am new for shell script, I hope somebody to help me to write shell script
My requirement is below steps
1. I have apache access.log i.e located in /var/log/httpd/
Ex.
127.0.0.1 - - "GET... (14 Replies)
I have a large semicolon delimited file with thousands of columns and many thousands of line. It looks like:
ID1;ID2;ID3;ID4;A_1;B_1;C_1;A_2;B_2;C_2;A_3;B_3;C_3
AA;ax;ay;az;01;02;03;04;05;06;07;08;09
BB;bx;by;bz;03;05;33;44;15;26;27;08;09
I want to split this table in to multiple files:
... (1 Reply)
Discussion started by: trymega
1 Replies
LEARN ABOUT OSX
iconutil
iconutil(1) BSD General Commands Manual iconutil(1)NAME
iconutil -- Utility to convert between '.iconset' and '.icns' files.
SYNOPSIS
iconutil -c {icns | iconset} [-o file] file
DESCRIPTION
iconutil converts between '.iconset' and '.icns' files. The tool takes a single source '.icns' file or '.iconset' and converts it to either a
'.icns' or '.iconset' depending on the value of the -c flag's argument. It is possible to specify the name of the output file by passing the
file path as the argument to the -o flag. If -o is not set iconutil will write converted '.icns' file or '.iconset' to the same directory as
the source file using the same file name with the correct extension for the output type.
OPTIONS -c --convert {icns | iconset}
Given the argument iconset, iconutil converts the source '.icns' file to an '.iconset'. The '.iconset' is saved in the same direc-
tory as the source '.icns'. It is given the same file name as but with the '.iconset' file extension. If the argument is icns,
iconutil converts the source '.iconset' to an '.icns'. The '.icns' is saved in the same directory as the source '.iconset'. It is
given the same file name as the source file but with the '.iconset' file extension.
-o --output
Overrides the default output file name that iconutil uses to save the converted '.iconset' or '.icns' files.
FILES
/usr/bin/iconutil
Darwin June 2, 2019 Darwin