Brackets in file name causing load to fail

[robertmlawton]

I am trying to loop through a directory and load all the files within it. Its a simply bit of code, however if one of the filenames contain brackets (), the load will fail. Is there anyway to stop this happening, either by escaping certain characters or changing the load method?

for each FoundFile in filelist ('lib://Filelocation\*.xlsx')

Input:
LOAD
Field1,
Field2
FROM $(FoundFile)
(ooxml, embedded labels, table is Sheet1);

next FoundFile;

Many thanks!

Rob

[marcus_sommer · Accepted solution]

Try it in this way:

for each FoundFile in filelist ('lib://Filelocation\*.xlsx')

Input:
LOAD
Field1,
Field2
FROM [$(FoundFile)]
(ooxml, embedded labels, table is Sheet1);

next FoundFile;

- Marcus

[sunny_talwar · Accepted solution]

Try by adding single quotes around the variable name after FROM

FOR Each FoundFile in filelist ('P:\Com\Test Loop With Parenthesis\Test\*.xlsx')

	Input:
	LOAD Field1, Field2
	FROM '$(FoundFile)'
	(ooxml, embedded labels, table is Sheet1);

NEXT FoundFile;

[robertmlawton]

Thanks guys, both solutions worked perfectly!