Remove double-quotes with TPIPE

May 20, 2008
11,414
99
Syracuse, NY, USA
That works. Thanks. I couldn't get any combination of escaping the double-quote and back-quoting the whole arg to work.
 
May 20, 2008
11,414
99
Syracuse, NY, USA
Well, it works, but is god-awful slow compared to the same with first option 4 (Perl pattern) ... 9 minutes vs. 5 seconds! Look:
Code:
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
 
Similar threads
Thread starter Title Forum Replies Date
Dmitry L. Kobyakov How to? How to remove the record of the old version of the Take Command? Support 9
MikeBaas Edit/remove kbd shortcuts of Macro Recorder? Support 7
gworley rd (Remove Directory) gives interesting error: Support 2
x13 TPIPE /REPLACE - Remove line (including EOL) Support 3
C NE1 have BTM to remove %appdata\JP Software\ etc... Support 0
H DOS CMD Sort+Add Sequence+Remove Sequence number Support 12
H Remove all previous activations Support 4
D Fixed Cut and paste in TC's file/folder view does not remove file Support 17
vefatica Must update remove my taskbar-pinned shortcut? Support 20
A How to? Remove last argument on command line Support 4
samintz How to? remove adjacent common chars Support 2
C Drag-and-drop from file-view may "remove" Support 1
S Setup - remove older versions? Support 4
C Can't remove leading quote from a string Support 2
A Cannot permanently remove Tabs toolbar using View menu - bug? Support 8
thedave Remove a section from an INI file Support 6
vefatica Literal double quotes in SHORTCUT's "args" parameter? Support 6
D Double Quote in TC Tool Bar Button Command line Support 3
vefatica Why does @WSLPATH double the leading '/'? Support 7
T TPipe: Replacing String with Double Quotes Support 3
G Selection characters with mouse double-click Support 3
W TCMD 16: double characters Support 11
vefatica IDE double-click select? Support 29
CWBillow Double Registration? Support 1
T KEYSTACK and double-double quotes dropping spaces Support 2
Steve Pitts How to? FFIND, regular expressions and double quotes Support 4
noahcoad Fixed tcc /k not emulating cmd.exe w double quotes Support 1
M How to? Parsing lines containing double quotes... Support 3
B TCC v12 display double problem Support 2
K double click to run btm? Support 2
H Double prompt for password with * in FTP syntax Support 3
S Starting TCC with double click on tab bar Support 0
vefatica `Back quotes` - command line vs. batch file Support 5
R Inconsistency in @version's use of quotes Support 2
vefatica TPIPE: unbalanced escaped quotes in a regex? Support 5
A How to safely print variable's value without quotes? Support 9
Charles Dye TCC smashing Unicode quotes Support 9
greyfairer TCC Quotes needed for Arguments containing '='? Support 11
noahcoad Fixed Can't @iniread a section w quotes in the name Support 6
G backticks and quotes and @LEFT (v8 vs. v9 & v11) Support 1
J Nested for loops and quotes Support 12

Similar threads