Skip to main content
Solved

remove spaces between numeric values


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)","")

 

View original
Did this help you find an answer to your question?

2 replies

takashi
Evangelist
  • 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
  • January 21, 2020
takashi wrote:

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings