使用；读取Talend中的CSV文件列表.现场 [英] Read a list of CSV files in Talend with ; in field

问题描述

我有一个CSV文件列表，每个月我都会收到ETL进入数据库的CSV文件.它在一个文件夹中.我的数据在许多列中都有;.例如，在位置列中存在类似New York; USA的值，我希望它们出现在单个列中，而不是拆分成许多列.那我该如何指定定界符呢?

I have a list of CSV files which i receive for ETL into database every month. Its in a folder. My data has ; in many columns as well. For example, in the location column values like New York; USA are present, which i want to appear in a single column instead of splitting into many columns. How do i specify delimiter then?

推荐答案

我认为您不能在字段内容中包含字段分隔符，或者必须将这些值包含在"之间.例如: blabla;"New York; USA";blabla
其他解决方案是，将字段定界符更改为更特定(且未使用)的字符.

I think you cannot have the field separator included in the field content or you have to incluse these values between "". For example: blabla;"New York; USA";blabla
Other solution, change the field delimitor to a more specific (and unused) character.

恐怕没有更好的解决方案.

I'm afraid there is no better solution.

关于， TRF

这篇关于使用；读取Talend中的CSV文件列表.现场的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！