Skip to main content
Nintex Community Menu Bar
Solved

Nintex WF Remove special characters from created date

  • Feb 7, 2017 6:17 AM UTC
  • 4 replies
  • 232 views
  • Translate All

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.

View original

4 replies

Forum|alt.badge.img+12
  • Nintex Partner
  • Feb 7, 2017 6:58 AM UTC

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

Translate

Forum|alt.badge.img+13
  • Novice
  • Answer
  • Feb 7, 2017 4:52 PM UTC

Your regex would be something like

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

This should remove all special chraracters.

Translate

Forum|alt.badge.img+12
  • Feb 10, 2017 1:55 AM UTC

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

Translate

  • Author
  • Feb 12, 2017 10:46 PM UTC

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/>

Translate