Solved

How do I remove white spaces before and after a "/"?

Forum|Forum|8 years ago
November 1, 2017
2 replies
39 views

1011analyst
9 replies

Hello,

I am working with an excel file with lots of field where I want to remove the space before and after a "/" eg. HWY 427 / North Queen St to HWY 427/North Queen St.

I have been testing using the String Replacer where Text to replace: is ([A-Z])([A-Z]).

Does anyone else have any suggestions?

Thanks in advance.

Best answer by takashi

Hi @1011analyst, try setting these parameters to the StringReplacer.

Mode: Replace Regular Expression
Text to Replace: \\s*/ \\s*
Replacement Text: /

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.