Originally Posted by
p45cal
Yes, one of the assumptions is that there'd only be numbers after the delimiter (- or,).
You'd have expected this entry to be 7103A104-105.
But what if next time we see an entry like 7103A114-C156?
I will look at correcting where the delimiter has been put, but I won't have much time in the next day or two.
The real trouble is that the raw source data is highly inconsistent; I can foresee a continuous stream of work-arounds being needed.
It is that that needs to be sorted.
Hi, thank for supporting me a lot, I tried to fix by below code
Dim RegEx As Object
Set RegEx = CreateObject("VBScript.RegExp")
RegEx.Global = True
RegEx.Pattern = "[A-Za-z]"
zz(UBound(zz)) = RegEx.Replace(zz(UBound(zz)), "")
DigitCount = Len(zz(UBound(zz)))
For i = CLng(Right(zz(0), DigitCount)) To CLng(zz(UBound(zz)))
By that way. it removed all alphabet char and skip to correct address.
I totally agreed about the raw source data is highly inconsistent. It makes me stuck on it during this week.
So i wondered if the source data is bigger, seems about over 1000 rows, does this logic excutes a lot of time, if yes , can you suggest me a solution to optimaze when data is big.
Thanks so much for spending your time.