I'm struggling to find a solution to CONCATENATE two fields, a date & time field and a text field, but I want to eliminate the special characters such as / and :
For example:
Field1 = ABCD
Field2 = 10/04/2016 01:29 PM
I can combined these fields as "ABCD10/04/2016 01:29 PM", however my goal is to get "ABCD100420160129PM"
Any suggestions would be great.
*This post is locked for comments
hi,
You can trigger js on change of both fields,
To concat follow the link: businesswithcrm.wordpress.com/.../concatenation-of-two-crm-fields-using-j-script
To remove special character using regular expression please find the link:
ciappara.com/.../remove-special-characters-like-from-string-javascript
www.alex-arriaga.com/remove-special-characters-using-a-regex-in-javascript
Where you want to get this string ?? in Javascript (so that you can place in another field) or in Plugin ? Either way, you should be able to use a simple RegEx to replace all these special chars.
A regular expression some thing like "[;\\/:*?\"<>|&'_+-]" should do the trick for you. Use it and replace the matches with String.Empty or "".
Regards
Srikanth
Following URLs will help you achieve it via Javascript:
mscrmblogger.com/.../remove-special-characters-on-value-change
stackoverflow.com/.../how-to-remove-the-special-characters-from-a-string-using-javascript
thebestcrm.blogspot.com.au/.../removereplace-special-characters-from.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (