'>' in User attribute showing as > in data analyzer and reports

[JEllis]

Data in location field on a user is displayed as "USCA > USA > California > San Jose 190 - TBL" when looking at user attribute on the user.

When using Data Analyzer or report it displays as  "USCA > USA > California > San Jose 190 - TBL"

I have tried type casting and using replace functions but it does not replace the > with >

[rushikeshvartak]

Can you share query

[JEllis]

See screenshot for query

[rushikeshvartak]

REPLACE(location, '>', '>')

[JEllis]

does not work. see test2 field

[rushikeshvartak]

It works for me

select REPLACE('rushi > vartak', '>','>') data from dual

[JEllis]

After more investigation i have found the following information.

The data coming into the field from the import is  ">"

When exporting reports or data query you get ">"
When viewing data in User field or viewing report you get ">"

[rushikeshvartak]

Yes so is your issue resolved ?

[JEllis]

No, I need the export of the analytic to export ">" currently it is exporting as "> "

My previous statement was to verify that the data coming into saviynt is ">" saviynt seems to be handling the character differently in different places, I am looking for a resolution/workaround

[rushikeshvartak]

code is internally changing hence we can't do anything