regular.express test

Daemin Hwang 2016-11-22 15:11:26

properties

* input.regex (0[0-9]{2})-([0-9]{3,4})-([0-9]{3,4})
* columns A,B,C
* columns.types STRING,STRING,STRING
input.regex.case.insensitive False

input

1
2
3
4
5
6
7
8
010-1234-5678
02-3458-6112
031-3215-XXXX
000-0000-00000
015-0230-0326
010-2301-5923
011-111-11a
032-1032-5920

output

A B C  
1
010
1234
5678
 
2
Null
 
3
Null
 
4
Null
 
5
015
0230
0326
 
6
010
2301
5923
 
7
Null
 
8
032
1032
5920
 

comments