Sponsored Content
Top Forums Shell Programming and Scripting Extracting a certain pattern.. Post 302734349 by itkamaraj on Thursday 22nd of November 2012 01:50:00 AM
Old 11-22-2012
convert your excel to csv file ( with delimted as , comma )

Code:
 
awk -F, 'NR>1{if($3=="abc" && $4>5)$1="XYZ"}1' input.csv

The above code replace the first column value as XYZ ( if the conditions met -- col c is abc and col d >5 )
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help extracting a matching pattern and next lines of match

Hi there, i'm having some problems just making an awk script (i've tried this way, but other way can be posible for sure), for the next file file.txt <register> <createProfile> <result>0</result> <description><!]></description> <msisdn>34661461174</msisdn> <inputOmvID>1</inputOmvID>... (6 Replies)
Discussion started by: vicious
6 Replies

2. Shell Programming and Scripting

Extracting N lines match number X of a pattern

Hi All, as the title says I need to extract N lines after match number X of a pattern. e.g. 111 xxx xxx 111 yyy yyy 111 www www 111 zzz zzz I would like to extract the two lines after the second 111 occurrence. I tried with grep but I didn't find any options to do that. Any... (11 Replies)
Discussion started by: f_o_555
11 Replies

3. Shell Programming and Scripting

Extracting the strings matching a pattern from a word

Hi All , I need to extract the strings that are matching with the pattern : CUST.<AnyStringOfAnyLength>.<AnyStringOfAnyLength> from a file and then write all these string into another file. e.g. If a file SOURCE contains following lines : IF(CUST.ABCD.EFGH==1) THEN CUST.ABCD.EFGH =... (7 Replies)
Discussion started by: swapnil.nawale
7 Replies

4. Shell Programming and Scripting

Extracting a string matching a pattern from a line

Hi All, I am pretty new to pattern matching and extraction using shell scripting. Could anyone please help me in extracting the word matching a pattern from a line in bash. Input Sample (can vary between any of the 3 samples below): 1) Adaptec SCSI RAID 5445 2) Adaptec SCSI 5445S RAID 3)... (8 Replies)
Discussion started by: jharish
8 Replies

5. UNIX for Dummies Questions & Answers

extracting pattern from every line

My scenario: 1. textfle 2. every line similar to: "...____ your sister?is1are0am0Grammar point1_______ the chairs in..." 3. need to extract only the numbers in each line, eg 001 in the case above. Tried different GREP/Sed combinations but...here I am An output like that would be... (9 Replies)
Discussion started by: eldeingles
9 Replies

6. UNIX for Dummies Questions & Answers

Extracting sub-string matching the pattern.

Hi, I have a string looks like the following: USERS 32767.9844 UNDOTBS1 32767.9844 SYSAUX 32767.9844 SYSTEM 32767.9844 EMS 8192 EMS 8192 EMS_INDEXES 4096 EMS_INDEXES 4096 8 rows selected. How do I extract a sub-string to get the expected output as following: EMS 8192 EMS_INDEXES 4096 ... (3 Replies)
Discussion started by: NetBear
3 Replies

7. UNIX for Dummies Questions & Answers

Extracting substring between pattern only one time

Hello ifconfig return : eth0 Link encap:Ethernet HWaddr 11:24:1D:C1:99:BA inet addr:192.168.0.1 Bcast:192.168.0.255 Mask:255.255.255.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:37307 errors:0 dropped:0 overruns:0 frame:0 ... (2 Replies)
Discussion started by: jcdole
2 Replies

8. Shell Programming and Scripting

Searching for a pattern and extracting records related to that pattern

Hi there, Looking forward to your advice for the below: I have a file which contains 2 paragraphs related to a particular pattern. I have to search for those paragraphs from a log file and then print a particular line from those paragraphs. Sample: I have one file with the fixed... (3 Replies)
Discussion started by: danish0909
3 Replies

9. UNIX for Dummies Questions & Answers

Extracting range of characters if pattern matches

Im trying compare values between files and if they match I want to extract some characters in between those values for many files. They are in two directories and have the name filename but one ends in .enr. They look like this. cat bat.1.enr name,start,end bat.1,231, 234 and another... (5 Replies)
Discussion started by: verse123
5 Replies

10. Shell Programming and Scripting

Extracting sequential pattern

Hi, Can someone advise/help me on how to write a script to extract sequential lines. I was able to find and get a script working to create permutations of the inputs, but that not what I want/need. awk 'function perm(p,s, i) { for(i=1;i<=n;i++) if(p==1) ... (4 Replies)
Discussion started by: fuzzi
4 Replies
wxListCtrl(3erl)					     Erlang Module Definition						  wxListCtrl(3erl)

