Skip navigation
Contact Us
1122 Views 1 Reply Latest reply: Mar 28, 2012 1:29 AM by Ramakrishna B.V.S. RSS
Venkat Byrapudi Master 889 posts since
Mar 25, 2010
Currently Being Moderated

Mar 27, 2012 11:59 PM

REPLACECHR()!!

Parse Characters From Within A String, leaving only the Numbers

Sample input: 780 (Case Pack)
Sample output: 780

REPLACECHR(0, Port_Name, REPLACECHR(0, Port_Name, '0123456789', ''), '')

 

How to remove ASCII New Line-CHR(10) and Carriage Returns-CHR(13) from a String
REPLACECHR( 0, REPLACECHR( 0, Port_Name, CHR(10), ' '), CHR(13), ' ')

 

Removing Non-breaking space from a String
REPLACECHR( 0, Port_Name, CHR(160), NULL )
REPLACECHR( 0, Port_Name, CHR(160), '' )

 

 

Regards,

Venkat

More Like This

  • Retrieving data ...

Bookmarked By (1)