Removing numbers and emoji

Joss Medina

i want to remove the number, dot(.) and emoji.
Can someone please provide some suggestions

BEFORE:

1.🐯 to export
2.🐲 chain
3.🐲 process fees
4.🐲 수고하다
5.🐯 수입품
6.🐲 수입하다

AFTER:

to export
chain
process fees
수고하다
수입품
수입하다

astrosofista

Hi @Joss-Medina

Try this:

Place the caret at the beginning of the first line to change. Then open the Find panel and copy the following line:

Find what: (?-s)^\d+[^ ]+?\x20
Replace with: [leave empty]

Select the Regular expression search mode, and click the Replace All button.

Hope it helps.

Joss Medina

This post is deleted!

guy038

Hello, @joss-medina, @astrosofista and All,

@astrosofista, as all the emoji symbols, in OP text, have an Unicode code-point over the Basic Mutilingual Plane ( BMP ), so above \x{FFFF}, our Boost regex engine is, generally, not able to find them properly :-(

So instead of using a negative character class [^....] , which, obviously, does not work, I would suggest the classical regex syntax, below, which matches, from beginning of line, the shortest range of standard characters till a Space char :

SEARCH (?-s)^.+?\x20

REPLACE Leave EMPTY

Best Regards,

guy038

PeterJones

Given that @Joss-Medina specifically indicated lines starting with a number, I’d recommend a hybrid of @astrosofista’s and @guy038’s solutions:

FIND WHAT = (?-s)^\d+.+?\x20

Like @astrosofista’s solution, this requires that the line start with one or more digits. Like @guy038’s solution, it allows any characters between the digits and the space.

astrosofista

@guy038 said in Removing numbers and emoji:

our Boost regex engine is, generally, not able to find them properly

@guy038, yes sorry, you’re right, I was misguided by my PCRE education :(