Skip to main content
  • EN

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.

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

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

HI @1011analyst,

Even though I believe @takashi has the better answer, this will also work:

I tried 2 StringReplacers (first replacing " /" with "/", second replacing "/ " with "/") as text replacement.

Reply


Community Stats

30,190
Posts
114,595
Replies
37,854
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.