删除列表中单词末尾的\ n和后面的字母(Delete the \n and following letters in the end of words in a list)

 我使用TERADATA SQL Assistant中提供的IMPORT功能将数据加载到Teradata中。 
 
 但是处理这些数据我不确定下面我解释的方法是否足够有效。 
 
 但是，您可以尝试以下内容： 
 
 如果您使用的是TERADATA SQL Assistant： 
 
 
 
 转到文件菜单 - >单击IMPORT选项 
 
 
 您应该准备好一个表，其中包含CSV文件中所有必需的列以及正确的数据类型。 
 
 
 在SQL Assistant中，编写以下查询： 
 
 
 
 
 INSERT INTO TABLE_NAME VALUES(?,?,?,?....); 
 
 
 
 
 执行上述查询后，TERADATA会询问您要从中导入数据的文件，只需浏览并选择文件即可开始导入。 
 
 
 PS：由于你有12米的记录，肯定会花费很多时间。 

I have loaded data into Teradata using the IMPORT function available in the TERADATA SQL Assistant. 
 
But handling this amount of data I am not sure whether the method I explain you below will be efficient enough.
 
However, you may try something like the below:
 
If you are using TERADATA SQL Assistant:
 
 
 
Goto FILE menu-> click IMPORT option
 
 
You should have a table ready with all the required columns in your CSV file and correct datatype.
 
 
In SQL Assistant, write the below query:
 
 
 
 
INSERT INTO TABLE_NAME VALUES(?,?,?,?....);
 
 
 
 
Once you execute the above query TERADATA will ask for the file from which you want to import the data, you just need to browse and select your file and the import will begin.
 
 
P.S: Since you have 12 m records, it will definitely take lot of time.