SSIS分割字串 [英] SSIS split string

问题描述

我有一个包含许多列的数据集(日志文件)；其中之一是Other-Data(请参阅下文)，它是无序的字符串，需要解析它以根据u值(U1，U2，U3等)创建新列

I have a dataset (log file) with a number of columns; one of them is Other-Data (see below) which is an unordered string and need to parse it to create new columns according the u value (U1, U2, U3, etc...)

OTHER-DATA
u1=EUR;u2=sss:Checkout-Step4:Orderacknowledgement;u3=DE:de:hom;u11=1;u12=302338533;u13=SVE1511C5E;u14=575.67

任何人都可以帮忙吗?

推荐答案

一种方法是添加脚本转换组件，将OTHER-DATA用作输入行，并使用C#或VB.Net进行解析并将其输出将同步模式转换为预定义的输出.仅当您可以预先准备输出U1到Un时，这才起作用.此处说明了非常类似的问题: http://www .codeproject.com/Articles/193855/An-indespensible-SSIS-transformation-component-Scr

One way would be to add a script transformation component, use the OTHER-DATA as your input row, parse it with C# or VB.Net and output it in the synchronous mode into the predefined outputs. This will only work if you can prepare outputs U1 to Un in advance. The very similar problem is explained here: http://www.codeproject.com/Articles/193855/An-indespensible-SSIS-transformation-component-Scr

这篇关于SSIS分割字串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！