search

mazamorac / ExcelMazRegex

Excel regular expressions add-in using ExcelDNA 1.0
MIT License
7 stars 1 forks source link

64 = RightToLeft not working for RegexReplace #1

Open HRS2049 opened 2 years ago

HRS2049 commented 2 years ago

Hi, man This is the best addin I can find so far for EXCEL, I really appreciate it. It looks it has not been updated for 2 year, looking forward to seeing the update afterwards(EXCEL-DNA has also been updated) I tried RegexReplace by adding "option 64=RightToLeft", but it did not show as expected, see bellow yellow item. BTW, it is really working on RegexMatches. Thanks again for this great addin. image

mazamorac commented 2 years ago

Sure, thanks for the appreciation. I've not needed any new functionality, nor has anybody asked, so I haven't touched the code in a while.

Anyway, can you make a tiny spreadsheet with that example? I'm not quite sure what the cells and their contents are; a working example would be unambiguous.

Once I get that, and once I have time over a weekend to re-create my dev environment, plus update the ExcelDNA version in it, I'll have a chance to debug that.

HRS2049 commented 2 years ago

Thanks for your quick feedback, Sir. Please have the sheet here. Regex Test.xlsx

HRS2049 commented 2 years ago

Hi, Sir It may not be good to ask if you could have time to do the update, but looking forward to seeing the new version. Thanks a lot. Another question(maybe a stupid question): Is it possible to add another "option" to make each matching item(seperated by comma) from regexmatches into different column or row so there is no need to use excel funtion such as textsplit or use power query? Thanks again!