Find And Replace

Banda_VA · Post by **Banda_VA** » Mon Dec 14, 2015 12:45 am

Hi All,

I am trying to get rid of some of the extra characters that appear in the Document ID. The Document ID appear as follows.

DOT00017197_01_d29fbdfb-f876-43ec-aea4-f9b20f10df63
DOT00017197_02_85027e57-537a-4c10-8ad7-2359c174794a
DOT00017197_03_1d48ddc5-61a3-46ac-b98e-7b86c935e85d
DOT00017197_04_087dc70a-9f10-43cc-bc5e-79f12644a584
DOT00017197_05_ca4567fe-dda5-49eb-a7db-225e51919879
DOT00017197_06_e62b7f5b-d798-48a8-a169-c88a28ac12aa
DOT00017197_07_f84e0e08-f07c-4042-bc99-e5e339e3d9fe
DOT00017197_08_a6c81074-3e9f-4f47-ad3b-42624eedd11e
DOT00017197_09_c00c231a-f350-4403-a79c-210f89d25146
DOT00017197_10_8a79f92a-ab4d-45e8-acc7-b9a496a78619

I would like it as shown below.

DOT00017197_01
DOT00017197_02
DOT00017197_03
DOT00017197_04
DOT00017197_05
DOT00017197_06
DOT00017197_07
DOT00017197_08
DOT00017197_09
DOT00017197_10

Can you please let me know if there is a way to do it using FIND and REPLACE feature in TextPad? I tried to do it in Excel with no success.
Thanks

Post by **MudGuard** » Mon Dec 14, 2015 6:22 am

Search for the underscore and after that loads of characters that are not underscores, up to the line end:

Find (Regex)

Code: Select all

_[^_]+$

Replace by nothing.

Banda_VA · Post by **Banda_VA** » Tue Dec 15, 2015 12:54 am

Thank You MudGuard !!! It worked and i'm delighted.