1\导入的文本文件里的数据是用;或其他的符号时应该怎样写代码.
2\怎样判断一个字段里的内容含有的字符并转成另一个字符,如2006#03和2006@03这两种类型的数据改成2006-03并改变成是日期类型.

Description

Replaces a portion of one string with another.
ReplaceW A separate function provides an alternative syntax for DBCS environments.

Syntax

Replace ( string1, start, n, string2 )

ReplaceW ( string1, start, n, string2 )

Argument Description
string1 The string in which you want to replace characters with string2.
start A long whose value is the number of the first character you want replaced. (The first character in the string is number 1.)
n A long whose value is the number of characters you want to replace.
string2 The string that will replace characters in string1. The number of characters in string2 can be greater than, equal to, or less than the number of characters you are replacing.
Return value

String. Returns the string with the characters replaced if it succeeds and the empty string if it fails. If any argument's value is NULL, Replace returns NULL.

Usage

If the start position is beyond the end of the string, Replace appends string2 to string1. If there are fewer characters after the start position than specified in n, Replace replaces all the characters to the right of character start.
If n is zero, then, in effect, Replace inserts string2 into string1.