Question

Remove " from Entry Name Using Apply Function

Workflow How To

Updated October 13, 2023

asked on October 13, 2023

Hi All,

This sounds far too simple, but I'm struggling to get this working in WF11.

All I want to do is remove " if it exists in a filename.

So using the remove function in apply function like so:-

To me this should just remove the " from the filename, but this isn't working.

I could probably do this via regex or a token calculator, but function this should work, and I don't understand why it's not working.

What am I missing here?

Cheers!

Chris Douglas

0 0

Answer

SELECTED ANSWER

replied on October 13, 2023

Hi Chris,

There's a way to do this currently, but it's not a "function" it's the Substitute option under Token Calculator.

Just note that the old/new values should be in double quotes, so to replace double quotes you have to escape them by doubling up the inside quotes like so

SUBSTITUTE(%(Entry Name),""""," ")

If you want to remove them without adding the space, then just remove the space from the last parameter like so

SUBSTITUTE(%(Entry Name),"""","")

1 0

Replies

replied on October 13, 2023

"Remove" takes out values from a multi-value token, it does not remove individual characters.

1 0

replied on October 13, 2023

Thanks Miruna. Yeah figured that out. Wouldn’t that be a great feature though!

0 0

replied on October 13, 2023

One of my colleagues figured this out, using the split function and then rejoining the token. I'm guessing it's because the remove function is only for multi value tokens, not a string as to why this wasn't working as expected.

Please can I make a feature request to have a function that removes a value from a string. I always thought that's what this remove function did.

Cheers!

Chris

0 0

SELECTED ANSWER

replied on October 13, 2023

Hi Chris,

There's a way to do this currently, but it's not a "function" it's the Substitute option under Token Calculator.

Just note that the old/new values should be in double quotes, so to replace double quotes you have to escape them by doubling up the inside quotes like so

SUBSTITUTE(%(Entry Name),""""," ")

If you want to remove them without adding the space, then just remove the space from the last parameter like so

SUBSTITUTE(%(Entry Name),"""","")

1 0

You are not allowed to follow up in this post.

Question

Question

Remove " from Entry Name Using Apply Function

Answer

Replies

Sign in to reply to this post.