removing errant characters from a string

Beginners
1

hello all

i am having some trouble with basic string manipulation.

i am trying to concatenate elements from two different tables to get a path to a file.

i am using the following expression →

“tab("pathToMovie",0,0)``tab("/project1/bin_read_01/getFiles/select1",$OPD,0)”

which results in →

E:/movies/movies3/
ocean_layer_01.mov

and which i want to result in →

E:/movies/movies3/ocean_layer_01.mov

i was thinking that a carriage return was getting in the mix somehow and tried using the substitute() command to do grep style replacements - but to no avail.

this string ends up in the file path of a movie in TOP - and there are two rectangular cursor looking characters between the second slash and the QT filename. any direction on how to clean this string up would be greatly appreciated.

appreciation in advance for any assistance on this front !

best,

scott

2

see next post

3

sounds like the DAT with your base path (E:/movies/movies3/) is in text Format and has a newline in it. If it has a newline, just delete it, or convert it to a table …
scott.toe (4.45 KB)