Sponsored Content
Top Forums Programming select value from 'value' column if the Value2 is having a particular value. Post 302447014 by Corona688 on Friday 20th of August 2010 01:15:24 PM
Old 08-20-2010
SQL is a generic term. There's lots of different implementations of SQL, many of which only vaguely resemble each other.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Select Record based on First Column

Hi, I have a file with multiple records...and I have to select records based on first column....here is the sample file... I01,abc,125,1a2,LBVI02 I01,abc,126,2b5,LBVI02 I02,20070530,254,abc,LLBI01 I02,20070820,111,bvd,NGBI01 I need all records with I01 in first field in one file and... (8 Replies)
Discussion started by: mgirinath
8 Replies

2. Shell Programming and Scripting

select a column

I've a file like this: andrea andre@lol.com october antonio@lol.com marco 45247@pop.com kk@pop.com may pollo@lol.com mary mary@lol.com can I select only the column with email adress? can I utilise a filter with @ ? I want obtain this: ... (2 Replies)
Discussion started by: alfreale
2 Replies

3. UNIX for Dummies Questions & Answers

select first column of file

Hi, Following is my file output 247 Sleep 25439 NULL 259 Sleep 25460 NULL 277 Sleep 15274 NULL 361 Sleep 2 NULL 362 Sleep 202 NULL I want to select only first column to other file How can... (2 Replies)
Discussion started by: kaushik02018
2 Replies

4. Shell Programming and Scripting

How to select and edit on a particular column?

How can I use awk to pick a particular column and work on it? For example, I want to count the number of characters in column10 that are separated by |? Thank you. (2 Replies)
Discussion started by: ivpz
2 Replies

5. Shell Programming and Scripting

SQL select all but not if it is already in an other column

I know I know.. for sure one of the easier mysql statements. But somehow I can not figure out this. I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row) data_12 ... (6 Replies)
Discussion started by: lowmaster
6 Replies

6. UNIX for Dummies Questions & Answers

to select according to the second column..!!

the input is : 6298 | anna | chennai | 7/4/08 3981 | dastan | bagh | 8/2/07 6187 | galma | london | 9/5/01 3728 | gonna | kol | 8/2/10 3987 | hogja | mumbai | 8/5/09 2898 | homy | pune | 7/4/09 9167 | tamina | ny | 8/3/10 4617 | vazir | ny now how to get the following output : 3987 |... (4 Replies)
Discussion started by: adityamitra
4 Replies

7. Shell Programming and Scripting

select last column

Hi! From a file the format of whichis as in the sample here below, I need to get two files having just 2 columns, being - for the first file - the 2nd than the 1st from the original file; and - for the second file - the LAST then the 1st column of the original file. Moreover, I would sort the... (3 Replies)
Discussion started by: mjomba
3 Replies

8. Shell Programming and Scripting

To select only column starting with a particular value

Hi all, Am using awk to reformat an existing file cat $INP_FILE1 | while read line do echo "$line" | nawk ' BEGIN {FS=","} {print("5",$1,$28,"$27",$26)}' >> $OUT_FILE1 done my question is, i would like to read lines that are starting with particular value only example ... (9 Replies)
Discussion started by: selvankj
9 Replies

9. Shell Programming and Scripting

Select record having different value in second column

I want records which have more than one and different value in the second column on the below sample file. Ex, I have the samle file below :- XYZ 1 XYZ 3 abc 1 abc 1 qwe 2 qwe 1 qwe 3 I want to select XYZ and QWE line only. (6 Replies)
Discussion started by: Sanjeev Yadav
6 Replies

10. Shell Programming and Scripting

SELECT and wrapping to next column

Hi all, Am trying to write a menu driven script using SELECT and if I have more than 4 options, it wraps to the next column. That is if I have 6 choices, items 5 and 6 are in the second column. Is there any settings that control this behavior or is it due to some stty settings? stty -a... (3 Replies)
Discussion started by: newbie_01
3 Replies
orddict(3erl)						     Erlang Module Definition						     orddict(3erl)

