Remove string between numbers

[ATR]

Hi all,

I have a problem with a regex expression. I have a string with many numbers and i want remove all between them.

My string <tr> <td>30/09/2013</td> <td> 69 290 &euro; </td> <td> 9 980 </td> <td></td> </tr>

And I want the result is ;~ <tr> <td>30/09/2013</td> <td> 69290 </td> <td> 9980 </td> <td></td> </tr>

Stringstripws don't work because it's not spaces between numbers. I thing we want use [^d] but I have not find solution.

Thanks in advance

The string is in the file

Code_source_html.html

Edited April 9, 2014 by ATR

[mikell]

$str = "<tr> <td>30/09/2013</td> <td> 69Â 290 </td> <td> 9Â 980 </td> <td></td> </tr> <tr> <td>30/09/2012</td> <td> 46Â 350 &euro; </td> <td>    1Â 280 </td> <td></td> </tr> <tr> <td>30/09/2011</td> <td> 12Â 030 </td> <td> 20Â 260 </td> <td></td> </tr> </tbody> </table>"

$res = StringRegExpReplace($str, '\h*(\d+)[^\d/]+(\d+)[^<]*', '$1$2')
msgbox(0,"", $res)

?

Edited April 9, 2014 by mikell

[ATR]

It doesnt work properly

[sahsanu]

Hello,

I think you should provide a little more info regarding the issue instead of "it doesnt work properly" ;-)

Cheers,

sahsanu

[iamtheky]

$str = fileread("Code_source_html.html")
msgbox(0, '' , stringreplace($str , " " , ""))

in the string replace instead of space, i typed alt+0160

and with all spaces including those removed:

$str = fileread("Code_source_html.html")
msgbox(0, '' , stringstripws(stringreplace($str , " " , ""),8))

Edited April 10, 2014 by boththose

[jdelaney]

_IETableWriteToArray

[mikell]

Please explain, I tried this and it works

$str = fileread("Code_source_html.html")

$res = StringRegExpReplace($str, '\h*(\d+)[^\d/]+(\d+)[^<]*', '$1$2')
msgbox(0,"", $res)

[ATR]

 

Please explain, I tried this and it works

$str = fileread("Code_source_html.html")

$res = StringRegExpReplace($str, '\h*(\d+)[^\d/]+(\d+)[^<]*', '$1$2')
msgbox(0,"", $res)

In fact your code replace all between numbers : 123 text with text 456 the result is 123456, but I don't want this result. I want only caracters not in a-zA-Z and 0-9

I don't say if you have seen in the file, but characters between numbes it's not space...

[iamtheky]

it is a space, just a "No-Break Space" also known as U+00A0 or the alt code 0160.  Any reason my solution in post #5 is failing your criteria?

Edited April 10, 2014 by boththose

[mikell]

 I have a string with many numbers and i want remove all between them.

My string <tr> <td>30/09/2013</td> <td> 69 290 &euro; </td> <td> 9 980 </td> <td></td> </tr>

And I want the result is ;~ <tr> <td>30/09/2013</td> <td> 69290 </td> <td> 9980 </td> <td></td> </tr>

 

It's exactly what the regex does, it removes all (including xA0)

But this looks like a wrong way so can you please post a clear sample of expected result ?

[Wilenty]

It's exactly what the regex does, it removes all (including xA0)

But this looks like a wrong way so can you please post a clear sample of expected result ?

$SomeString="<tr> <td>30/09/2013</td> <td> 69 290 &euro; </td> <td> 9 980 </td> <td></td> </tr>"; set, or get from HTM(L)
$timer=TimerInit()
$NewString=StringRegExpReplace($SomeString , "&.*;" , ""); replace from: "&", until: ";", to: ""
$ReplacedString=StringReplace($NewString , " " , ""); replace: " ", to "" (all spaces)
$Super=StringRegExpReplace($NewString , "(\d)\s(\d)" , "$1$2"); replace " " between the digit to: ""
msgbox(0, 'Timer: ' & TimerDiff($timer) & " ms" , "Some String         :" &  $SomeString & @CRLF & _
        "NewString (&*;)   : " & $NewString & @CRLF & _
        "ReplacedString ( ): " & $ReplacedString & @CRLF & _
        "WhatYouWant      : " & $Super)

Greetings (P.S. Give me +1 if it's help You) :-)

Edited April 10, 2014 by Wilenty