CCTV Manager Solution - modelbuilder iteration fails when using inline variable substitution

Question

I am using the CCTV Manager Solution. I am trying to create a model to iterate over a series of folders and run the Import Access Tables script on the MDB file within. I am using inline variable substitution to construct the Access database file path. The script will not accept what I try to pass into it.

The Access database parameter is set as a File type. It works if I hardcode the Access database. But when I try to construct the Access database path using inline variable substitution, it errors out and won't accept that.

* The MDB file is located here: * C:\CCTV_Inspections\2020_05_11\2020_05_11_PACP _ LACP _ MACP 6.0.mdb

* The iterator produces the following output:* Folder - i.e. C:\CCTV_Inspections\2020_05_11
* Folder Name - i.e. 2020_05_11

* I've constructed the Access database name using inline variable substitution:* %Folder%\%Folder Name%_PACP _ LACP _ MACP 6.0.mdb
* When translated, it matches exactly the MDB file path

Here is my model:

danretired · Answer

I use python not modelbuilder, but I suspect this is why this tool exists for modelbuilder

Parse Path (ModelBuilder)—ArcGIS Pro | Documentation

but I haven't used it

GISUser74305830 · Answer

Can you raw encode in Modelbuilder?

danretired · Answer

Your paths aren't able to make a valid filepath when concatenated together, hence my example of "raw encoding" by adding the little 'r' to the front of each element.