04-24-2020
Add Date in Column data
Hi
Need to add Date to column data as belwo
Input
Code :
Date: 2020-04-24
Time Counter C00005A_1 C000B_1
19:00 AC_Sli 10 N/A
19:00 Ac_MG N/A 50
19:00 L_Thhut_MCG 100 N/A
Date: 2020-04-25
Time Counter C00005A_1 C000B_1
19:00 AC_Sli 10 N/A
19:00 Ac_MG N/A 50
19:00 L_Thhut_MCG 100 N/A
20:00 L_Thhut_MCG 100 N/A
Date: 2020-04-26
Time Counter C00005A_1 C000B_1
19:00 AC_Sli 10 N/A
19:00 Ac_MG N/A 54
19:00 L_Thhut_MCG 110 N/A
Output:-
Code :
Time Counter C00005A_1 C000B_1
2020-04-24_19:00 AC_Sli 10 N/A
2020-04-24_19:00 Ac_MG N/A 50
2020-04-24_19:00 L_Thhut_MCG 100 N/A
2020-04-25_19:00 AC_Sli 10 N/A
2020-04-25_19:00 Ac_MG N/A 50
2020-04-25_19:00 L_Thhut_MCG 100 N/A
2020-04-25_20:00 L_Thhut_MCG 100 N/A
2020-04-26_19:00 AC_Sli 10 N/A
2020-04-26_19:00 Ac_MG N/A 54
2020-04-26_19:00 L_Thhut_MCG 110 N/A
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Input file:
Germany 10 500 5000
Germany 20 500 5000
Germany 50 10 500
England 5 10 25
USA 30 25 55
USA 20 35 90
Japan 2 5 60
Singapore 50 30 90
Singapore 150 230 290
Output file:
Germany 10 500 5000
Germany 20 500 5000
Germany 50 10 500
England 5 10 25 (7 Replies)
Discussion started by: patrick87
7 Replies
2. Shell Programming and Scripting
Looks at the most efficient way to add up the column of data based off of the rows.
Random data
Name-Number-ID
Sarah-2.0-15
Bob-6.3-15
Sally-1.0-10
James-1.0-10
Scotty-10.7-15
So I would select all those who have ID = 15 and then add up total number
read - p "Enter ID number" Num
... (3 Replies)
Discussion started by: Ironguru
3 Replies
3. Ubuntu
Hi All
I need to add a column on my existing data file. I know similar posts are there but none of them were meeting my requirement. My input is
1.20 3.44 4.88
5.11 4.99 3.22
1.89 3.89 2.90
Desired output
1 1.20 3.44 4.88
2 5.11 4.99 3.22
3 1.89 3.89 2.90
I will... (2 Replies)
Discussion started by: mahbub03
2 Replies
4. Emergency UNIX and Linux Support
Hi Experts,
I am trying to add one variable value as the first value in a file speparated by "" (space) delimiter. Can you please let me know how I can do this using bash script.
Following is my file.
1635 ABCD 3m9ka COMPLETE
0526 AJAY 3m1da COMPLETE
0419 INDIA 3m3zi INCOMPLETE
The... (3 Replies)
Discussion started by: ajaypatil_am
3 Replies
5. Shell Programming and Scripting
hi all Please assist i need to add current date as data to load to a database:
the script is as follow:
#!/bin/ksh
DIR=/export/home/yani_m/scripts/scrip_out_put/
DIR2=/export/home/yani_m/scripts/scrip_out_put/calc/
Date=$1
File22="disk_"$Date
Server=$2
iofiles=$DIR"/*"$Date"*_Ynr.dat"... (4 Replies)
Discussion started by: LucyYani
4 Replies
6. Shell Programming and Scripting
Hi,
I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates.
NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15... (2 Replies)
Discussion started by: samrat dutta
2 Replies
7. Shell Programming and Scripting
Hi
I have file with number status and date1 and date1 field,
want add a column today between column date1 and date2.
file1.txt
number status date1 date2
===== ==== === =====
34567 open 27/06/13 28/06/13
45678 open 27/06/13 28/06/13
43567 open 27/06/13 28/06/13 ... (1 Reply)
Discussion started by: vijay_rajni
1 Replies
8. UNIX for Advanced & Expert Users
Hi ,
I have a requirement to append file creation date to each row in a file for all the files in a directory.
Please help
Thanks,
Pavan (2 Replies)
Discussion started by: Pavan Ram B S
2 Replies
9. Shell Programming and Scripting
HI Guys,
I want add one extra Column base on 3rd Column .
Input :-
M204 MS204_154 :vsDataUeMe
M204 MS204_154 es:sMeasure 0
M204 MS204_154 es:90ilterCoe 9
M204 MS204_154 es:searchE9090ortTime 40
M204 MS204_154 es:servOrPrioI90HoTimer 4000
M204 MS204_154 es:ueMeajllls154545 TRUE... (5 Replies)
Discussion started by: pareshkp
5 Replies
10. UNIX for Beginners Questions & Answers
Hola
Como hacer:
C:\System\SystemRun.4gl
C:\System\SystemRunPrint.4gl
C:\System\SystemViews.4gl
Resultado:
SystemRun.4gl C:\System\SystemRun.4gl
SystemRunPrint.4gl C:\System\SystemRunPrint.4gl
SystemViews.4gl C:\System\SystemViews.4gl... (0 Replies)
Discussion started by: tlaloc
0 Replies
LEARN ABOUT DEBIAN
tm::coverage
TM::Coverage(3pm) User Contributed Perl Documentation TM::Coverage(3pm)
NAME
TM::Coverage - Topic Maps, Code Coverage
DESCRIPTION
This auxiliary package keeps track of the code coverage. Probably quite irrelevant for a user.
Automatically generated for TM (1.44).
---------------------------- ------ ------ ------ ------ ------ ------ ------
File stmt bran cond sub pod time total
---------------------------- ------ ------ ------ ------ ------ ------ ------
blib/lib/TM.pm 96.4 84.5 58.0 93.7 90.6 27.5 89.6
blib/lib/TM/Analysis.pm 100.0 90.9 n/a 100.0 100.0 0.0 97.5
blib/lib/TM/AsTMa/Fact.pm 100.0 n/a n/a 100.0 n/a 0.0 100.0
blib/lib/TM/AsTMa/Fact2.pm 100.0 n/a n/a 100.0 n/a 0.0 100.0
blib/lib/TM/Bulk.pm 76.8 71.4 62.5 85.7 100.0 0.0 75.3
blib/lib/TM/CTM/CParser.pm 65.6 34.3 31.0 84.6 0.0 1.6 52.5
blib/lib/TM/CTM/Parser.pm 90.9 50.0 n/a 100.0 0.0 0.0 79.4
blib/lib/TM/DM.pm 100.0 65.0 66.7 100.0 n/a 0.0 96.5
blib/lib/TM/Graph.pm 99.1 88.5 n/a 100.0 100.0 0.0 97.4
blib/lib/TM/Index.pm 100.0 80.0 60.0 100.0 83.3 0.3 87.8
.../Index/Characteristics.pm 100.0 100.0 n/a 100.0 0.0 0.0 97.0
blib/lib/TM/Index/Match.pm 98.5 87.5 n/a 100.0 100.0 0.5 97.6
blib/lib/TM/LTM/CParser.pm 84.9 45.3 42.7 98.2 0.0 0.2 67.8
blib/lib/TM/LTM/Parser.pm 95.7 62.5 50.0 100.0 0.0 0.0 87.1
blib/lib/TM/Literal.pm 45.8 0.0 11.8 30.0 0.0 0.4 24.2
blib/lib/TM/MapSphere.pm 96.5 84.6 68.8 100.0 100.0 0.0 91.7
.../TM/Materialized/AsTMa.pm 100.0 n/a n/a 100.0 0.0 0.0 95.5
...ib/TM/Materialized/LTM.pm 100.0 n/a n/a 100.0 0.0 0.0 95.5
.../TM/Materialized/MLDBM.pm 100.0 83.3 n/a 100.0 0.0 0.0 92.6
...b/TM/Materialized/Null.pm 100.0 n/a n/a 100.0 n/a 0.0 100.0
...TM/Materialized/Stream.pm 100.0 100.0 100.0 100.0 0.0 0.0 96.0
...ib/TM/Materialized/XTM.pm 100.0 n/a n/a 100.0 0.0 0.0 96.7
blib/lib/TM/PSI.pm 100.0 n/a n/a 100.0 n/a 0.0 100.0
blib/lib/TM/QL.pm 91.4 61.5 66.7 100.0 50.0 0.1 83.9
blib/lib/TM/QL/CParser.pm 76.2 42.4 41.9 90.3 0.0 9.1 62.0
blib/lib/TM/QL/PE.pm 83.8 77.3 80.0 91.7 0.0 52.5 80.5
blib/lib/TM/QL/TS.pm 65.2 35.4 27.8 70.8 53.3 2.4 56.9
blib/lib/TM/ResourceAble.pm 88.1 87.5 n/a 100.0 100.0 0.0 90.0
.../TM/ResourceAble/MLDBM.pm 100.0 75.0 n/a 100.0 0.0 0.0 94.2
blib/lib/TM/Serializable.pm 94.9 65.6 100.0 100.0 100.0 0.0 84.1
.../TM/Serializable/AsTMa.pm 99.1 87.9 66.7 100.0 100.0 0.0 94.2
...TM/Serializable/Dumper.pm 100.0 n/a n/a 100.0 0.0 0.0 93.5
...ib/TM/Serializable/LTM.pm 94.1 n/a n/a 83.3 100.0 0.0 92.0
...ib/TM/Serializable/XTM.pm 96.3 85.2 72.9 100.0 100.0 0.2 91.5
.../lib/TM/Synchronizable.pm 100.0 75.0 100.0 100.0 100.0 0.0 97.2
...M/Synchronizable/MLDBM.pm 100.0 50.0 n/a 100.0 0.0 0.0 89.3
...nchronizable/MapSphere.pm 100.0 63.6 64.3 100.0 100.0 0.0 88.6
...TM/Synchronizable/Null.pm 100.0 n/a n/a 100.0 0.0 0.0 87.5
blib/lib/TM/Tau.pm 100.0 91.7 80.0 100.0 0.0 0.0 95.6
blib/lib/TM/Tau/Federate.pm 63.2 39.3 n/a 62.5 27.3 0.0 54.5
blib/lib/TM/Tau/Filter.pm 100.0 91.7 66.7 100.0 50.0 0.0 90.0
.../TM/Tau/Filter/Analyze.pm 100.0 n/a n/a 100.0 100.0 0.0 100.0
blib/lib/TM/Tree.pm 100.0 57.1 44.4 100.0 66.7 0.0 88.0
blib/lib/TM/Utils.pm 100.0 50.0 n/a 100.0 0.0 0.0 89.3
...ib/TM/Utils/TreeWalker.pm 100.0 100.0 n/a 100.0 0.0 0.0 96.0
...ib/TM/Workbench/Plugin.pm 100.0 n/a n/a 100.0 0.0 0.0 75.0
...M/Workbench/Plugin/Tau.pm 87.5 50.0 n/a 80.0 0.0 0.0 73.1
yapp/astma-fact.yp 96.9 91.5 73.3 97.8 0.0 4.8 92.7
yapp/astma2-fact.yp 97.4 91.6 58.3 100.0 0.0 0.2 91.6
Total 76.8 45.2 40.2 91.2 57.0 100.0 63.8
---------------------------- ------ ------ ------ ------ ------ ------ ------
SEE ALSO
TM
COPYRIGHT AND LICENSE
Copyright 200[8] by Robert Barta, <drrho@cpan.org>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2008-10-05 TM::Coverage(3pm)