SAP/ABAP

데이터갱신 시 특수문자 제거

rossella 2012. 7. 3. 09:17


REPLACE ALL OCCURRENCES OF REGEX '[^[:alnum:]]' IN lv_text WITH ''.
특수문자 제거 옵션

======================================================================


`[:alnum:]' 
Alphanumeric characters: `[:alpha:]' and `[:digit:]'.

`[:alpha:]' 
Alphabetic characters: `[:lower:]' and `[:upper:]'.

`[:blank:]' 
Blank characters: space and tab.

`[:cntrl:]' 
Control characters. In ASCII, these characters have octal codes 000 through 037, and 177 (DEL). In other character sets, these are the equivalent characters, if any.

`[:digit:]' 
Digits: 0 1 2 3 4 5 6 7 8 9.

`[:graph:]' 
Graphical characters: `[:alnum:]' and `[:punct:]'.

`[:lower:]' 
Lower-case letters: a b c d e f g h i j k l m n o p q r s t u v w x y z.

`[:print:]' 
Printable characters: `[:alnum:]', `[:punct:]', and space.

`[:punct:]' 
Punctuation characters: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~.

`[:space:]' 
Space characters: tab, newline, vertical tab, form feed, carriage return, and space.

`[:upper:]' 
Upper-case letters: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z.

`[:xdigit:]' 
Hexadecimal digits: 0 1 2 3 4 5 6 7 8 9 A B C D E F a b c d e f.

======================================================================================================== 

윗 부분의 진한 부분을 변경해서 사용하시면 되요..

 

그리고 abap function으로는 "SF_SPECIALCHAR_DELETE" 을 이용하시면 될듯해요..