Results 1 to 3 of 3

Thread: How to remove duplicate text for a cell

  1. #1

    Default How to remove duplicate text for a cell

    Hi Experts,

    Please let me know how can I remove duplicate text value from a cell.

    Ex -

    Data

    Jagdev Sinder Sinder
    Jagdev Jagdev Sinder

    Output

    Jagdev Sinder
    Jagdev Sinder

    Regards,
    JD

  2. #2
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    Code:
    node:Filter
    bretype:core::Filter
    editor:sortkey=5aa2a5db69a54d13
    input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
    output:@40fd2c7420761db6/=
    prop:Script=<<EOX
    
    emit *
    
    s=Data.split(" ")
    i=0
    ll=list()
    while i<len(s) {
    	if find(ll,s[i]) == -1 then ll=ll.append(s[i])
    	i=i+1
    }
    
    i=0
    out_ll=""
    while i<len(ll) {
    	out_ll=out_ll.joinStrings(ll[i]," ")
    	i=i+1
    }
    emit out_ll as LL
    EOX
    editor:XY=1150,390
    end:Filter
    
    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=5aa2a54a2ba66e2d
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    Data
    Jagdev Sinder Sinder
    Jagdev Jagdev Sinder
    EOX
    editor:XY=1060,390
    end:Static_Data

  3. #3

    Default

    Quote Originally Posted by stonysmith View Post
    Code:
    node:Filter
    bretype:core::Filter
    editor:sortkey=5aa2a5db69a54d13
    input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
    output:@40fd2c7420761db6/=
    prop:Script=<<EOX
    
    emit *
    
    s=Data.split(" ")
    i=0
    ll=list()
    while i<len(s) {
    	if find(ll,s[i]) == -1 then ll=ll.append(s[i])
    	i=i+1
    }
    
    i=0
    out_ll=""
    while i<len(ll) {
    	out_ll=out_ll.joinStrings(ll[i]," ")
    	i=i+1
    }
    emit out_ll as LL
    EOX
    editor:XY=1150,390
    end:Filter
    
    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=5aa2a54a2ba66e2d
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    Data
    Jagdev Sinder Sinder
    Jagdev Jagdev Sinder
    EOX
    editor:XY=1060,390
    end:Static_Data
    Hi Stony,

    Thanks for the code. This is what I was looking for..

    Please let me know you views on my other concerns regarding Fuzzy Logic - http://community.lavastorm.com/threa...logic-for-Name

    Regards,
    Jagdve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •