V
V
volt1112021-08-29 18:52:37
Regular Expressions
volt111, 2021-08-29 18:52:37

How to edit with Notepad++?

the following text:

Huntington, West Virginia You; Marco Miller; 100000935315939
Guanajuato; Alexis Sanchez; 100044230306475
Puebla City; Espinoza Carlos; 100013567387160
Guasave, Sinaloa; Tortilleria Lopez; 100039425674785

do so:

100000935315939; Marco Miller
100044230306475; Alexis Sanchez
100013567387160; Espinoza Carlos
100039425674785; Tortilleria Lopez

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
SagePtr, 2021-08-29
@volt111

Assuming that strings do not contain more than a semicolon other than separators, then with a regular expression:
^[^;]*;([^;]*);([^;]*)$
Replace with $2;$1

S
Shellr57s, 2021-12-21
@Shellr57s

;(.*;)(\d+\s)
$1$2

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question