|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Find a blank field and replace values to NA
Post 302847117 by vgersh99 on Monday 26th of August 2013 10:57:35 AM
|
|
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a file 'test.out' with contents:
1|1|10|10|I|asdf|
2|1|10|10|I|sdfg|
4|1|10|10|I|hgfj|
34|0|10|10|I|sdg|
I want to modify the fifth column with value 'I' to 'A' for only the last line. Below is what I expect to see:
1|1|10|10|I|asdf|
2|1|10|10|I|sdfg|
... (3 Replies)
Discussion started by: ChicagoBlues
3 Replies
2. Shell Programming and Scripting
Hi All
I have a file.Below are few records of the file.
sample.txt
CPS,ES,843232910001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR735,ALL CALLS,01674840629
CPS,ES,843232670001,ESF81462,W N LINDSAY LTD,01674840629,09-FEB-2009,23-FEB-2009,CDR734,ALL... (2 Replies)
Discussion started by: king007
2 Replies
3. Shell Programming and Scripting
I want to find the top N entries for a certain field based on the values of another field.
For example if N=3, we want the 3 best values for each entry:
Entry1 ||| 100
Entry1 ||| 95
Entry1 ||| 30
Entry1 ||| 80
Entry1 ||| 50
Entry2 ||| 40
Entry2 ||| 20
Entry2 ||| 10
Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies
4. Shell Programming and Scripting
Hi everyone,
I was wondering how could from a file where each row is separated by tabulations, the row values where are in blank replace them by a string or value.
My file has this form:
26/01/09 13:45:00 0 0
26/01/09 14:00:00 1495.601318 0
26/01/09 14:15:00 1495.601318 0 ... (4 Replies)
Discussion started by: tonet
4 Replies
5. Shell Programming and Scripting
Hi all,
I have a huge file and I need to get ride of the fields 6-11 and replace the blanks in field 5 with a missing value(99999).
159,93848,5354,343,67898,45,677,5443,434,5545,45
677,45545,3522,244,
554,54344,3342,456,
344,43443,2344,444,23477... (12 Replies)
Discussion started by: GoldenFire
12 Replies
6. Shell Programming and Scripting
Something like vlookup in excel, column 2 in file 2 is blank and should be replaced by column 2 in file 1 based on comparing column 1 in both files.
file1
Code:
1234~abc~b~c~d~e~f~g~h~09/10/09
5678~def~b~c~d~e~f~g~h~12/06/10
8910~hij~b~c~d~e~f~g~h~03/28/13... (1 Reply)
Discussion started by: sigh2010
1 Replies
7. Shell Programming and Scripting
Hi,
I've a pipe delimited file and wanted to replace the 3rd field to 099990 where the values are null. How can I achieve it using awk or sed.
20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S
20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S... (12 Replies)
Discussion started by: rudoraj
12 Replies
8. Shell Programming and Scripting
Find a blank field
Hi
I have set of fields that have some blank values, how to find that and get its line noumbers in output file.
Ex:
Col1 col2 col3
11 ss 103
12 104
13 105
14 se 106 (2 Replies)
Discussion started by: Shenbaga.d
2 Replies
9. UNIX for Beginners Questions & Answers
I have a csv file as given below,
org1 org2 org3 org4 org5
gene1 100 80 90 80 150
gene2 30 70 50 50 115
gene3 40 120 60 40 105
gene4 20 72 40 60 20
I need to replace the fields are having values greater than 100 with "TRUE". I used the following commands to replace... (6 Replies)
Discussion started by: dineshkumarsrk
6 Replies
LEARN ABOUT DEBIAN
kf
KF(1) BSD General Commands Manual KF(1) NAME
kf -- securely forward tickets SYNOPSIS
kf [-p port | --port=port] [-l login | --login=login] [-c ccache | --ccache=ccache] [-F | --forwardable] [-G | --no-forwardable] [-h | --help] [--version] host ... DESCRIPTION
The kf program forwards tickets to a remote host through an authenticated and encrypted stream. Options supported are: -p port, --port=port port to connect to -l login, --login=login remote login name -c ccache, --ccache=ccache remote cred cache -F, --forwardable forward forwardable credentials -G, --no-forwardable do not forward forwardable credentials -h, --help --version kf is useful when you do not want to enter your password on a remote host but want to have your tickets one for example AFS. In order for kf to work you will need to acquire your initial ticket with forwardable flag, i.e. kinit --forwardable. telnet is able to forward tickets by itself. SEE ALSO
kinit(1), telnet(1), kfd(8) Heimdal July 2, 2000 Heimdal