DataMystic

Hi,

I am trying to use Textpipe Pro (evaluation), I usually use AWK.

Trial data
2048889V3 :3x 8may04 :COMMODORE
2150633V2 :3x 8may04 :FORD
2066691V1 :16,17,18,30apr04 1,2,8,9,10may :FORD

Expected Output
2048889V3,8may04
2150633V2,8may04
2066691V1,30apr04

I have created 2 filters (extract matches)
1. ^\w{9}
2. [0-9]+(jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec)[0-9]{2}

It runs fine each of them but not both.
How to combine those filters together ?
or is there better way to do it such search & replace for example ?

Thanks

Hartono Rusmin
Consultant
Netmap Analytics Pty Ltd