What Is The Best To Remove Blank Spaces Within A List Or Table?

[mrwalt 34]

Quick question what would be the best way to remove a blank spaces from a list or table?

 

Example below:

 

(0) green

(1) 

(2) blue

(3) red

(4)

(5) yellow

 

 

Any ideas that you wish to share would be greatly appreciated.

[pash 504]

not sure Because the sample data is incomplete

add list to list(%Data,$list from text("green

blue
red

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

[HelloInsomnia 1103]

Try this, note that there are spaces and the items are not actually blank that is why there is a $trim in there. If you try to add it like Pash did, it won't add the blank items which is what I think he was trying to point out.

clear list(%data)
add list to list(%data,$list from text("green, ,blue,red,  ,yellow,   ,purple",","),"Delete","Global")
set(#list_item,0,"Global")
loop($list total(%data)) {
    if($is blank($trim($list item(%data,#list_item)))) {
        then {
            remove from list(%data,#list_item)
        }
        else {
            increment(#list_item)
        }
    }
}

[mrwalt 34]

Thank you both for the suggestions and help as I will try this out. 

[v_ladimir 2]

Try this:

add list to list(%NewData,$find regular expression("green

blue
red

yellow","\\w+"),"Delete","Global")

With Helloinsomnia example:

add list to list(%NewData,$find regular expression("green, ,blue,red,  ,yellow,   ,purple","\\w+"),"Delete","Global")

Edited June 5, 2016 by v_ladimir

[denrich 4]

I find this define command works well.

 

 

 

 

Try this:

add list to list(%NewData,$find regular expression("green

blue
red

yellow","\\w+"),"Delete","Global")

With Helloinsomnia example:

add list to list(%NewData,$find regular expression("green, ,blue,red,  ,yellow,   ,purple","\\w+"),"Delete","Global")

 

define Remove blanks from list {

    set(#listtotal,$list total(%PROXY_LIST),"Global")

    decrement(#listtotal)

    remove from list(%PROXY_LIST,#listtotal)

}

 

 

 

 

Den.

[denrich 4]

 

I find this define command works well.

 

 

 

 

define Remove blanks from list {

    set(#listtotal,$list total(%PROXY_LIST),"Global")

    decrement(#listtotal)

    remove from list(%PROXY_LIST,#listtotal)

}

 

 

 

 

Den.

 

Sorry guys this script to remove last line or last blank line from a list.