Skip to main content
Solved

remove spaces between numeric values

  • January 21, 2020
  • 2 replies
  • 10 views

tomjerry.vl
Forum|alt.badge.img

How to remove spaces in between numeric values.

like below

BeforeI need like this0 909a 1 2 ga 12 ga125a125a 1 ba 1 ba 12 5 ba 125 b

 

 

Best answer by takashi

Hi @tomjerry.vl, the StringReplacer with this Regular Expression does the trick.

(?<=\d)\s+(?=\d)

0684Q00000ArK5OQAV.png

 

Alternatively this string expression returns the same result.

@ReplaceRegEx(@Value(Before),"(?<=\d)\s+(?=\d)","")

 

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.

2 replies

takashi
Celebrity
  • 7843 replies
  • Best Answer
  • January 21, 2020

Hi @tomjerry.vl, the StringReplacer with this Regular Expression does the trick.

(?<=\d)\s+(?=\d)

0684Q00000ArK5OQAV.png

 

Alternatively this string expression returns the same result.

@ReplaceRegEx(@Value(Before),"(?<=\d)\s+(?=\d)","")

 


tomjerry.vl
Forum|alt.badge.img
  • Author
  • 22 replies
  • January 21, 2020

Hi @tomjerry.vl, the StringReplacer with this Regular Expression does the trick.

(?<=\d)\s+(?=\d)

0684Q00000ArK5OQAV.png

 

Alternatively this string expression returns the same result.

@ReplaceRegEx(@Value(Before),"(?<=\d)\s+(?=\d)","")

 

TQ so much it is working