By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!

Remove double-quotes with TPIPE

I've spent a couple hours on this so far. How do I remove double-quotes from a file with TPIPE?
Gotta pass it as something other than ASCII 34:

tpipe /replace=1,0,0,0,0,0,0,0,1,\x22,! /input=ascii.txt
That works. Thanks. I couldn't get any combination of escaping the double-quote and back-quoting the whole arg to work.
Well, it works, but is god-awful slow compared to the same with first option 4 (Perl pattern) ... 9 minutes vs. 5 seconds! Look:
v:\ip\test> timer tpipe /input=dbip-country.csv /output=junk /replace=1,0,0,0,0,0,0,0,1,\x22,!
Timer 1 on: 13:00:18
Timer 1 off: 13:09:24  Elapsed: 0:09:06.32
v:\ip\test> timer tpipe /input=dbip-country.csv /output=junk2 /replace=4,0,0,0,0,0,0,0,1,\x22,!
Timer 1 on: 13:10:48
Timer 1 off: 13:10:53  Elapsed: 0:00:04.65
v:\ip\test> d j*
2016-06-08  13:09  18,040,079  junk
2016-06-08  13:00  18,040,079  junk2

Maybe there's something wrong! ... eh?

The file in question is a 21MB quoted CSV database of IPv4 ranges and country IP codes. It can be found here: https://db-ip.com/db/download/country
Or their Perl regex library is just more efficient than their "old style"....

Similar threads