1 Reply Latest reply: Apr 28, 2017 11:30 AM by Marcus Sommer RSS

    mass replace

    Dan-Ketil Jakobsen

      Hi, not sure if I post this under the right category, sorry for that

      I have a csv files that containes several special characters settings. I.e. %C2 that should be , (comma)

      We use datastage to process this file and store it in our database.

      I cannot do a replace within the csv file prior to the read operation into Qlivkview, the replace need be done within qikview after read from database.

      What I am looking for is a solution to scan thru all fields and do a replace from %C2 -> ,

      Any ideas?