From your input/output, you simply don't want to print lines where any of SC1, SC2, SC3, SC4 is empty - thats simple enough that you could have done it yourself:
The if conditions do it - try a bit harder next time.
i have a report.csv file from oracle datavase
In that file data is like this with report heading and date
SALES DAILY REPORT
DATE: 06-26-2007
REPORT NAME: SALES DATA
AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END
ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END... (3 Replies)
Hi all,
I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on?
Thanks!
cat... (1 Reply)
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
Hello,
I am working on building a script that does the below actions together in my Linux server.
1) First, have to read the list of strings mentioned in CSV and store it in the shell script
2) Second, pick one by one from the string list, and search a particular folder for files that... (2 Replies)
Need perl or shell script to sort vertical lines to horizontal line in csv format
My file like below
-------------------------
================================================================================
PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
I have a shell script which creates a CSV files. there are 3 fields, field1, field2 and comp. I will generates the values for field1 and field2 and Want to compare both. If field1>filed2 then comp should be success written in green in CSV file, else it should fail in red color. How can I change the... (5 Replies)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values.
Name, Address,... (7 Replies)
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Hi Experts,
I am writing a python script to grep string from file and display output in csv file as in attached screenshot
https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view
Input file(result_EPFT_config_device)
Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies
LEARN ABOUT OPENSOLARIS
lpq
lpq(1B) SunOS/BSD Compatibility Package Commands lpq(1B)NAME
lpq - display the content of a print queue
SYNOPSIS
/usr/ucb/lpq [-P destination] [-l] [+ [interval]]
[request-ID...] [user]...
DESCRIPTION
The lpq utility displays the information about the contents of a print queue. A print queue is comprised of print requests that are waiting
in the process of being printed.
lpq displays the following information to the standard output:
o the username of the person associated with a print request,
o the position of a print request in the print queue,
o the name of file or files comprising a print request,
o the job number of a print request, and
o the size of the file requested by a print request. File size is reported in bytes.
Normally, only as much information as will fit on one line is displayed. If the name of the input file associated with a print request is
not available, the input file field indicates the standard input.
The print client commands locate destination information using the printers database in the name service switch. See nsswitch.conf(4),
printers(4), and printers.conf(4) for details.
OPTIONS
The following options are supported:
-l Displays information in long format. Long format includes the name of the host from which a print request originated in
the display.
-P destination Displays information about printer or class of printers (see lpadmin(1M)) . Specify destination using atomic, URI-style
(scheme://endpoint), or POSIX-style (server:destination) names. See printers.conf(4) for information regarding destina-
tion names.
+ [interval] Displays information at specific time intervals. Stops displaying information when the print queue is empty. Clears the
screen before reporting displaying the print queue. Specify interval as the number of seconds between displays. If
interval is not specified only executes once.
OPERANDS
The following operands are supported:
request-ID The job number associated with a print request.
user The name of the user about whose jobs lpq reports information. Specify user as a valid username.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
non-zero An error occurred.
FILES
$HOME/.printers User-configurable printer database
/etc/printers.conf System printer configuration database
printers.conf.byname NIS version of /etc/printers.conf
printers.org_dir NIS+ version of /etc/printers.conf
ou=printers LDAP version of /etc/printers.conf
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWlpr-cmds |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO lp(1), lpc(1B), lpr(1B), lprm(1B), lpstat(1), lpadmin(1M), nsswitch.conf(4), printers(4), printers.conf(4), attributes(5), standards(5)NOTES
When IPP is in use, the user is prompted for a passphrase if the remote print service is configured to require authentication.
SunOS 5.11 2 Jun 2006 lpq(1B)