删除所有其他换行符 [英] Remove every other newline
问题描述
我有一个文本格式的数据列表，如下所示：
Name1 Name2
$ b $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ b
Name1 Name2
位置工作日期金额
$ / code
$ b $ p $ Name $ Name2
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $'
我需要以某种方式进入
Name1 Name2 location工作日期金额
...
必须用正则表达式或者Excel来抓住每一个换行符。我可以写一个python脚本，但是这个文件是一个痛苦，希望有一个更简单的方法来做到这一点。
编辑：添加我在下面试过的内容：
对不起，我应该包含一些代码。 。我试过
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
在正则表达式中，但是把这两行组合在一起，我基本上只想抓住组。我也试着在excel中系统地做这件事，但是当我拖动盒子的时候，它不会继续抓住每一个单元格。它会从列中的每一个单元格改变到每个单元格，一旦我尝试挤压它。 使用.Net正则表达式调味（应该是VBA相同，但我没有检查），我想出了以下内容：
Pattern =（ [^ \\\
] *）（\\\
）（[^ \\\
] *（\\\
| \z））
Replacement =$ 1 $ 3
基本上，捕获第二个捕获组中的第一个NewLine字符，然后在我们的替换中不返回。
希望这有助于。
I have a list of data in text format that looks as follows
Name1 Name2
location job date amount
Name1 Name2
location job date amount
Name1 Name2
location job date amount
I need to somehow make this into
Name1 Name2 location job date amount
...
I figure there has got to be a way to grab every other newline with either regex or excel. I could write a python script but this file has been a pain and was hoping there would be an easier way to do it.
EDIT: adding what I've tried below:
Sorry, I should have included some code... I tried
([^\n]*\n)[^\n]*\n
in regex, but that groups the two lines together, I basically would like to grab only the newline between the groups. I have also tried doing this in excel systematically but it doesn't continue to grab every other cell when I drag the box down. It changes from every other cell in the column to every cell once I try to extrude it.
解决方案 Using .Net regex flavoring (should be the same for VBA, but I didn't check), I came up with the following:
Pattern = "([^\n]*)(\n)([^\n]*(\n|\z))"
Replacement = "$1$3"
Basically, catching the first NewLine character in the second capture group and then not returning it in our replacement.
Hope this helps.
这篇关于删除所有其他换行符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
