Skip to main content
A
AN_1054859412-Amethyst
12-Amethyst
April 20, 2023
Question

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

  • April 20, 2023
  • 2 replies
  • 1064 views

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".

2 replies

A
Ajit_Kulkarni16-Pearl
16-Pearl
April 20, 2023

Hello,

 

Use replace function in SQL. 

 

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

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

 

Thanks!! 

C
cgautier18-Opal
18-Opal
April 25, 2023

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.

C
cgautier18-Opal
18-Opal
May 10, 2023

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.

Terms & ConditionsAccessibility statement