Skip to main content
AN_1054859412-Amethyst
12-Amethyst
Apr 20, 2023 7:31 PM UTC
Question

Need an SQL code that replaces unvisible tailing spaces to something visible like "_P" in a table's

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.11

Need an SQL code that replaces unvisible tailing spaces to something visible like "_P" in a table's column. Example - given value "123456 " should be "123456_P".

3 replies

Ajit_Kulkarni16-Pearl
16-Pearl
Apr 20, 2023 7:33 PM UTC

Hello,

 

Use replace function in SQL. 

 

https://www.techonthenet.com/oracle/functions/replace.php

https://www.oracletutorial.com/oracle-string-functions/oracle-replace/

 

Thanks!! 

Translate
cgautier18-Opal
18-Opal
Apr 25, 2023 2:39 PM UTC

Hello AN_10548594,

I'm Charles from PTC Technical Support in Europe, I will provide you assistance on this question.

Did you review the information shared by Ajit_Kulkarni ?

I remain at your disposal for any questions or concerns.

Kind Regards,

Charles Gautier.

Translate
cgautier18-Opal
18-Opal
May 10, 2023 3:47 PM UTC

Hello AN_10548594,

With your agreement I propose you to let this question still open for a few days and then close it by the end of the week.

KR,

Charles.

Translate
Terms & ConditionsAccessibility statement