05-29-2019
Thanks for your answer. Maybe you or someone other expert could show me an example that applies to my case with awk or another specific tool.
Thanks in advance
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Data in File
ABC:DEFGHI:123
ABCZYE:DEFI:123
ABCFGD:DEF:123
ABCEERRRRR:DEFGHI:123
Expected Format
1 ABC DEFGHIFE 123
2 ABCZYE DEFI 123
3 ABCFGD DEF 123
4 ABCEERRRRR DEFGHI 123
However when i enter the following... (2 Replies)
Discussion started by: blurboy
2 Replies
2. Shell Programming and Scripting
There is table 'DEPT' in the database with the following desciption:
Name Null? Type
------- -------- ------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME NULL VARCHAR2(14)
LOC NULL VARCHAR2(13)
Using shell script, I need to create a structure for the... (2 Replies)
Discussion started by: ehari
2 Replies
3. Shell Programming and Scripting
May data
Name = Andi
Address = none
Phone = 82728
Name = Peter
Address = none
Phone = 98799
The expected output
Name,Address,Phone
Andi,none,82728
Peter,none,98799
what i have done (6 Replies)
Discussion started by: before4
6 Replies
4. Shell Programming and Scripting
Hello,
I would like to modify an existing script of mine that uses a manually defined "MCVERSION" variable and make it define that variable instead based on this JSON file stored online:
https://s3.amazonaws.com/Minecraft.Download/versions/versions.json
Within that JSON, I 'm looking for... (4 Replies)
Discussion started by: nbsparks
4 Replies
5. UNIX and Linux Applications
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
6. Shell Programming and Scripting
Hi,
I have a csv file from which i am fetching few columns as below:
IFILE=/home/home1/Report1.csv
OFILE=/home/home1/`date +"%m%d%y%H%M%S"`.dat
if #Checks if file exists and readable
then
awk -F "," '(NR>4) {print $1,$6,$2,$3,$4,$5,$6}' ${IFILE} >> ${OFILE}
fi
cat $OFILE | mail... (7 Replies)
Discussion started by: Vivekit82
7 Replies
7. Shell Programming and Scripting
I am trying to automate editing of a json file using bash script.
The file I initially receive is
{
"appMap": {
"URL1": {
"name": "a"
},
"URL2": {
"name": "b"
},
"URL3": {
"name": "c"
},
}
WHat I would like to do is replace... (5 Replies)
Discussion started by: Junaid Subhani
5 Replies
8. Shell Programming and Scripting
Hi,
I need to extract only the create table structure with columns alone.
for eg
hive_table
show create table hive_table:
create table hive_table(id number,age number)
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION 'hdfs:/path/'
I need only below
... (5 Replies)
Discussion started by: rohit_shinez
5 Replies
9. Shell Programming and Scripting
Hello.
I'm new to bash script and I'm learning the basics by writing some scripts.
Recently a friend of mine asked me if I could try to write a script to him to automate a couple of processes that uses JSON RPCs.
I'll try to explain in few words the workflow just to contextualize the problem.... (48 Replies)
Discussion started by: psysc0rpi0n
48 Replies
MC-TOOL(1) Utilities MC-TOOL(1)
NAME
mc-tool - manipulate Mission Control accounts from the command line
SYNOPSIS
mc-tool list
mc-tool add PROFILE DISPLAY-NAME [PARAMETER-SETTINGS...]
mc-tool add MANAGER/PROTOCOL [PARAMETER-SETTINGS...]
mc-tool update ACCOUNT [PARAMETER-SETTINGS...]
mc-tool display ACCOUNT DISPLAY-NAME
mc-tool nick ACCOUNT NICKNAME
mc-tool icon ACCOUNT ICON
mc-tool show ACCOUNT
mc-tool get ACCOUNT PARAMETER [PARAMETER...]
mc-tool auto-presence ACCOUNT STATUS [MESSAGE]
mc-tool request ACCOUNT STATUS [MESSAGE]
mc-tool auto-connect ACCOUNT on|off
mc-tool remove ACCOUNT
DESCRIPTION
mc-tool's usage depends on its first argument (the "command")
SPECIFYING ACCOUNTS
Where an account name is needed, it may be given as a full object path (e.g. /org/freedesktop/Telepathy/Account/gabble/jabber/example), or
as the unique account-specific suffix (e.g. gabble/jabber/example).
SPECIFYING PARAMETER SETTINGS
Many commands take arguments that represent Telepathy connection manager parameters (see the Telepathy Specification for details of these).
Each argument has the following form:
TYPE:NAME=VALUE
where TYPE is either int, uint, bool, or string (other parameter types exist, but are currently unsupported by mc-tool), NAME is the name
of the connection manager parameter (e.g. account or password), and VALUE is the parameter's value (with integers in decimal, and booleans
as 0 or 1).
The update command also accepts arguments of the form clear:NAME which delete the named parameter from the account configuration.
LIST
mc-tool list lists the available accounts.
ADD
mc-tool add adds an account. The connection manager and protocol can either be given as the name of a Mission Control profile, (e.g.
gtalk), or as a slash-separated connection manager name and protocol (e.g. gabble/jabber).
DISPLAY
mc-tool display ACCOUNT DISPLAY-NAME sets the DisplayName property of ACCOUNT to DISPLAY-NAME.
NICK
mc-tool nick ACCOUNT NICKNAME sets the Nickname property of ACCOUNT to NICKNAME.
ICON
mc-tool icon ACCOUNT ICON sets the Icon property of ACCOUNT to ICON.
SHOW
mc-tool show ACCOUNT shows information about ACCOUNT.
GET
mc-tool get ACCOUNT PARAMETER [PARAMETER...] shows the values of the given parameters of ACCOUNT.
ENABLE
mc-tool enable ACCOUNT sets the Enabled property of ACCOUNT to True.
DISABLE
mc-tool disable ACCOUNT sets the Enabled property of ACCOUNT to False.
AUTO-PRESENCE
mc-tool auto-presence ACCOUNT STATUS [MESSAGE] sets the AutomaticPresence property of ACCOUNT to STATUS with optional message MESSAGE.
REQUEST
mc-tool request ACCOUNT STATUS [MESSAGE] sets the RequestedPresence property of ACCOUNT to STATUS with optional message MESSAGE; this is
how you tell an account to connect or go offline, for example.
AUTO-CONNECT
mc-tool auto-connect ACCOUNT on sets the ConnectAutomatically property of ACCOUNT to True. mc-tool auto-connect ACCOUNT off sets it to
False.
Telepathy July 2009 MC-TOOL(1)