Extract error records based on specific criteria from Unix file
Hi,
I look for a awk one liner for below issue.
input file
All lines should be started with ABC as first field. If a record has another value for 1st field, the previuos record with ABC also an error record. I need to get the output as below
i have written a code by using while ... do ... done. but for bigger files this takes lot of time as this code reads file record by record.
Please help.
Hi All,
I need to select only those records having a non zero record in the first column of a comma delimited file.
Suppose my input file is having data like:
"0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005"
"0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"... (2 Replies)
I'll try explain this as best I can. Let me know if it is not clear.
I have large text files that contain data as such:
143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test
line 2 test
line 3 test
143593503 09-08-20 09:02:13... (3 Replies)
Hello People,
I have the following contents in an XML file
...........
...........
..........
...........
<Details = "Sample Details">
<Name>Bob</Name>
<Age>34</Age>
<Address>CA</Address>
<ContactNumber>1234</ContactNumber>
</Details>
...........
.............
.............. (4 Replies)
I have a huge file (about 2 millions records) contains data separated by “,” (comma). As part of the requirement, I can't change the format. The objective is to remove some of the records with the following condition. If the 23rd field on each line start with 302 , I need to remove that from the... (4 Replies)
Hello Friends,
I have a file(InputFile.csv) with the following columns(the columns are pipe-delimited):
ColA|ColB|ColC|ColD|ColE|ColF
Now for this file, I have to get those records which fulfil the following condition:
If "ColB" is NOT NULL and "ColD" has values one of the following... (9 Replies)
Hi,
I have a shell script which extracts records form oracle to unix file.
sqlplus -s ${WMD_DM_CONNECT} <<EOF >$tmpfile
set heading off
set pagesize 0
set feedback off
select CD_DESC||'|'||CD_ID||'|'||'Arun'||'|'||'Montu' from WMD_SYS_CD_LKUP
where CD_TYP =... (5 Replies)
I have a folder containing text files. I need to extract specific lines from the files of this folder based on another file input.txt. How can I do this with awk/sed?
file1
ARG 81.9 8 81.9 0
LEU 27.1 9 27.1 0
PHE .0 10 .0 0
ASP 59.8 11 59.8 0
ASN 27.6 12 27.6 0
ALA .0 13 .0 0... (5 Replies)
In the file below I am trying to extract a specific instance of path, if the adjacent plugin": "/rundb/api/v1/plugin/49/. Thank you :).
file
"path": "/results/analysis/output/Home/Auto_user_S5-00580-4-Medexome_65_028/plugin_out/FileExporter_out.52", "plugin": "/rundb/api/v1/plugin/49/",... (8 Replies)
I'm new to shell programming, I have a huge text file in the following format, where columns are separated by single space:
ACA MEX 4O_ $98.00 $127.40 $166.60 0:00 0:00 0 ;
ACA YUL TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ;
ACA YYZ TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ;
ADZ YUL TS_ $300.00... (3 Replies)
I have two files and would need to filter out records based on certain criteria, these column are of variable lengths, but the lengths are uniform throughout all the records of the file. I have shown a sample of three records below. Line 1-9 is the item number "0227546_1" in the case of the first... (15 Replies)
Discussion started by: MIA651
15 Replies
LEARN ABOUT OSF1
kas_stringtokey
KAS_STRINGTOKEY(8) AFS Command Reference KAS_STRINGTOKEY(8)NAME
kas_stringtokey - Converts a character string into an octal key
SYNOPSIS
kas stringtokey -string <password string>
[-cell <cell name>] [-help]
kas str -s <password string> [-c <cell name>] [-h]
DESCRIPTION
The kas stringtokey command converts the character string specified with the -string argument into an octal string suitable for use as an
encryption key.
The kas command interpreter generates the octal key by using an encryption algorithm on the combination of the specified string and the
name of the local cell (as recorded in the local /etc/openafs/ThisCell file). Use the -cell argument to convert a string into a key
appropriate for a cell other than the local one.
CAUTIONS
This command writes the key to the standard output stream, on which it can possibly be intercepted by third parties. It is not very secure
to use the key in an actual Authentication Database entry.
OPTIONS -string <password string>
Specifies the character string to convert into an octal key.
-cell <cell name>
Specifies the complete Internet domain name of the cell to combine with the password string while generating the key. If this argument
is omitted, the kas command interpreter determines the name of the local cell by consulting:
o First, the value of the environment variable AFSCELL.
o Second, the cellname in the /etc/openafs/ThisCell file on the local machine.
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The output is of the following form:
Converting I<password string> in realm 'I<cell_name>' yields key='I<key>'.
EXAMPLES
The following example shows the octal key equivalent of the string "new_pswd" in the ABC Corporation cell.
% kas stringtokey new_pswd
Converting new_pswd in realm 'ABC.COM' yields
key='346307364320263233342354'.
PRIVILEGE REQUIRED
None, and no password is required.
SEE ALSO ThisCell(5), kas(8)COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 KAS_STRINGTOKEY(8)