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
How to combine 2 filters (extract)
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators