使用SSIS替换平面文件中的特殊字符 [英] Replace the special character in a flat file using SSIS

问题描述

您好，

我有一个csv，其中有一个名为"Value"的列在它里面有弦乐和弦乐的组合。特殊字符。

I have a csv which has a column called "Value" and in it there are a combination of strings & special characters.

例如：

价值

abc

xyz

"

pqr

'

现在，我想替换" &安培; '输出文件中没有任何内容。我使用了派生列"替换"功能为 

Now, I want to replace the " & ' with nothing in the output file.I used the Derived column "Replace" function as 

替换（值，"""，"""& 替换（值，"\"，""，""" ）这似乎不起作用

Replace(Value," ' ","") & Replace(Value," \" ","") this doesn't seem to work

请提出一些解决方案

推荐答案

嗨AtulyaD，

Hi AtulyaD,

如果要替换多个字符，则需要沿着以下行进行多个嵌套的REPLACE（）函数调用：

If you want to replace multiple characters you need to make multiple nested REPLACE() function calls along the following line:

替换（替换（值，""，""，""），"\\"和"，"，"""

这篇关于使用SSIS替换平面文件中的特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！