Change a word based upon the file content
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
I have a file which contains timestamp and date in the second column. If the line contains one of the word then it need to be replace like below. Any help is appreciated.
File:
a smallint
b timestamp
c date
d varchar
O/P:
a smallint
dateformat(b,'YYYY-MM-DD HH:NN:SS.sss')
dateformat(c.'YYYY-MM-DD')
d varchar
If I execute this below command as a single awk then I am getting output but if I use else condition then I am getting error.
awk 'if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD HH':'NN':'SS'.'sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD)" ' test.out
Error:
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
shell-script shell
asked 22 mins ago
Josh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
0
down vote
favorite
I have a file which contains timestamp and date in the second column. If the line contains one of the word then it need to be replace like below. Any help is appreciated.
File:
a smallint
b timestamp
c date
d varchar
O/P:
a smallint
dateformat(b,'YYYY-MM-DD HH:NN:SS.sss')
dateformat(c.'YYYY-MM-DD')
d varchar
If I execute this below command as a single awk then I am getting output but if I use else condition then I am getting error.
awk 'if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD HH':'NN':'SS'.'sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD)" ' test.out
Error:
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
shell-script shell
asked 22 mins ago
Josh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a file which contains timestamp and date in the second column. If the line contains one of the word then it need to be replace like below. Any help is appreciated.
File:
a smallint
b timestamp
c date
d varchar
O/P:
a smallint
dateformat(b,'YYYY-MM-DD HH:NN:SS.sss')
dateformat(c.'YYYY-MM-DD')
d varchar
If I execute this below command as a single awk then I am getting output but if I use else condition then I am getting error.
awk 'if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD HH':'NN':'SS'.'sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD)" ' test.out
Error:
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
shell-script shell
asked 22 mins ago
Josh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a file which contains timestamp and date in the second column. If the line contains one of the word then it need to be replace like below. Any help is appreciated.
File:
a smallint
b timestamp
c date
d varchar
O/P:
a smallint
dateformat(b,'YYYY-MM-DD HH:NN:SS.sss')
dateformat(c.'YYYY-MM-DD')
d varchar
If I execute this below command as a single awk then I am getting output but if I use else condition then I am getting error.
awk 'if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD HH':'NN':'SS'.'sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'''YYYY-MM-DD)" ' test.out
Error:
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
awk: if ($2=="timestamp") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD HH:NN:SS.sss)" else ($2=="date") $3="dataformat("; ; print $3 $1 ",'YYYY-MM-DD)"
awk: ^ syntax error
shell-script shell
shell-script shell
asked 22 mins ago
Josh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 22 mins ago
Josh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 22 mins ago
Josh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 22 mins ago
Josh
1
asked 22 mins ago
Josh
1
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Josh is a new contributor. Be nice, and check out our Code of Conduct.
Josh is a new contributor. Be nice, and check out our Code of Conduct.
Josh is a new contributor. Be nice, and check out our Code of Conduct.
Josh is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f477154%2fchange-a-word-based-upon-the-file-content%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password