All Forums Tools
mercutio 3 posts Joined 02/10
17 Jan 2011
Loading carriage returns with TPT Load Operator

Hey Guys,

I am loading a delimited data file (using '|') with newline characters embedded within the fields, which the customer would like to preserve. How do I do that?

There doesn't appear to be any option in TPT Producer Operator for changing the record delimiter. I've tried escaping the newline characters but that just inserts the literal two characters "\n" in place of each newline character... Any ideas would be appreciated.

feinholz 1234 posts Joined 05/08
19 Jan 2011

We are working on this in the 14.0 release. Once that is complete, we will hopefully be able to backport that feature to earlier versions of TPT but that effort has not been committed yet.

--SteveF

Rameshsavi 3 posts Joined 10/10
03 Oct 2012

Is this feature implemented in TPT 14.

feinholz 1234 posts Joined 05/08
08 Oct 2012

No. It did not make it in to 14.0 or 14.10.
We will look into this as a post-14.10 activity.
 

--SteveF

ulrich 816 posts Joined 09/09
26 Apr 2014

Will it make in 15.0?
It creates so much overhead if you have to deal with it in preprosessing. These social network sources are full of this as it all about free text fields...

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

feinholz 1234 posts Joined 05/08
28 Apr 2014

No, it did not make it into 15.0, and may not even make it into 15.10.

--SteveF

ulrich 816 posts Joined 09/09
28 Apr 2014

sad, sad...

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

cloghin 17 posts Joined 04/12
02 Jun 2015

For this scenario of loading \n embedded in data fields, is that possible with any other operators in TPT at all ? 

feinholz 1234 posts Joined 05/08
02 Jun 2015

The DataConnector is the only operator that processes data from flat files and it does not currently support newlines embedded in data.
 
(We are actually working on that feature now as part of our 16.0 release, and will eventually roll that feature back to prior releases, but no timetable yet.)
 

--SteveF

You must sign in to leave a comment.