I have a very big text datafile. Each text record (variable length) is enclosed by quotes("---") and records are seperated by semicolon[;]. But it seems teradata import the quotes while importing. I am wondering if there is any way to ingore the quotes.
I had a similar situation and decided to just use the (") as the delimiter character. Then, you just have to skip over the fields that have the ( ;-) . So, in your first record, the first field would contain nothing, the second field would contain an 'a', the 3rd field would contain a ';', the 4th field would contain a 'bb', etc.
Are you using Unix? If so then you can strip out the single quotes before the fastload is started. This example assumes you do NOT have quotes in the data itself. The original file is renamed myfile.dat.bak