9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In the awk, thanks you @RavinderSingh13, for the help in below, hopefully it is close as I am trying to update the value in $12 of the tab-delimeted file2 with the matching value in $1 of the space delimeted file1. I have added comments for each line as well. Thank you :).
awk
awk '$12 ==... (10 Replies)
Discussion started by: cmccabe
10 Replies
2. Shell Programming and Scripting
In the perl below I am trying to set/update the value of $14 (last field) in file2, using the matching NM_ in $12
or $9 in file2 with the NM_ in $2 of file1.
The lengths of $9 and $12 can be variable but what is consistent is the start pattern will always be NM_ and the end pattern is always
;... (4 Replies)
Discussion started by: cmccabe
4 Replies
3. Shell Programming and Scripting
I am trying to use awk to update the below tab-delimited file based on 5 different rules/conditions. The final output is also
tab-delimited and each line in the file will meet one of the conditions. My attemp is below as well though I am not very confident in it. Thank you :).
Condition 1: The... (10 Replies)
Discussion started by: cmccabe
10 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I need to remove all files except the most update data based on date on filename
Input
data_AIDS_20150312.txt
data_AIDS_20150311.txt
data_AIDS_20150411.txt
data_AIDS_20140312.txt
the most updated data is data_AIDS_20150411.txt, so I'll remove other files. My expected output... (3 Replies)
Discussion started by: radius
3 Replies
5. Shell Programming and Scripting
i want to run update query for oracle which is in up.sql taking values from a.csv.
I have implemented shell script to do it.
extn="perl"
ls -1 | while read file
do
echo "$file,$extn" > a.csv
done
up.sql contains
update file_list set filename=$1 where extn=$2;
The code to update is... (2 Replies)
Discussion started by: millan
2 Replies
6. UNIX for Dummies Questions & Answers
Hi Experts,
can guide how we can Update a Database Table using a txt file source Using
Unix Shell Scripts.
What are the Cron Jobs codes can written to Update DB table.
txt file contains record like data.
US 09/03/2012 User DocType DocID.
these above feilds in txt files need to be updated in... (4 Replies)
Discussion started by: mahesh.sap
4 Replies
7. Shell Programming and Scripting
The purpose of this script is to scan the /etc/passwd file one line at a time comparing the usernames to the usernames found in a database table. I will later locked every account which is not in the database table.
I have export the userlist from the database in a file (/tmp/userlist). It... (1 Reply)
Discussion started by: Banks187
1 Replies
8. Shell Programming and Scripting
Hi
i am new to scripting. i have a file file.dat with content as :
CONTENT_STORAGE PERCENTAGE FLAG:
/storage_01 64% 0
/storage_02 17% 1
I need to update the value of FLAG for a particular CONTENT_STORAGE value
I have written the following code
#!/bin/sh
threshold=20... (1 Reply)
Discussion started by: kichu
1 Replies
9. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
lsearch(3C) lsearch(3C)
NAME
lsearch(), lfind() - linear search and update
SYNOPSIS
DESCRIPTION
is a linear search routine generalized from Knuth (6.1) Algorithm S.
It returns a pointer into a table indicating where a datum may be found. If the datum does not occur, it is added at the
end of the table.
key Points to the datum to be sought in the table.
base Points to the first element in the table.
nelp Points to an integer containing the current number of elements in the table. The integer is incremented
if the datum is added to the table.
compar Name of the comparison function which the user must supply for example). It is called with two argu-
ments that point to the elements being compared. The function must return zero if the elements are
equal and non-zero otherwise.
Same as except that if the datum is not found, it is not added to the table. Instead, a NULL pointer is returned.
Notes
The pointers to the key and the element at the base of the table should be of type pointer-to-element, and cast to type pointer-to-charac-
ter.
The comparison function need not compare every byte, so arbitrary data may be contained in the elements in addition to the values being
compared.
Although declared as type pointer-to-character, the value returned should be cast into type pointer-to-element.
EXAMPLES
This code fragment reads in <= strings of length <= and stores them in a table, eliminating duplicates.
...
...
RETURN VALUE
If the searched-for datum is found, both and return a pointer to it. Otherwise, returns NULL and returns a pointer to the newly added ele-
ment.
WARNINGS
Undefined results can occur if there is not enough room in the table to add a new item.
SEE ALSO
bsearch(3C), hsearch(3C), tsearch(3C), thread_safety(5).
STANDARDS CONFORMANCE
lsearch(3C)