I have an agent which collects file numbers and drops them into a text file for use with another reporting system. I use:
fileNum% = Freefile()
fileName$ = "m:\WinFOCUS\" & filename & ".txt"
Open fileName$ For Output As fileNum%
Write #fileNum%, string
Where string is the contents of the .txt file. All works well save for one small thing. The .txt file has quotes around it, such as:
"111111 OR
2222222 OR
4444444 OR
5555555 OR
6666666 OR
7777777 OR
8888888 OR
9999999 OR
111111111 OR
121212121 OR
1313131313 OR
1414141414 OR
1515151515"
The reporting job that’s using this file will not work with the quotes. I can’t extract the quotes from the string using right, left, replace, etc., because the quotes aren’t there until the text file is written. Any ideas? Thanks!