http://www.perlmonks.org?node_id=983829


in reply to Re^5: regex optional word match
in thread Parsind data in xlsx

Sorry Guys,I am new here.
I have one array with 2 Strings:

String1: "REMOTE [Mon Jul 16 21:49:33 2012] @@ [ueh1] [TNT] [2049 +0] [1916] 0.0- 1.0 sec 0.33 MBytes 2.74 Mbits/sec 6.056 ms 0/ + 233 (0%)". String2: "REMOTE [Mon Jul 16 21:49:34 2012] @@ [pdn1] [SSH] [2049 +9] [3] 1.0- 2.0 sec 0.34 MBytes 2.86 Mbits/sec".

In "String1" I have two extra values that is "6.056 ms" and "0/ 233 (0%)" and rest are same in both string.
I tried this regex:

<m/^REMOTE\s+\[(.*?)\]\s+(\S+)\s+(\S+)\s+(\S+)\s+(\S+)\s+\[(.*?)\]\s+ +(.*?)sec\s+(.*)MBytes\s+(.*)Mbits\/sec>
but need to add the above mentioned two values of String1 in regex and make them optional so that both condition gets passed and last values stored in $1, $2, $3 and so on.
Can anyone help me?
Thanks in advance