NAME
orddict - Key-Value Dictionary as Ordered List DESCRIPTION
Orddict implements a Key - Value dictionary. An orddict is a representation of a dictionary, where a list of pairs is used to store the keys and values. The list is ordered after the keys. This module provides exactly the same interface as the module dict but with a defined representation. One difference is that while dict considers two keys as different if they do not match ( =:= ), this module considers two keys as different if and only if they do not com- pare equal ( == ). DATA TYPES
ordered_dictionary() as returned by new/0 EXPORTS
append(Key, Value, Orddict1) -> Orddict2 Types Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() This function appends a new Value to the current list of values associated with Key . An exception is generated if the initial value associated with Key is not a list of values. append_list(Key, ValList, Orddict1) -> Orddict2 Types ValList = [Value] Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() This function appends a list of values ValList to the current list of values associated with Key . An exception is generated if the initial value associated with Key is not a list of values. erase(Key, Orddict1) -> Orddict2 Types Key = term() Orddict1 = Orddict2 = ordered_dictionary() This function erases all items with a given key from a dictionary. fetch(Key, Orddict) -> Value Types Key = Value = term() Orddict = ordered_dictionary() This function returns the value associated with Key in the dictionary Orddict . fetch assumes that the Key is present in the dictio- nary and an exception is generated if Key is not in the dictionary. fetch_keys(Orddict) -> Keys Types Orddict = ordered_dictionary() Keys = [term()] This function returns a list of all keys in the dictionary. filter(Pred, Orddict1) -> Orddict2 Types Pred = fun(Key, Value) -> bool() Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() Orddict2 is a dictionary of all keys and values in Orddict1 for which Pred(Key, Value) is true . find(Key, Orddict) -> {ok, Value} | error Types Key = Value = term() Orddict = ordered_dictionary() This function searches for a key in a dictionary. Returns {ok, Value} where Value is the value associated with Key , or error if the key is not present in the dictionary. fold(Fun, Acc0, Orddict) -> Acc1 Types Fun = fun(Key, Value, AccIn) -> AccOut Key = Value = term() Acc0 = Acc1 = AccIn = AccOut = term() Orddict = ordered_dictionary() Calls Fun on successive keys and values of Orddict together with an extra argument Acc (short for accumulator). Fun must return a new accumulator which is passed to the next call. Acc0 is returned if the list is empty. The evaluation order is undefined. from_list(List) -> Orddict Types List = [{Key, Value}] Orddict = ordered_dictionary() This function converts the Key - Value list List to a dictionary. is_key(Key, Orddict) -> bool() Types Key = term() Orddict = ordered_dictionary() This function tests if Key is contained in the dictionary Orddict . map(Fun, Orddict1) -> Orddict2 Types Fun = fun(Key, Value1) -> Value2 Key = Value1 = Value2 = term() Orddict1 = Orddict2 = ordered_dictionary() map calls Func on successive keys and values of Orddict to return a new value for each key. The evaluation order is undefined. merge(Fun, Orddict1, Orddict2) -> Orddict3 Types Fun = fun(Key, Value1, Value2) -> Value Key = Value1 = Value2 = Value3 = term() Orddict1 = Orddict2 = Orddict3 = ordered_dictionary() merge merges two dictionaries, Orddict1 and Orddict2 , to create a new dictionary. All the Key - Value pairs from both dictionaries are included in the new dictionary. If a key occurs in both dictionaries then Fun is called with the key and both values to return a new value. merge could be defined as: merge(Fun, D1, D2) -> fold(fun (K, V1, D) -> update(K, fun (V2) -> Fun(K, V1, V2) end, V1, D) end, D2, D1). but is faster. new() -> ordered_dictionary() This function creates a new dictionary. size(Orddict) -> int() Types Orddict = ordered_dictionary() Returns the number of elements in an Orddict . store(Key, Value, Orddict1) -> Orddict2 Types Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() This function stores a Key - Value pair in a dictionary. If the Key already exists in Orddict1 , the associated value is replaced by Value . to_list(Orddict) -> List Types Orddict = ordered_dictionary() List = [{Key, Value}] This function converts the dictionary to a list representation. update(Key, Fun, Orddict1) -> Orddict2 Types Key = term() Fun = fun(Value1) -> Value2 Value1 = Value2 = term() Orddict1 = Orddict2 = ordered_dictionary() Update a value in a dictionary by calling Fun on the value to get a new value. An exception is generated if Key is not present in the dictionary. update(Key, Fun, Initial, Orddict1) -> Orddict2 Types Key = Initial = term() Fun = fun(Value1) -> Value2 Value1 = Value2 = term() Orddict1 = Orddict2 = ordered_dictionary() Update a value in a dictionary by calling Fun on the value to get a new value. If Key is not present in the dictionary then Initial will be stored as the first value. For example append/3 could be defined as: append(Key, Val, D) -> update(Key, fun (Old) -> Old ++ [Val] end, [Val], D). update_counter(Key, Increment, Orddict1) -> Orddict2 Types Key = term() Increment = number() Orddict1 = Orddict2 = ordered_dictionary() Add Increment to the value associated with Key and store this value. If Key is not present in the dictionary then Increment will be stored as the first value. This could be defined as: update_counter(Key, Incr, D) -> update(Key, fun (Old) -> Old + Incr end, Incr, D). but is faster. NOTES
The functions append and append_list are included so we can store keyed values in a list accumulator . For example: > D0 = orddict:new(), D1 = orddict:store(files, [], D0), D2 = orddict:append(files, f1, D1), D3 = orddict:append(files, f2, D2), D4 = orddict:append(files, f3, D3), orddict:fetch(files, D4). [f1,f2,f3] This saves the trouble of first fetching a keyed value, appending a new value to the list of stored values, and storing the result. The function fetch should be used if the key is known to be in the dictionary, otherwise find . SEE ALSO
dict(3erl) , gb_trees(3erl) Ericsson AB stdlib 1.17.3 orddict(3erl)
All times are GMT -4. The time now is 04:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy