TechQA.

Can we use multiple delimiter in Mload teradata?

230 views Asked by At

I have a file where I have multiple delimiters. I want to split based on delimeters and load it into a table in teradata. Please see below example:

38722719ÇI67.9Ç1Ç33984374Ç
47293377ÇZ11.51Ç1Ç37073044Ç
86809068ÇM54.2Ç1Ç49239923Ç
86811065ÇM54.2Ç1Ç49240429Ç

Here my two delimters are 'Ç' and 'Ç'

Whenever there is a single delimiter I have specified my delimiter in my mload script using 'format vartext'

FORMAT VARTEXT 'Ç'

But is there a way we can use multiple delimiters to split and load it into a table? I have tried separating the two delimiters with comma and it didn't work. Can you please throw some light?

teradata csv mload
Original Q&A
0

There are 0 answers

Related Questions in TERADATA

Related Questions in CSV

Related Questions in MLOAD

Popular Questions

Popular Tags

javascript python java c# php android html jquery c++ css ios sql mysql r reactjs node.js arrays c asp.net json python-3.x ruby-on-rails .net sql-server swift django angular objective-c pandas excel

Trending Questions