09-09-2022 06:53 AM - edited 09-09-2022 06:54 AM
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
Solved! Go to Solution.
09-09-2022 07:40 AM
@srini_ch - Great question. I've reached out to our connectors team and will let you know what I find out.
09-09-2022 07:54 AM
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' )
09-09-2022 08:02 AM
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
09-12-2022 05:51 AM
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