I used sample code found in the message board to
change a comma separated file to a tab delimited file,

Example script to replace commas with tabs:
Dim count_changes, number
FileReplaceEx "my file name her", ",", "\t", false, count_changes

When the job runs I do not get an error, but nothing changes in the file
the file. What am I missing?

Most likely specified file name is incorrect. Make sure you specify full file name including path and you use double backslashes for example
FileReplaceEx "c:\\temp\\test.txt", ",", "\t", false, count_changes

: I used sample code found in the message board to
: change a comma separated file to a tab delimited file,

: Example script to replace commas with tabs: Dim count_changes, number
: FileReplaceEx "my file name her", ",", "\t",
: false, count_changes

: When the job runs I do not get an error, but nothing changes in the file
: the file. What am I missing?

: Most likely specified file name is incorrect. Make sure you specify full file
: name including path and you use double backslashes for example
: FileReplaceEx "c:\\temp\\test.txt", ",", "\t",
: false, count_changes

The filename works. I was trying to use a UNC, but that didn't work. I changed the path
to the drive letter and the FileReplaceEX worked. However, when I try to do the databaseImport
I still get the error message "not a tab-separated file". When I look at the file, the commas
are replaced by the /t. I have also tried inserting " " in place of the commas. That does not
work either. Any suggestions?

It should work with UNC. I bet you forgot about special ASCII characters handling in JAL.
Enter your UNC path as \\\\server\\share\\dir\\file or change deafult escape character \ to something else.

Also, it is not /t it is \t. You can also enter actual tab charcater instead of entering it as a special code \t. Please see "special ASCII characters" topic in the on-line help for more info.

: The filename works. I was trying to use a UNC, but that didn't work. I
: changed the path
: to the drive letter and the FileReplaceEX worked. However, when I try to do
: the databaseImport
: I still get the error message "not a tab-separated file". When I
: look at the file, the commas
: are replaced by the /t. I have also tried inserting " " in place of
: the commas. That does not
: work either. Any suggestions?

: It should work with UNC. I bet you forgot about special ASCII characters
: handling in JAL.
: Enter your UNC path as \\\\server\\share\\dir\\file or change deafult escape
: character \ to something else.

: Also, it is not /t it is \t. You can also enter actual tab charcater instead
: of entering it as a special code \t. Please see "special ASCII
: characters" topic in the on-line help for more info.

I'm sorry, I did use \t. I had mis-typed it in my comment below, and the UNC does not
work. I did use '\\\\', and I have read the special characters sections
of the help documentation. The code is still not working.

Do you have "\" selected as an escape character in Tools/Options menu, Editor tab page?
When you run this script in the debugger does the path look ok?

: I'm sorry, I did use \t. I had mis-typed it in my comment below, and the UNC
: does not
: work. I did use '\\\\', and I have read the special characters sections
: of the help documentation. The code is still not working.

: Do you have "\" selected as an escape character in Tools/Options
: menu, Editor tab page?
: When you run this script in the debugger does the path look ok?

Path is correct, and the tabs are in the file. Still DatabaseImport
fails.

We were talking about FileReplaceEx and UNC issue all day, that is why I asked to check system options.
Now you are talking about about DatabaseImport. Does it mean that yuo got FileReplaceEx working? Regarding the DatabaseImport issue, which error is reported in the job log?

: Path is correct, and the tabs are in the file. Still DatabaseImport
: fails.

: I used sample code found in the message board to
: change a comma separated file to a tab delimited file,

: Example script to replace commas with tabs: Dim count_changes, number
: FileReplaceEx "my file name her", ",", "\t",
: false, count_changes

: When the job runs I do not get an error, but nothing changes in the file
: the file. What am I missing?

I'm sorry, you're right. Yes, I set my options for the special characters,
and that worked. I am using drive letters b/c the UNC did not work, but I am not
getting a 'file not found error'. I now have a databaseimport error.
I will start a new issue on that.

Thanks.