how to remove certain words in line before a certain word

Asked Mar 30 '17 at 03:19

Active Mar 30 '17 at 03:19

Viewed 22 times

this one is abit complex.. i need to edit a file that contains lines that have 5 ":" to differentiate.. what i want is to Regex remove anything before 4 ":" and keep what ever is left on that line.. example:

DATA:1000:031:6566:3180:sdhfdsd

DATA:cuoleL

DATA:000:45:133:37081:fsdfsd

DATA:jhh0:70165:50:687:csdhg

DATA:236:93438:34:1ds:dsdbhz

now for this example in line 1 i want to get only "3180:sdhfdsd" and delete whatever is before it i.e "DATA:1000:031:6566:"

and as you can see line 2 doesnt have 5 ":" so the search skips line 2..

please reply... thanks again community!

asked Mar 30 '17 at 03:19

Texh

1,763
2
11
8

In eclipse the search will be `.*?:.*?:.*?:.*?:(.*?)\n` and replace will be `$1\n` – prajeesh kumar Mar 30 '17 at 03:28
Even simplifying `(.*?:){4}(.*?)\n` and replace with `$2\n` – prajeesh kumar Mar 30 '17 at 03:31
thanks mate for quick and simple answer.. – Texh Mar 30 '17 at 03:39
Please tell me how to do it when there is different number of ":" per line like some lines have 5 ":" and some have 4":" and some has 3 ":".. but what i want is the data between last ":" – Texh Mar 30 '17 at 03:49
That could be easy, try this `.*:(.*?)\n` replace with `$1` or this `.*:(.*?):(.*?)\n` replace with `$1:$2` – prajeesh kumar Mar 30 '17 at 04:10
this regex not working – Texh Mar 30 '17 at 13:03

how to remove certain words in line before a certain word

0 Answers0