Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2021, 10:44 PM
davidjm davidjm is offline how do I replace string 123-4 with 123 4 Windows 10 how do I replace string 123-4 with 123 4 Office 2016
Novice
how do I replace string 123-4 with 123 4
 
Join Date: Jun 2018
Posts: 18
davidjm is on a distinguished road
Default

Hi Andrew,
Thanks very much for this, going to give it a try - I'll let you know.
Think that difference between n-dash and hyphen is what I was missing, although don't see where you've specified the type of dash (no Asc values).
To complete this code also need to include 1 - 3 digit numbers.
I'm dealing with 1 problem at a time, the current index has for example 129-1 - not ideal but understandable
Reply With Quote
  #2  
Old 10-30-2021, 03:11 AM
davidjm davidjm is offline how do I replace string 123-4 with 123 4 Windows 10 how do I replace string 123-4 with 123 4 Office 2016
Novice
how do I replace string 123-4 with 123 4
 
Join Date: Jun 2018
Posts: 18
davidjm is on a distinguished road
Default

Hi Andrew,
Thanks very much for taking the time to do this, much appreciated.
Huge advance and I've learned alot more from this than Googling in the dark.
I've noticed there's a mixture of formats for page ranges as you can see from below:

Before .................................................. ........ After
average variable (AVC) 108, 305 < > average variable (AVC) 108, 305
external 41–3, 164–5, 175, 186–8 < > external 41–3, 166-7, 175, 188-10
long run 113–14 < > long run 115-34
marginal (MC) 105–6, 110 < > marginal (MC) 107-8, 110
private 41–2, 186 < > private 41–2, 186
short run 106–9 < > short run 108-11
social 186–7 < > social 188-9
credit 16, 205, 206, 215, 258–61, 308 < > credit 16, 205, 206, 215, 260-81, 308

If there's for example 186-8 then After should be 188-0 (to keep the current format)
I have another question, your code includes
Code:
    .Text = "[0-9]{3}–[0-9]{1}"
This is a regex notation, but there's no mention of a RegExp object. How does that work?
Thanks for all your help
Reply With Quote
  #3  
Old 10-30-2021, 10:38 AM
davidjm davidjm is offline how do I replace string 123-4 with 123 4 Windows 10 how do I replace string 123-4 with 123 4 Office 2016
Novice
how do I replace string 123-4 with 123 4
 
Join Date: Jun 2018
Posts: 18
davidjm is on a distinguished road
Default

Hi, trying to make this a bit more flexible.
Replaced
Code:
.Text = "[0-9]{3}–[0-9]{1}"
With
Code:
.Text = "[0-9]+–[0-9]+"
(this works in regex101: build, test, and debug regex)
but it's not working here, why is this?

As well as finding numeric strings with "-" I also need to find numeric strings from 1 - 999 does that mean running a second aRng.Find ?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I replace string 123-4 with 123 4 Replace characters in a string Marcia Excel Programming 5 05-04-2020 05:15 AM
how do I replace string 123-4 with 123 4 Wildcard replace any string in context with a specified string wardw Word 7 05-07-2018 09:13 AM
how do I replace string 123-4 with 123 4 Replace multiple strings by one same string at once puff Word 2 02-28-2018 11:04 AM
how do I replace string 123-4 with 123 4 Replace characters in a string Anthon Excel Programming 1 11-03-2016 12:48 AM
How to do multiple find and replace in string. PRA007 Word VBA 2 01-06-2016 09:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft