Why the heck are lists so LIMITED!!!!!!

[ugakebet 4]

I try to do so many things within one list, but cant because of the limited functionality of lists. I want to use substring within a "add list to list" so that I can replace a sequence of the first list in the second, but cant.

 

I want to use $replace or $regex-replace in the "add list to list" but cant because they only go in the red areas, whereas a "add list to list" is a pink area.

 

 

WHY Seth, Y!!!!!!

[ugakebet 4]

I also want to use the substring with subtract list so that from list 1 I only take a small substring which I want compared with list2 .... but cant because "add list to list" cant accept substrings!!!!... 

 

And i do not want to use "add item to list"

[LoWrIdErTJ - BotGuru 904]

add list to list (list name of new list, and drag in list from text, then place sub string inside it)

 

same for the regex replace regex inside a list from text

[ugakebet 4]

and what do I do for the text? Assume I have only 2 lists. No variables or anything else.

 

 

What I'm trying to do is use $subtract lists. In simple words this would be something like

 

subtract list{

if substring of list1 matches column 0 of table1

then remove row from list1

}

 

 

I know how to do the "column 0 of table1".... how do i do the first part regarding "substring of list1"

 

 

And don't tell me to go about creating another list, because I like to keep my code clean and prefer to override one list rather than create 2 separate lists

[LoWrIdErTJ - BotGuru 904]

give me a bit more of a live example as i can see this being done much easier i believe then how its sounding.

 

The substring your attempting.

1. you have to make sure that it has that many characters in the string to return the substring otherwise it will return empty ( so you should validate the text length is >= the substring length before attempting to get substring from the information.

 

if(length >= Substring length)
than()

Then you can do a if(comparison(substring(), ==, table cell))
than remove list item, or regex replace on %list

)

 

else

 

somethingelse

 

}

 

 

ideally you will have to place the content of the list to a variable to replace with regex i believe clear list and add back to the list, clear temp var.

 

Might sound a little silly to do it that way.  but i believe its what your going to have to do.

[ugakebet 4]

Here you go. As you can see from the picture, where the cursor is I need to insert a substring. Basically I have a variable with the following data

 

http://asdflasdfub.com/adsfuhasdpflis,123

http://asdfklygauf.com/adofn,456

http://adkusygnaoslf/alsimhf,567

 

 

What I need to do is to compare whatever is before the comma in the variable and if it matches the $list from table, then delete it (hence the use of subtract list). I thought that I can simply create a list from text using the substring of the variable (until the comma)

 

 

http://img812.imageshack.us/img812/9374/netd.png

[ugakebet 4]

Any ideas