False Behavior On $List From Text

[ibins 0]

Hello,

 

having problem with following code:

clear list(%my list)
add list to list(%my list,$list from text("list item 1,,list item 3,list item 4,list item 5,list item 6",","),"Don\'t Delete","Global")

which gives me:

 

its declared "Don\'t Delete", but it deletes.

 

Expected Bevavior:

How do i overcome this issue?

 

I cannot modify input to put a "0" / "space" or something, i need to use it that way.

 

Many Thanks in advance for your help.

[bestmacros 60]

clear list(%my list)

add list to list(%my list,$list from text("list item 1,{$new line},list item 3,list item 4,list item 5,list item 6",","),"Don\'t Delete","Global")

[ibins 0]

Many thanks for your reply! I found a way,

 

instead adressing the nonexistent value, i adress the delimiter itself and remove it afterwards.

 

clear list(%my list)
set(#in,"list item 1,,list item 3,list item 4,list item 5,list item 6","Global")
set(#in,$replace(#in,",","|,|"),"Global")
add list to list(%my list,$list from text(#in,","),"Don\'t Delete","Global")
set list position(%my list,0)
set(#value1,$next list item(%my list)
set(#value1,$replace(#value1,"|",""),"Global")
set(#value2,$next list item(%my list)
set(#value2,$replace(#value2,"|",""),"Global")
..
..

Thanks again!