CODEWITHSUNDEEP
notepad++
itlahic
itlahic

Reputation: 11

Replace before String in Notepad++

Searched around and haven't found a string like mine.

ID:Name:Email:IP:Pass_Hash:Pass_Salt

How would I removeID:so I have 

Name:Email:IP:Pass_Hash:Pass_Salt

Then remove Email:IP: so it would be 

Name:Pass_Hash:Pass_Salt

Upvotes: 1

Views: 81

Answers (2)

RaGe
RaGe

Reputation: 23697

Input:

ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt
ID:Name:Email:IP:Pass_Hash:Pass_Salt

Find and replace, regex mode:

Find what: ^(.*?):(.*?):(.*?):(.*?):(.*?):(.*?)$
Replace with: \2:\5:\6

enter image description here

Result:

Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt
Name:Pass_Hash:Pass_Salt

Explanation

^ Matches start of string
.*?: Matches any set of characters until :
$ Matches end of string

( ) is a captured value, you're replacing with the 2nd, 5th and 6th captured groups.

Upvotes: 1

Doc Rinehart
Doc Rinehart

Reputation: 83

Good ole Ctrl+F find and replace. Regular expressions are supported in NPP; You'll probably need to handle removing ID first, then strip out IP. I assume you're referring to a list of data, and not just the flat string?

Upvotes: 0

Related Questions