Question

replaceAll function replacing multiple characters and spaces

0

Hi, I'm trying to build an ID attribute using the current datetime and the autonumber without spaces. I tried a lot of different regex codes within the replaceAll function, but I can't figure it out. Could someone help me how the expression should look like to get the following example: 19-6-2013 14:41_208 '208' is the Autonumber) into 190620131441_208 Thanks in advance! :-)

asked 2013-06-19

Jeroen Kesteloo

2 answers

0

Thanks a lot!! Exactly what I needed :-)

answered 2013-06-19

Jeroen Kesteloo

Rom van Arendonk · Accepted Answer · 2013-06-19

Regular expression are hard, why not use formatDateTime function?

formatDateTime([%CurrentDateTime%],'ddMMyyyyHHmm') + '_' + toString($Entity/autonumber)

The token [%CurrentDateTime%] could be replaced by $Entity/DateTime.