Community,
I have a problem when doing migration job of updating part description. when saving the excel file to text (tab delimited), i can see the double quote is added by the system. please see the attached.
after I ran the migration job, i can see the part description is also updated with double quote text. see attached.
I am wondering how to fix this issue when updating the part description.
Thank you.
Best answer by Tomas Ruderfelt
You can also use the “String Delimiter” in the migration job loading the file and then you will only replace leading/trailing double quotes.
Hi @ronhu,
You need to check if it can be handled from the migration script it self.
Or else, since data has been already added to the respective database table better to update the column values by utilizing the PLSQL REPLACE function.
Example:
SELECT REPLACE(PART_DESCRIPTION, ‘”’, NULL) AS PART_DESCRIPTION FROM PART_TAB
You can write an UPDATE query with the above logic to correct it.
Hope this helps!
Best Regards,
Bhagya
You can also use the “String Delimiter” in the migration job loading the file and then you will only replace leading/trailing double quotes.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
