Replace space $ with tab $ sign

[hag]

I have data that I need to replace everywhere I have a space followed by a $ with a tab followed by a $. The replacement value I am entering is “\t$”. Without the Regular Expression on, it can find the space followed by a $ with, but replaces it with “\t$”. With the Regular Expression on, it will not find the space followed by $

[Lupp]

Is this actually about literal dollar signs?
Or
is it about replacing any space with a HT under the condition that it is the last character of a paragraph?

[anon73440385]

Hello,

A literal $ requires to be quoted \$ in regular expressions, since a $ has special meaning of Match at the end of a line - see table in ICU regular Expression - Metacharacters (RegExp API used by LibreOffice)

Thus use:
Find: \s\$
Replace: \t$
Other Options: [x] Regular expressions

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.

[hag]

Thank you very much. That worked.

[LeroyG]

Metacharacters section in new ICU’s Regular Expressions page.

[RGB-es]

The $ sign alone has a special meaning within RegExp (it looks for the end of the paragraph), so you need to “turn it into a normal character.” Activate Regular Expressions, search for

\$

(space, backslash, $), and replace by

\t$

---

EDIT: fixed typo

[hag]

Thank you very much. That worked.