LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  How to remove duplicate text for a cell

    Employee
    Posted 03-09-2018 02:27

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Jagdev

    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.  RE: How to remove duplicate text for a cell

    Employee
    Posted 03-09-2018 08:33

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    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.  RE: How to remove duplicate text for a cell

    Employee
    Posted 03-12-2018 02:28

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Jagdev

    Originally posted by: stonysmith
					

    

    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