RegEx pattern to remove string between two specific characters

Question

I am cleaning some HTML strings and would like to remove empty spaces between > and < characters.

This is an example of my string:

<h4>Specifications</h4>    <table>  <tr>  <td>Brand</td>    <td>Dell</td>    </tr>  </table>

I would like to remove those X empty spaces between html tags.

Please read [Why is “Can someone help me?” not an actual question?](https://meta.stackoverflow.com/a/284237/3219613) and show us what you have tried so far. Then ask a *specific* question to the code you have tried. — Pᴇʜ, May 09 '17 at 06:46
start here: http://stackoverflow.com/questions/22542834/how-to-use-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops — avb, May 09 '17 at 06:55
@Sgdva, trim will not clear spaces inside a string, only leading and trailing — avb, May 09 '17 at 06:57
@avb You're right, my bad. He can use substitute " " for "". — Sgdva, May 09 '17 at 07:17

score 0 · Accepted Answer · answered May 09 '17 at 07:01

0

Pretty straight-forward:

>\s+<
# match >
# 1+ whitespaces
# <

This needs to be replaced by ><, see a demo on regex101.com.

answered May 09 '17 at 07:01

Jan

1 Answers1