需要帮助搜索和替换模式 [英] Need help with search and replace pattern

问题描述

大家好，



很快就会非常清楚我是一个非常初学者。如果我没有去过，我可能会找到一个巧妙的表达方式来填写非常给我：p无论如何 - 我希望这里有人可以用我一直在寻找的表达来帮助我节省一些时间来编辑一个excel工作表。



我的示例文本如下：

Hi guys,

As very soon will be very clear I'm very much a beginner. If I hadn't been, I'd probably find a neat expression to fill in the "very" for me :p Anyway - I hope someone here could help me out with an expression I've been looking at to save some time editing an excel worksheet.

The sample text I have is the following:

Load
#=MROUND(('Testing Program'!L28)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M__);2,5;'Testing Program'!M__))-'Testing Program'!I__
#=MROUND(('Testing Program'!L29)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M__);2,5;'Testing Program'!M__))-'Testing Program'!I__
#=MROUND(('Testing Program'!L32)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M__);2,5;'Testing Program'!M__))-'Testing Program'!I__



Load
#=MROUND(('Testing Program'!E35)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E37)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E39)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E41)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E43)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_



Load
#=MROUND(('Testing Program'!L30)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M__);2,5;'Testing Program'!M__))-'Testing Program'!I__
#=MROUND(('Testing Program'!L31)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M__);2,5;'Testing Program'!M__))-'Testing Program'!I__
#=MROUND(('Testing Program'!L33)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M__);2,5;'Testing Program'!M__))-'Testing Program'!I__



Load
#=MROUND(('Testing Program'!E36)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E38)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E40)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E42)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_
#=MROUND(('Testing Program'!E44)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_

我需要的是制作一个正则表达式，它将取第一部分的行号并用下划线替换它。



例如：

What I need is to make a regex that will take the row number from the first part and replace it with the underscores.

Example:

#=MROUND(('Testing Program'!L28)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M__);2,5;'Testing Program'!M__))-'Testing Program'!I__

=>

#=MROUND(('Testing Program'!L28)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!M28);2,5;'Testing Program'!M28))-'Testing Program'!I28

和

and

#=MROUND(('Testing Program'!E35)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F_);2,5;'Testing Program'!F_))-'Testing Program'!B_

=>

#=MROUND(('Testing Program'!E35)*(AW6/100);2,5);IF(ISBLANK('Testing Program'!F35);2,5;'Testing Program'!F35))-'Testing Program'!B35

我尝试过：



我还没有真正走得太远。我已将上述文本粘贴到测试模式选项卡的示例部分。我已经玩了一些基本的东西，但我甚至不确定我是否需要逃避示例文本部分中的文本 - 或者需要转义哪些字符。大约二十年前我做了一些正则表达式，但大部分来自日志文件的纯文本，然后主要是搜索。



这就是我拥有的正则表达式，但运行验证甚至不匹配一件事：

What I have tried:

I haven't really come far. I've pasted the above text into the sample part of the test mode tab. I've played around with just some basic stuff, but I'm even not sure if I need to escape the text in the sample text part or not - or which characters need to be escaped. I've done a little bit of regex some twenty years ago, but mostly plain text from log files, and then mostly searching.

This is what I have for my regular expression, but running validate doesn't even match a single thing:

\#=MROUND\(\(\'Testing Program\'!([L]+L)(\d)\)*\(AW\d/100\);2,5\);IF\(ISBLANK\(\'Testing Program\'!M__\);2,5;\'Testing Program\'!M__\)\)-\'Testing Program\'!I__

我非常感谢你能给我的任何帮助。这对我来说是一次非常好的学习经历。



谢谢！

I would be extremely grateful for any help you can give me. This will be a really nice learning experience for me.

Thanks!

推荐答案

好的，这是关于我上床睡觉的时间。我目前使用

Ok, it's about time I went to bed. I've currently come as far as using

(#=MROUND\(\('Testing Program'![L](\d+)\)\*\(AW\d\/100\);2,5\);IF\(ISBLANK\('Testing Program'!M)(__)(\);2,5;'Testing Program'!M)(__)(\)\)-'Testing Program'\!I)(__)

作为我的正则表达式和

as my regular expression and

1

2

这篇关于需要帮助搜索和替换模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！