How to extract a substring using Regex

Mujkanovic · Nov 15, 2018

I have a data like this

Code:

611556:WNYV:example1:173.44.62.120:7687954bf04f5acve4e047d6dcfa660a:v7B#4cfpKyui-vvR~"8%3pPz%-ulwO                
611543:ABurdick:example2:110.85.101.65:97da66b8e2aaa0801514d588bcb10253:(V7=HrBQWxV3tuddz+UMNqUMt6CGTS                
611582:CSleath:example3:107.155.116.101:1920163604e9642d482a011ed9351a7d:_ytt8b5yZD9sz~MMBIsi?Bj\il1HHU

I want to get example1, example2, example3 on per line. How can I do this using Regex?

Malware.Expert · Nov 15, 2018

Not sure which language you use, but example PHP you can foreach lines and get result to array:

$array = preg_split('/:/', $input_line);

then $array[2], you have picked example1,2,3

http://php.net/manual/en/function.preg-split.php

mobin · Nov 16, 2018

[root@ ~]# cat preg.txt
611556:WNYV:example1:173.44.62.120:7687954bf04f5acve4e047d6dcfa660a:v7B#4cfpKyui-vvR~"8%3pPz%-ulwO
611543:ABurdick:example2:110.85.101.65:97da66b8e2aaa0801514d588bcb10253V7=HrBQWxV3tuddz+UMNqUMt6CGTS
611582:CSleath:example3:107.155.116.101:1920163604e9642d482a011ed9351a7d:_ytt8b5yZD9sz~MMBIsi?Bj\il1HHU

[root@ ~]# cat preg.txt | awk -F":" {'print $3'}
example1
example2
example3
[root@ ~]#

You can use above command as well in case you want to extract the field from shell

Mujkanovic · Nov 16, 2018

Code:

[root@ ~]# cat preg.txt | awk -F":" {'print $3'}

This will overwrite into preg.txt file? if I want to save new data to a new file name?

Malware.Expert said:
Not sure which language you use, but example PHP you can foreach lines and get result to array:

I run this code

PHP:

<?php

$input_line='611556:WNYV:example1:173.44.62.120:7687954bf04f5acve4e047d6dcfa660a:v7B#4cfpKyui-vvR~"8%3pPz%-ulwO              
611543:ABurdick:example2:110.85.101.65:97da66b8e2aaa0801514d588bcb10253:(V7=HrBQWxV3tuddz+UMNqUMt6CGTS              
611582:CSleath:example3:107.155.116.101:1920163604e9642d482a011ed9351a7d:_ytt8b5yZD9sz~MMBIsi?Bj\il1HHU';

$array = preg_split('/:/', $input_line);

//print_r($array);

echo $array[2];

echo $array[7];

echo $array[12];

?>

$array[2] only gave example1

Malware.Expert said:
then $array[2], you have picked example1,2,3

How to run it with foreach to echo all example1, example2, example3 ?

mobin · Nov 19, 2018

This will overwrite into preg.txt file? if I want to save new data to a new file name?

No it won't..if you want the output in a new file use following

[root@ ~]# cat preg.txt | awk -F":" {'print $3'} > newfile.txt

Mujkanovic · Nov 19, 2018

@mobin

[root@ ~]# cat preg.txt | awk -F":" {'print $3'}

What does it mean for this command? can you explain it in details? so i can apply with other patterns

[root@ ~]# cat preg.txt | awk -F":" {'print $3'} > newfile.txt

Sounds great, I must try it to see how it works.

Nixtree · Jan 7, 2019

Hope you are already got it figured by this time. Any ways I will just add a bit more for your reference

In your example, the only common which separates each is "," so we can use that.

$ cat test.txt

(143, 2, '', 0, 'juicy', 'dbdf6d92aba8be1838c0ac48c4959622', '2007-04-16', '[email protected]', 0, '', '', '', '', '', 1, 0, 'Newbies', 0, 1164906590, 0, 1175865657, 1176753268, 0, 0, 10, 5, '0', 2, 0, 0, 0, 45112407, '', '0000-00-00', -1, -1, '203.144.143.10', 0, 1, '', 0, 0, 3, 17, 17, '$QU', '', 0, 0, 0, 0, 0, 0, '', 0, 250, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 1, '', 1326351663, 0, 0, 0, 1, 1, '', '', 0, '', 'vb', '', 0, 1, 0, 0, 0, 0, '0', 0, 0, 0, '', '', 0, NULL),

$ cat test.txt |awk -F"," {'print $8'}

'[email protected]'

Hope you get the idea now. Please try with more and update if you need any more help

How to extract a substring using Regex

Mujkanovic

Well-known member

Malware.Expert

Member

mobin

Well-known member

Mujkanovic

Well-known member

Malware.Expert

Member

Mujkanovic

Well-known member

mobin

Well-known member

Mujkanovic

Well-known member

mobin

Well-known member

Mujkanovic

Well-known member

mobin

Well-known member

Mujkanovic

Well-known member

Nixtree

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud