I/m a beginner so be easy. I have text files that live on an AIX server. The files come in and I've been charged with writing a shell script to email out that pulls the first date, and the last date of the file. I need to load these 2 dates into 2 separate variables. I can figure out the variables, but what I'm needing help on is what command to use and what syntax to pull the first and last date/time value for the 14th column in the text file. The columns are separated by a single tilde ~. This part is new to me, so I'd appreciate an experts assistance!
I haven't tried much in regards to printing this desired data. I'm hoping someone could tell me what command would be best to do this task, and possibly what parameters without being exact and doing it for me. Hope that helps.
How are you to determine the "first date" and "last date" from these two files?
eg
"first date" could be:
field #14 from 1st record of file 1
minimum value of field #14 from file 1 and file2
"last date" could be
field #14 from last record of file 2
maximum value of field #14 from file 1 and file2
most recent modification time of file1 and file2
In addition to what Chubler_XL has already said, if the dates to be used are based on the values in field #14 instead of being the dates on the 1st and last records in the file, you have to know the format of the date fields to determine how to perform the comparisons. And, if the values are to be extracted from the 1st and last data records in the file, we have to know if there are any header and/or trailer lines in the file.
This is why it is crucial that you give us a representative sample of the file(s) you will be processing.
Furthermore, you aren't at all clear about what tools are available for this project. You say the files you want to process are on a server. Will your script be run on that server while you are logged into that server? Will the files be located on one server while the script will be running on a different server?
The more details you hide from us, the less help we will be able to provide.
Here you go....i'm wanting to load a variable with the first and last column FirstExternalDateTime's values (last one would be 09032016011500PM) into an existing script. Please let me know if you have any ideas of how I can reference this particular file. See txt file attached.
If we only knew what you are talking about we might have some ideas.
Are you talking of rows or of columns? What tools are available and/or preferred (has been asked before)? What OS and shell version are you using?
Just some wild guessing: You want to ignore the header line, then from the second line extract field 14 (with ~ being the field separator) into variable1, and then, from the last line, extract field 14 into variable2.
Were this correct, and your shell were a recent bash or ksh , would this come close to what you want:
sorry, my terminology may be bad. I think AWK or SED would be the best native tools. I think you hit on what I was after. Just one row under the FirstExternalDateTime's for the first value and the one row under FirstExternalDateTime's last value. Let me take it for a spin and get back to you!
---------- Post updated at 04:41 PM ---------- Previous update was at 03:57 PM ----------
RudiC,
First and foremost, THANK YOU...was almost perfect. The provided code returned the following, including the comma:
09032016114500AM,
It didn't seem to return the very last row. Any quick thoughts?
Which is a bit hard to believe. The comma in my proposal above comes from the echo statement, and the two values are from line 2 and the LAST line of the "datafile.txt" that you attached. First thought would be the comma is in the data.
Are my assumptions in post#8 correct?
WHat results do get applying the proposal to the attached "datafile.txt"?
Does your other/new file obey the exactly same structure?
You still didn't answer the questions for your OS and shell. In bash , there's "parameter expansion/Substring Expansion": ${parameter:offset:length} that could fulfill your requirement. Give it a try and come back with the result, or any problem that might arise.
---------- Post updated at 02:05 PM ---------- Previous update was at 01:49 PM ----------
RudiC,
Please pardon my lack of experience here. I'm not sure how to use this suggestion to apply a date format 09032016011500PM into a readable format in a line of code such as
Parameter Expansion
.
.
.
${parameter:offset}
${parameter:offset:length}
Substring Expansion. Expands to up to length characters of the value of parameter starting at the character specified by offset. If parameter is @, an indexed
array subscripted by @ or *, or an associative array name, the results differ as described below. If length is omitted, expands to the substring of the value of
parameter starting at the character specified by offset and extending to the end of the value. length and offset are arithmetic expressions (see ARITHMETIC
EVALUATION below).
So, with your above $rdfirst variable containing the quoted value,
echo ${rdfirst:2:2}/${rdfirst:0:2}/
03/09/
shows how to proceed. Give it a try and come back with your results.