Hi All,
I have a file like below which is having 3 fields namely companycode, companylocation & companyaddress and i want to separate all the fields individually.
How can i do?
File Structure:
----------------
Aberdeen Centre Aberdeen The Ming An Ins Co (HK) Ltd
Academic... (30 Replies)
Hi All,
I need a solution to convert my .xlsx file which has lot of worksheet, convert to separate csv file. Is there any shell script to do this? I can’t use excel macro to do this, since it was password locked.
I need the csv output as an input to my shell script. (1 Reply)
Hi experts,
e.g.
i/p data looks like
0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405552747,9700005405717924,9700005405733788|unidentified,unidentified,unidentified||
o/p data should like -
row1: 0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405552747|unidentified
... (1 Reply)
Hello Members,
I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file.
input file --> file.csv
cat file.csv|less
"product/fruit/mango","location/asia/india","type/alphonso"
need output in... (2 Replies)
Hi,
I have file like below
apple,orange,pineapple,pappya,guva,avocado
want to store as
apple
orange
pineapple
pappya
I tried below command to seprate first field
command1: (3 Replies)
I have a csv that looks like this:
,yude-to-nap2,0,0,0,0,0
,2twis-yude-to-nap2,0,0,0,0,0
,2tiws-yude-to-nap2,0,0,0,0,0
,2arcos-yude-to-nap2,0,0,0,0,0
and another file named m1 that has a single line of text as content:
Feb 1 15:30:20
How can I fill the whole the empty column of the... (1 Reply)
I am running an ISQL command on Sybase DB and getting output of a query in an CSV file.
The issue is that all the data comes in to the same column, i want them to be separated in different columns.
SQL_COMMAND=command.sql
file=file.txt
formatFile=formatFile.txt
report=report.csv
echo... (1 Reply)
Dear Team,
please help me to solve this problem using Linux command. I want to dump this data into an excel sheet,
Suppose I have a string like:
ABC
PQR
XYZ
ASD
then I expect output as a
ABC XYZ
PQR ASD (3 Replies)
Discussion started by: Shubham1182
3 Replies
LEARN ABOUT OPENSOLARIS
print-service
print-service(1M) System Administration Commands print-service(1M)NAME
print-service - select, report, import, export active print service on a system
SYNOPSIS
print-service [-s service [-m] | -q | -e file | -i file]
DESCRIPTION
The print-service utility manages print service selection, as well as export and import of basic print queue configuration.
Only a user root privileges or with the Printer Management profile can change the active print service or import print queue configuration.
OPTIONS
The following options are supported:
-s service
Select the active print service for on a host. service can be one of lp or cups.
-m
Migrate print queue configuration during print service selection.
-q
Report the active print service on a host.
-e file
Export basic print queue configuration to a file.
-i file
Import basic print queue configuration from a file.
EXAMPLES
Example 1 Selecting a Print Service
The following command selects the CUPS print service as the active print service on a host.
# print-service -s cups
Example 2 Reporting the Active Print Service
The following command reports the active print service on a host.
# print-service -q
Example 3 Exporting a Print Queue Configuration
The following command exports the print queue configuration from the active print service.
# print-service -e /tmp/queues
Example 4 Importing a Print Queue Configuration
The following command imports the print queue configuration to the active print service.
# print-service -i /tmp/queues
EXIT STATUS
0
Successful completion.
non-zero
An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpcu |
+-----------------------------+-----------------------------+
|Interface Stability |Obsolete |
+-----------------------------+-----------------------------+
SEE ALSO intro(1), attributes(5)NOTES
The print queue configuration saved and restored during export, import, and migration is limited to queue name and device name. It is
likely that further configuration changes will be required before imported or migrated print queues become usable.
SunOS 5.11 18 Mar 2008 print-service(1M)