kettle 将两列字符串拆分
时间: 2023-10-02 11:06:28 浏览: 52
kettle可以使用列拆分为多行组件来将两列字符串拆分。在该组件的操作界面中,我们可以设置要拆分的字段、分隔符和新字段名。例如,如果要拆分的字符串是"firstname|lastname",分隔符是"|",那么可以将字符串拆分为两行,分别是"firstname"和"lastname"。在该组件中,我们还可以设置外壳,确保每个切分都包含偶数个外壳。这样,kettle就可以将两列字符串拆分为多行了。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [kettle开发篇-列拆分为多行-Day14](https://blog.csdn.net/qq_29061315/article/details/129401274)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [拆分字段帮助文档](https://blog.csdn.net/weixin_41653971/article/details/107904528)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]