I am using TPT to export data. I am using delimiter as | and escapetextdelimiter as \ . Also I have arequirement to replace \ with \ when \ comes in data. So I tried using oreplace function in my view. After using that any row which has \ in the data the next delimiters got missed.
if there is no \ in the data this is how my export looks like which is correct
ABC |123 |456 |789
if \ comes in the data e.g ABC\ and in the view i use oreplce to make it ABC\.
Now when I export using TPT from that OREPLACE view, this is what I am getting in the export file.
ABC\ 123 456 789
Can anyone tell me how this could be resolved.
We are using Teradata Parallel Transporter Version 13.10.00.05
tbuild -r /xxx/xxx/xxx/xx/xxxx -f /xxx/xxx/xxx/xx/xxxx/file1.ctl -u " v_outfile='file.out',v_exportqry='lock row for access select * from dbname.viewname ;',v_directorypath='/xxx/xxx/xxx/xx/xxxx',v_delimiter_value='|',v_utf='UTF8', TraceLevel='ALL', v_sessions=8,v_src_object=schema_SCHEMA " -L /xxx/xxx/xxx/xx/xxxx