NAME
wxListCtrl - See external documentation: wxListCtrl. DESCRIPTION
See external documentation: wxListCtrl . This class is derived (and can use functions) from: wxControl wxWindow wxEvtHandler DATA TYPES
wxListCtrl() : An object reference, The representation is internal and can be changed without notice. It can't be used for comparsion stored on disc or distributed for use on other nodes. EXPORTS
new() -> wxListCtrl() See external documentation . new(Parent::wxWindow() (see module wxWindow)) -> wxListCtrl() Equivalent to new(Parent, []) . new(Parent::wxWindow() (see module wxWindow), Options::[Option]) -> wxListCtrl() Types Option = {winid, integer()} | {pos, {X::integer(), Y::integer()}} | {size, {W::integer(), H::integer()}} | {style, integer()} | {validator, wx() (see module wx)} See external documentation . arrange(This::wxListCtrl()) -> bool() Equivalent to arrange(This, []) . arrange(This::wxListCtrl(), Options::[Option]) -> bool() Types Option = {flag, integer()} See external documentation . assignImageList(This::wxListCtrl(), ImageList::wxImageList() (see module wxImageList), Which::integer()) -> ok See external documentation . clearAll(This::wxListCtrl()) -> ok See external documentation . create(This::wxListCtrl(), Parent::wxWindow() (see module wxWindow)) -> bool() Equivalent to create(This, Parent, []) . create(This::wxListCtrl(), Parent::wxWindow() (see module wxWindow), Options::[Option]) -> bool() Types Option = {winid, integer()} | {pos, {X::integer(), Y::integer()}} | {size, {W::integer(), H::integer()}} | {style, integer()} | {validator, wx() (see module wx)} See external documentation . deleteAllItems(This::wxListCtrl()) -> bool() See external documentation . deleteColumn(This::wxListCtrl(), Col::integer()) -> bool() See external documentation . deleteItem(This::wxListCtrl(), Item::integer()) -> bool() See external documentation . editLabel(This::wxListCtrl(), Item::integer()) -> wxTextCtrl() (see module wxTextCtrl) See external documentation . ensureVisible(This::wxListCtrl(), Item::integer()) -> bool() See external documentation . findItem(This::wxListCtrl(), Start::integer(), Str::string()) -> integer() Equivalent to findItem(This, Start, Str, []) . findItem(This::wxListCtrl(), Start::integer(), X::string() | term(), X::term() | integer()) -> integer() See external documentation . Alternatives: findItem(This::wxListCtrl(), Start::integer(), Str::string(), [Option]) -> integer() Option = {partial, bool()} findItem(This::wxListCtrl(), Start::integer(), Pt::{X::integer(),Y::integer()}, Direction::integer()) -> integer() getColumn(This::wxListCtrl(), Col::integer(), Item::wxListItem() (see module wxListItem)) -> bool() See external documentation . getColumnCount(This::wxListCtrl()) -> integer() See external documentation . getColumnWidth(This::wxListCtrl(), Col::integer()) -> integer() See external documentation . getCountPerPage(This::wxListCtrl()) -> integer() See external documentation . getEditControl(This::wxListCtrl()) -> wxTextCtrl() (see module wxTextCtrl) See external documentation . getImageList(This::wxListCtrl(), Which::integer()) -> wxImageList() (see module wxImageList) See external documentation . getItem(This::wxListCtrl(), Info::wxListItem() (see module wxListItem)) -> bool() See external documentation . getItemBackgroundColour(This::wxListCtrl(), Item::integer()) -> colour() (see module wx) See external documentation . getItemCount(This::wxListCtrl()) -> integer() See external documentation . getItemData(This::wxListCtrl(), Item::integer()) -> integer() See external documentation . getItemFont(This::wxListCtrl(), Item::integer()) -> wxFont() (see module wxFont) See external documentation . getItemPosition(This::wxListCtrl(), Item::integer(), Pos::{X::integer(), Y::integer()}) -> bool() See external documentation . getItemRect(This::wxListCtrl(), Item::integer(), Rect::{X::integer(), Y::integer(), W::integer(), H::integer()}) -> bool() Equivalent to getItemRect(This, Item, Rect, []) . getItemRect(This::wxListCtrl(), Item::integer(), Rect::{X::integer(), Y::integer(), W::integer(), H::integer()}, Options::[Option]) -> bool() Types Option = {code, integer()} See external documentation . getItemSpacing(This::wxListCtrl()) -> {W::integer(), H::integer()} See external documentation . getItemState(This::wxListCtrl(), Item::integer(), StateMask::integer()) -> integer() See external documentation . getItemText(This::wxListCtrl(), Item::integer()) -> string() See external documentation . getItemTextColour(This::wxListCtrl(), Item::integer()) -> colour() (see module wx) See external documentation . getNextItem(This::wxListCtrl(), Item::integer()) -> integer() Equivalent to getNextItem(This, Item, []) . getNextItem(This::wxListCtrl(), Item::integer(), Options::[Option]) -> integer() Types Option = {geometry, integer()} | {state, integer()} See external documentation . getSelectedItemCount(This::wxListCtrl()) -> integer() See external documentation . getTextColour(This::wxListCtrl()) -> colour() (see module wx) See external documentation . getTopItem(This::wxListCtrl()) -> integer() See external documentation . getViewRect(This::wxListCtrl()) -> {X::integer(), Y::integer(), W::integer(), H::integer()} See external documentation . hitTest(This::wxListCtrl(), Point::{X::integer(), Y::integer()}) -> {integer(), Flags::integer()} See external documentation . insertColumn(This::wxListCtrl(), Col::integer(), X::string() | term()) -> integer() See external documentation . Alternatives: insertColumn(This::wxListCtrl(), Col::integer(), Heading::string()) -> insertColumn(This,Col,Heading, []) insertColumn(This::wxListCtrl(), Col::integer(), Info::wxListItem:wxListItem()) -> integer() insertColumn(This::wxListCtrl(), Col::integer(), Heading::string(), Options::[Option]) -> integer() Types Option = {format, integer()} | {width, integer()} See external documentation . insertItem(This::wxListCtrl(), Info::wxListItem() (see module wxListItem)) -> integer() See external documentation . insertItem(This::wxListCtrl(), Index::integer(), X::integer() | string()) -> integer() See external documentation . Alternatives: insertItem(This::wxListCtrl(), Index::integer(), ImageIndex::integer()) -> integer() insertItem(This::wxListCtrl(), Index::integer(), Label::string()) -> integer() insertItem(This::wxListCtrl(), Index::integer(), Label::string(), ImageIndex::integer()) -> integer() See external documentation . refreshItem(This::wxListCtrl(), Item::integer()) -> ok See external documentation . refreshItems(This::wxListCtrl(), ItemFrom::integer(), ItemTo::integer()) -> ok See external documentation . scrollList(This::wxListCtrl(), Dx::integer(), Dy::integer()) -> bool() See external documentation . setBackgroundColour(This::wxListCtrl(), Colour::colour() (see module wx)) -> bool() See external documentation . setColumn(This::wxListCtrl(), Col::integer(), Item::wxListItem() (see module wxListItem)) -> bool() See external documentation . setColumnWidth(This::wxListCtrl(), Col::integer(), Width::integer()) -> bool() See external documentation . setImageList(This::wxListCtrl(), ImageList::wxImageList() (see module wxImageList), Which::integer()) -> ok See external documentation . setItem(This::wxListCtrl(), Info::wxListItem() (see module wxListItem)) -> bool() See external documentation . setItem(This::wxListCtrl(), Index::integer(), Col::integer(), Label::string()) -> integer() Equivalent to setItem(This, Index, Col, Label, []) . setItem(This::wxListCtrl(), Index::integer(), Col::integer(), Label::string(), Options::[Option]) -> integer() Types Option = {imageId, integer()} See external documentation . setItemBackgroundColour(This::wxListCtrl(), Item::integer(), Col::colour() (see module wx)) -> ok See external documentation . setItemCount(This::wxListCtrl(), Count::integer()) -> ok See external documentation . setItemData(This::wxListCtrl(), Item::integer(), Data::integer()) -> bool() See external documentation . setItemFont(This::wxListCtrl(), Item::integer(), F::wxFont() (see module wxFont)) -> ok See external documentation . setItemImage(This::wxListCtrl(), Item::integer(), Image::integer()) -> bool() Equivalent to setItemImage(This, Item, Image, []) . setItemImage(This::wxListCtrl(), Item::integer(), Image::integer(), Options::[Option]) -> bool() Types Option = {selImage, integer()} See external documentation . setItemColumnImage(This::wxListCtrl(), Item::integer(), Column::integer(), Image::integer()) -> bool() See external documentation . setItemPosition(This::wxListCtrl(), Item::integer(), Pos::{X::integer(), Y::integer()}) -> bool() See external documentation . setItemState(This::wxListCtrl(), Item::integer(), State::integer(), StateMask::integer()) -> bool() See external documentation . setItemText(This::wxListCtrl(), Item::integer(), Str::string()) -> ok See external documentation . setItemTextColour(This::wxListCtrl(), Item::integer(), Col::colour() (see module wx)) -> ok See external documentation . setSingleStyle(This::wxListCtrl(), Style::integer()) -> ok Equivalent to setSingleStyle(This, Style, []) . setSingleStyle(This::wxListCtrl(), Style::integer(), Options::[Option]) -> ok Types Option = {add, bool()} See external documentation . setTextColour(This::wxListCtrl(), Col::colour() (see module wx)) -> ok See external documentation . setWindowStyleFlag(This::wxListCtrl(), Style::integer()) -> ok See external documentation . sortItems(This::wxListCtrl(), SortCallBack::function()) -> boolean() Sort the items in the list control SortCalBack(Item1,Item2) -> integer() SortCallBack receives the client data associated with two items to compare, and should return 0 if the items are equal, a negative value if the first item is less than the second one and a positive value if the first item is greater than the second one. NOTE: The callback may not call other processes. destroy(This::wxListCtrl()) -> ok Destroys this object, do not use object again AUTHORS
<> wxErlang 0.98.9 wxListCtrl(3erl)
All times are GMT -4. The time now is 09:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy