Skip to main content
Nintex Community Menu Bar
Solved

Nintex WF Remove special characters from created date

  • February 7, 2017
  • 4 replies
  • 184 views

I have a Nintex Workflow (O365) attached to a Nintex Form that on submit any attachments are extracted and saved a specific file name format. I would also like to incorporate the 'created date' (short date) in the file name minus the special characters (e.g. as a 6 digits 01012017 not 01/01/2017).

I have tried using a regular expression to Replace the special characters but no luck yet. This is possibly an easy fix, so feel free to roll your eyes when you reply wink.png

Best answer by greenawayr

Your regex would be something like

[^0-9a-zA-Z]+

This should remove all special chraracters.

4 replies

Forum|alt.badge.img+12
  • 848 replies
  • February 7, 2017

Hi Jodie,

Jup, you can do that. I would have thought of regEx too but if they don't work you can first replace "/" with "" (nothing) and save that to a variable. Afterwards cut the first 8 characters from the variable string to get rid of the time and only leave the date left. In my sample I did the same with dots instead of dashes because it's German time format.

Sorry for my tenant being denglish.

Result:

Hope this helps.

Kind regards,

Enrico


Forum|alt.badge.img+13
  • Novice
  • 523 replies
  • Answer
  • February 7, 2017

Your regex would be something like

[^0-9a-zA-Z]+

This should remove all special chraracters.


Forum|alt.badge.img+12
  • 796 replies
  • February 10, 2017

Hi Jody, did either of these responses work for you?  


  • Author
  • 1 reply
  • February 12, 2017

Hi Mike,

The first one didn’t work for me so I ended up trying something else that worked. However I had not seen the second response so I will give that a go ☺

Kind regards,

Jodie Steel

SharePoint Administrator

National Pharmacies I National Support Office

52 Gawler Place, Adelaide SA 5000

T - 08 8223 0445 E - jsteel@fsma.com.au<mailto:jsteel@fsma.com.au>

www.nationalpharmacies.com.au<http://www.nationalpharmacies.com.au/>