从所有记录中删除默认换行字符
我正在使用 BizTalk 2009，并且有一个类似于以下内容的平面文件
“0162892172”、“TIM”、“LastName”、“760”、“”、“COMANCHE”、“LN”
“0143248282”、“GEORGE” ,"LastName ","625 "," ","ENID ","AVE "
当我解析它并开始映射它时，我需要去掉引号。我已将架构的换行字符属性标记为引号，但在 BizTalk 解析文件时它不会将其删除。
有没有一种简单的方法来指定删除换行字符，或者我每次都必须通过脚本函数运行它？另外，如果可能的话，我也希望能够删除尾随空格。
I am using BizTalk 2009 and I have a flat file that is similar to the following
"0162892172","TIM ","LastName ","760 "," ","COMANCHE ","LN "
"0143248282","GEORGE ","LastName ","625 "," ","ENID ","AVE "
When I parse it and start mapping it I need to get rid of the quotation marks. I have marked the Wrap Character attribute for the schema as a quotation mark but it doesn't remove it when BizTalk is parsing the file.
Is there an easy way to specify the removal of a wrap character or am I going to have to run it through a script functiod every time? Also I would like to be able to remove the trailing spaces as well, if at all possible.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果解析后仍然看到引号，则可能意味着您错误地设置了换行字符属性。您确定还设置了换行字符类型==字符吗？
至于额外的空格，在解析过程中很难摆脱它们，因为引号会明确告诉 bts 它们是故意的，所以是的，你最好的选择可能是在映射或其他过程中删除它们。
If you're still seeing the quotes after parsing, it likely means you set the wrap character property incorrectly. Are you sure you also set Wrap Character Type == Character?
As for the extra spaces, those will be hard to get rid of during parsing, because the quotes would specifically tell bts that they were intentional, so yeah, your best bet is to probably remove those during mapping or whatever.
此页面似乎建议删除尾随空格可以通过以下方式完成：
this page seems to suggest that removing the trailing spaces can be done with: