Split On Delimter / Insert Data

[dexter8203 0]

Hi,

 

Within a table, I have a values stored as a list of URLS.    For example - 1.jpg, 2.jpg, 3.jpg, 4.jpg, ....  etc.

 

The URLS or in this case are file names are separated by commas.

 

My goal is to insert a variable into the list in the third position.

 

IE

 

1.jpg, 2.jpg, #VAR, 3.jpg, 4.jpg. 

 

I seem to have hit a roadblock.  Any encouragement or suggestions? 

 

 

 

Derek

[pash 504]

value list in table cell?

[dexter8203 0]

value list in table cell?

 

Yes.

[pash 504]

Because unused plugins. It is quite cumbersome.

clear all data
set(#DataToAdd,"5.jpg","Global")
set(#AddToListPostion,3,"Global")
set table cell(&MyTable,0,0,"1.jpg, 2.jpg, 3.jpg, 4.jpg")
add list to list(%MyList,$list from text($table cell(&MyTable,0,0),","),"Delete","Global")
set list position(%MyList,0)
loop($list total(%MyList)) {
    set(#MyListItem,$next list item(%MyList),"Global")
    if($comparison($list position(%MyList),"= Equals",#AddToListPostion)) {
        then {
            add item to list(%MyListOut,#DataToAdd,"Don\'t Delete","Global")
        }
    }
    add item to list(%MyListOut,#MyListItem,"Don\'t Delete","Global")
}
set table cell(&MyTable,0,0,$replace(%MyListOut,$new line,","))

By Plugin

clear all data
set(#DataToAdd,"5.jpg","Global")
set(#AddToListPostion,2,"Global")
set table cell(&MyTable,0,0,"1.jpg, 2.jpg, 3.jpg, 4.jpg")
add list to list(%MyList,$list from text($table cell(&MyTable,0,0),","),"Delete","Global")
plugin command("Advanced Data Text File.dll", "list insert", %MyList, #AddToListPostion, #DataToAdd)
set table cell(&MyTable,0,0,$replace(%MyList,$new line,","))