#DateForumTypeThreadPost
203 Jan 2006 @ 09:35 PSTToolsTopicFastLoad vs NL CharacterI have a text file with records I want to import into Teradata with FastLoad. Columns are separated with a "|" character. There is a problem with a 'Comments' column containing rows with a new line...
103 Jan 2006 @ 04:28 PSTDatabaseReplyString ReplacementOr you can:create table your_table2 as your_table with no data;insert into your_table2 select substring(your_field FROM 1 FOR INDEX(your_field,' and') -1) || ' or ' || substring(your_field FROM IN...