Skip to main content
Nintex Community Menu Bar

Update hyperlinks containing commas

  • September 4, 2019
  • 3 replies
  • 28 views

Forum|alt.badge.img+1

Hi,

I have a task to update a hyperlink column in a custom list, which have a hyperlink column containing link to various internal UNC paths. So far so good, this works (at least for IE users).


Now I have to update the server name of some of these items, which is no problem doing using regular expressions.


My problem is when the path contains commas, I cannot used the “<link>, <link-descriptin>” syntax for updating the link.


I have tried wrapping the url in {TextStart}/TextEnd}, replacing the commas with ‘%2C’, fn-XmlEncode and every combination of the mentioned.


Have anyone successfully been able to set a value in a hyperlink column when the value contains a comma eg. "file:////servername1/share_root/sub folder, with a pesty comma/even_deeper, Link-description"?

 

Thanks!

 

3 replies

MegaJerk
Forum|alt.badge.img+14
  • Scholar
  • September 4, 2019

Using the Update Item Action on a Hyperlink column, I was able to successfully generate a hyperlink to a URL that contained commas without any problems. 

The Value Input: 

http://services.runescape.com/m=forum/forums.ws?185,186,980,60829426, test


The Action:
4243i7F6C71C4EE4A7569.png

 

The results: 

4244i145CCB6FEFBB1C23.png




Forum|alt.badge.img+1
  • Author
  • September 5, 2019

Hi,

@MegaJerk : Thank you for pushing me in the right direction :smileyhappy:

The problem wasnt the actual commas but the combination of a comma and a space, as soon as i replace the space's with "%20" the url is updated correctly!

 

Thanks!


MegaJerk
Forum|alt.badge.img+14
  • Scholar
  • September 5, 2019

Ahhh! Good to hear that you were able to crack the case!