topic Leading Spaces during Column extraction in Data & Schema Discussions

Leading Spaces during Column extraction

srini_ch — Fri, 09 Sep 2022 13:54:24 GMT

Hi,

When I extract a column from Oracle DB, the leading spaces within the column values are removed by default. Is there a way to extract the value as it is (with leading spaces) from source?

Version: 5.1.4 (On-Prem)

Thanks,

Srinivas

Re: Leading Spaces during Column extraction

JoeM — Fri, 09 Sep 2022 14:40:28 GMT

@srini_ch - Great question. I've reached out to our connectors team and will let you know what I find out.

Re: Leading Spaces during Column extraction

amit_kothari — Fri, 09 Sep 2022 14:54:44 GMT

Incorta does this automatically so I would suggest replacing the blank value with some other character in the extract sql using the oracle replace() function - eg this replaces leading blank with P - REPLACE( REGEXP_SUBSTR( your_column, '^ +' ), ' ', 'P' )

Re: Leading Spaces during Column extraction

srini_ch — Fri, 09 Sep 2022 15:02:12 GMT

Hi Amit,

Currently, I am using the replace function as a work around. But the look of the report changes drastically when we wanted the values within a column to appear in a tree fashion.

Anyways, it would be nice to have an option on whether to trim the value or not during the extraction. Can you take this up as a Product Idea?

Thanks,

Srinivas

Re: Leading Spaces during Column extraction

DustinB — Mon, 12 Sep 2022 12:51:45 GMT

Hi @srini_ch ,

I think that is a good suggestion, would you mind entering this in the Product > Product Ideas section? Please also share any other ideas you have that would improve the product for your use cases.

Cheers,

Dustin