Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Add Date in Column data
Top Forums UNIX for Beginners Questions & Answers Add Date in Column data Post 303046157 by RudiC on Saturday 25th of April 2020 03:59:21 PM
Old 04-25-2020
I'm afraid that sed script doesn't lead you anywhere. Try
Code:
$ awk '/^Date/ {TMP = $2; next} /^Time/ {if (!HDDone++) print; next} !/^ *$/ {print TMP "_" $0}' file
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

How to add a new line between different column data content?

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

Awk to add selected row column data

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

How to add a data column in existing file

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

Trying to add currrent date as the first the first column in the file

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

Add current date to the data file

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

Sort data by date and then search by column

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

Need to add a date column (today's date) in file

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

Add file creation date as new column

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

Add Column base on other Column Data

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

How to add a column of another data from another column?

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

grid-cert-info

GRID-CERT-INFO(1)						  Globus Commands						 GRID-CERT-INFO(1)

NAME

       grid-cert-info - Display information about a certificate

SYNOPSIS

       grid-cert-info [-help] [-usage] [-version] [-versions]

       grid-cert-info [-file CERTIFICATE-FILE] [-rfc2253] [-all]
		      [-subject] | [-s]
		      [-issuer] | [-i]
		      [-issuerhash] | [-ih]
		      [-startdate] | [-sd]
		      [-endate] | [-ed]

DESCRIPTION

       The grid-cert-info program displays information contained within a certificate file. By default it shows a text representation of the
       entire certificate. Specific facts about the certificate can be shown instead by using command-line options. If any of those options are
       used, then the default display is suppressed. This can be added to the output by using the -all command-line option.

       If multiple display options are included on the command-line, the facts related to those will be displayed on separate lines in the order
       that they occur. If an option is specified multiple time, that fact will be displayed multiple times.

       The full set of command-line options to grid-cert-info are:

       -help, -usage
	   Display the command-line options to grid-cert-info and exit.

       -version, -versions
	   Display the version number of the grid-cert-info command. The second form includes more details.

       -file CERTIFICATE-FILE
	   Display information about the first certificate contained in the file named by CERTIFICATE-FILE instead of the default user
	   certificate.

       -rfc2253
	   Display X.509 distinguished names using the string representation defined in RFC 2253 instead of the default OpenSSL oneline format.

       -all
	   Display the text representation of the entire certificate in addition to any other facts requested by command-line options. This is the
	   default if no fact-specific command-line options are used.

       -subject, -s
	   Display the subject name of the X.509 certificate.

       -issuer, -i
	   Display the issuer name of the X.509 certificate.

       -issuerhash, -ih
	   Display the default hash of the issuer name of the X.509 certificate. This can be used to locate which CA certificate in the trusted
	   certificate directory issued the certifcate being inspected.

       -startdate, -sd
	   Display a string representation of the date and time when the certificate is valid from. This is displayed in the format used by the
	   OpenSSL x509 command.

       -enddate, -dd
	   Display a string representation of the date and time when the certificate is valid until. This is displayed in the format used by the
	   OpenSSL x509 command.

EXAMPLES

       Display the validity times for the default certificate

	   % grid-cert-info -sd -ed
	   Aug 31 12:33:47 2009 GMT
	   Aug 31 12:33:47 2010 GMT

       Display the same information about a different certificate specified on the command-line

	   % grid-cert-info -sd -ed -f /etc/grid-security/hostcert.pem
	   Jan 21 12:24:48 2003 GMT
	   Jul 15 11:30:57 2020 GMT

       Display the subject of a certificate in both the default and the RFC 2253 forms.

	   % grid-cert-info -subject
	   /DC=org/DC=example/DC=grid/CN=Joe User
	   % grid-cert-info -subject -rfc2253
	   CN=Joe User,DC=grid,DC=example,DC=org

ENVIRONMENT VARIABLES

       The following environment variables affect the execution of grid-cert-info:

       X509_USER_CERT
	   Path to the default certificate file to inspect.

AUTHOR

       University of Chicago

Globus Toolkit 5.0.1						    03/22/2010							 GRID-CERT-INFO(1)
All times are GMT -4. The time now is 07:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy