What regular expressions are available to be used in Secondary Mapping Value conversion from SAP-EC

[adriangalisteo]

Good afternoon,

We need to replicate data from SAP ERP to Employee Central, but the data quality is quite a mess.

There are national ID from Molga 39 country (Chile) in different formats,

12.123.123-1

12123123-1

1231231231

The valid format would be this:

__.___.___-_

(the first one of the three above)

so i am trying to use value conversion this way,

according to the manual it should work

but is showing errors when replicating in se38

it is supposed to find the "-" if any and replace it by an <nbsp> space, the same with the points (\.) and after all, applying the correct format __.___.___-_

but it looks like seq number 1 and 2 (replace using patterns with string/ec field) don´t work if together only work if i delete one of them and leave the other. 

Maybe i need just to write everything in the same line and using a regular expressions as if i was writing ABAP code, but regular expressions like this [.-] are not working in this value conversion.

Therefore i would like to know if there are limitations for the regular expressions in this value conversion tool or they should work the same as if i was using ABAP code.

Thanks in advance

regards