Illegal character in path

caduque · June 18, 2020, 9:45am

Hi All,

Im trying to read a csv file then insert into an existing file but encountering error below.

msan · June 18, 2020, 9:47am

The "*" is not a valid character in filename

caduque · June 18, 2020, 9:48am

How should I fix it

msan · June 18, 2020, 9:51am

Does your file has this character? Please update the “Read from file” accordingly.

If you want to search for any file in a directory with a searchPattern, use

Directory.GetFilename(myDirectory, searchPattern) to get an Array of String with full paths.

caduque · June 18, 2020, 9:52am

No, it does not contain *. I am just using it as wildcard as the filename is dynamic.

msan · June 18, 2020, 9:53am

then please use the mentionned approach.

caduque · June 18, 2020, 9:53am

The constant word on the files is PHLPVGFW1

msan · June 18, 2020, 9:54am

searchPattern = "*PHLPVGFW1*"

caduque · June 18, 2020, 9:56am

I dont get the myDirectory

msan · June 18, 2020, 9:59am

Here it is:

myDirectory = "C:\RPADump\VPN"
searchPattern = "*PHLPVGFW1*"
firstFile = Directory.GetFilename(myDirectory, searchPattern)(0)

EDIT: or pass directly Directory.GetFilename("C:\RPADump\VPN", "*PHLPVGFW1*")(0)