Tabs in data when using Anaplan connect

Certified Master Anaplanner

Tabs in data when using Anaplan connect

I was loading data using anaplan connect and i got an error saying there was a tab in my data.

Turns out anaplan connect Anaplan Connect cannot allow tabs in TEXT fields. This is rooted in how Anaplan Connect constructs the information from JDBC to be passed into Anaplan.

I got around this in the sql by using the following syntax in my sql statement:

 

REPLACE(REPLACE(REPLACE(fieldname, CHR(10)), CHR(13)), CHR(9))

Message 1 of 3
2 REPLIES 2
Regular Contributor

Re: Tabs in data when using Anaplan connect

Hey,

Thanks for providing this, great tip! Just a quick question about your workaround, do you not need to provide a replacement string in this portion of the statement?

eg REPLACE(REPLACE(REPLACE(fieldname, CHR(10), ''), CHR(13), ''), CHR(9), '')

Thanks


Jesse Wilson
Solution Architect - Data Integrations
Singapore
Message 2 of 3
Certified Master Anaplanner

Re: Tabs in data when using Anaplan connect

Hi Jesse,

 

I was hitting an oracle database.

Checking the help guide https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions134.htm

You can do a replace of the tab with another string but if you dont specify anything it will just delete the occurrences.

 

James

Message 3 of 3