我的数据类似于以下内容:
"D.STEIN","DS","01","ALTRES","TTTTTTFFTT"
"D.STEIN","DS","01","APCASH","TTTTTTFFTT"
"D.STEIN","DS","01","APINH","TTTTTTFFTT"
"D.STEIN","DS","01","APINV","TTTTTTFFTT"
"D.STEIN","DS","01","APMISC","TTTTTTFFTT"
"D.STEIN","DS","01","APPCHK","TTTTTTFFTT"
"D.STEIN","DS","01","APWLNK","TTTTTTFFTT"
"D.STEIN","DS","01","ARCOM","TTTTTTFFTT"
"D.STEIN","DS","01","ARINV","TTTTTTFFTT"
我使用平面文件源编辑器来加载数据 . 删除所有双引号的最简单方法是什么?
4 回答
进一步搜索显示我应该在平面文件源的
General
选项卡上使用 Text Qualifier .在记事本中查看时的平面文件内容 . CRLF 表示行以
Carriage Return
和Line Feed
结尾 .在平面文件连接管理器上,在 Text qualifier 文本框中输入双引号 .
设置文本限定符后,将正确解析数据并显示如下所示:
使用双引号和逗号加载CSV时,有一个限制是添加了额外的双引号,并且数据也附加了双引号,您可以在源文件的预览中查看 . 因此,添加派生列任务并给出以下表达式: -
(REPLACE( RIGHT(SUBSTRING(TRIM(COL2),1,LEN(COL2) - 1),LEN(COL2) - 2) ," ","@"),"" \ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
粗体部分删除用双引号括起来的数据 .
试试这个并告诉我这是否有用
我宁愿使用以下声明....
Note: 请确保您的
YourOwnuniqueString
应该是唯一的,并且不会在列中的任何位置用作数据 . E.x:SQL@RT2#myCode
- 区分大小写 -