Removing spaces in lists

[blacksabbath 2]

Hello all,

 

I have pulled a list of names using the scrape attribute function but in my list the names appear with a lot of spaces in them for example

 

                                        John                    (spaces after too)

                    Mike

         Sally

                           Carol

 

 

My question is how can I remove all the spaces then use this list as a comparison to say if List item = Mike then do this...

 

 

Thank you 

[pash 504]

try

add list to list(%data, $list from text($replace regular expression("                                        John                    

                    Mike

         Sally

                           Carol", " ", ""), $new line), "Delete", "Global")

[Gogetta 263]

You might also want to take a look at the $trim function.

 

http://wiki.ubotstudio.com/wiki/Trim

[UBotDev 276]

I also think trim is a better option, since it won't remove spaces between 2 words that are actually 1 list item.

[cicooboom 0]

Try this:

 

add list to list(%data, $list from text($replace regular expression("                                        John                    

                    Mike

         Sally

                           Carol", " ", ""), $new line), "Delete", "Global")
plugin command("File Management.dll", "remove all from list", %data, "^\\s*$")

[blacksabbath 2]

Thank you for all the replies, got it working!

Wasn't too sure how to use the Trim function!