Rocksolid Light

Welcome to Rocksolid Light

mail  files  register  newsreader  groups  login

Message-ID:  

Love makes the world go 'round, with a little help from intrinsic angular momentum.

computers / microsoft.public.windowsxp.general / Is there any simple way to do this?

SubjectAuthor
* Is there any simple way to do this?Lu Wei
+* Is there any simple way to do this?R.Wieser
|`- Is there any simple way to do this?Lu Wei
`- Is there any simple way to do this?gfretwell

1
Is there any simple way to do this?

<udc7r8$18g$1@toxic.dizum.net>

  copy mid

https://news.novabbs.org/computers/article-flat.php?id=3112&group=microsoft.public.windowsxp.general#3112

  copy link   Newsgroups: microsoft.public.windowsxp.general alt.comp.os.windows-xp
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!sewer!.POSTED.localhost!not-for-mail
From: luweitest@gmail.com (Lu Wei)
Newsgroups: microsoft.public.windowsxp.general,alt.comp.os.windows-xp
Subject: Is there any simple way to do this?
Date: Thu, 7 Sep 2023 18:14:44 +0800
Organization: dizum.com - The Internet Problem Provider
Message-ID: <udc7r8$18g$1@toxic.dizum.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Injection-Date: Thu, 7 Sep 2023 10:15:04 -0000 (UTC)
Injection-Info: toxic.dizum.net; posting-host="localhost:127.0.0.1";
logging-data="1296"; mail-complaints-to="abuse@dizum.net"
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:52.0) Gecko/20100101 Firefox/52.0 Hamster-Pg/1.25.2.0
Thunderbird/52.9.1
X-Mozilla-News-Host: news://localhost:119
Openpgp: id=61E5EE6F494231F81AA2C6EEA12FEF7592CCE1EA
Autocrypt: addr=luweitest@gmail.com; prefer-encrypt=mutual; keydata=
xsDiBEfowZoRBACCADBlqVDeCH7P6O66N5tSVPbgjaVTADFFUbpLSHnbkoqogTBFnKDOoQsr
HYXC4g/W0lLlfcIEdZ6alQTyIjCdHLwNQDVqOv//GL0jZQwBN2ziJfb7FaUOQmA6kiY6lWYQ
8Ij43sZh1+KdmTNAJy3EVnln9Gu4pJbDxWl5rygBzwCggSNybNNRl2S3Oiebd1YRi5gDEOMD
/0eFBG1Y8yNIxQZNjHWzYb2fRjI743Bi2C8x+NcfSSYy5pcTpYo47Xv5iv4INHionIHbTb2x
gFe5GkK3CQ1v/SOohU7GY6L6l3aAtVYkjGi1QSts0MiJ1+ZTz2Wfl54XwdRopPq5Ftek+Zki
afNMnLzh23X6cbvk1UATQVB7u1SWA/9CmUnS6cmlqg1LY9yEpSD/TbHWJuj0HYgMnEH36o5V
n2LkiWP6CcmBxhTIHh5uL0IWZSFBC64gVHs0UBEMwuxYKFTp8tiCUD9LLWwjaW9W1LX0i8M5
NguLEKvnRVuo7JTmQoOiZ3hKGyyhfGylZ5bp/4O8uDlpeD/K6wNZl/h+cs0cTHUgV2VpIDxs
dXdlaXRlc3RAZ21haWwuY29tPsKCBBMRAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIX
gAIZARYhBGHl7m9JQjH4GqLG7qEv73WSzOHqBQJjI/hOBQkdHGo0AAoJEKEv73WSzOHqtFoA
njpM4gQIDjEVcE6dg7bnbxCOKnLRAJ0TnFH9HDp2/Azn0a38BpzMYr1JfM7BTQRH6MGaEAgA
xWn2jga6API5DqQ2+WjiUt9PIdL/g7aOESXsZAzDIsSzI4teO+G9rb+Am1TitTNZe4S0itnK
wBaR4uUEMWwe75mqKqmlsz9lc8YDLa+WU6obZuvYtpRZ2DHVm1lAqulGM+LTr+H5wFpEliLt
MqtS/cfUa/BJWhFXQHmUNFvpXd518lazfPgU6N4Yin8FIlSmsStrJR73KXtzzt8SJxcJBSFD
yrj0nfkehWUbZU3F1EV4fK94scni+5UK/5xNvtyfYtVZTcOE/1NIHWSOU1cloIgaUI9F4xvv
FJmmvfxlwvDtHDMhwUGGAXS7E82QtUfpJHsqXuq2OV7V8SwKzyIZOwADBQgAn4GC4TKWckZF
H8m4j44UUKfC5nAysiDnKxa5fqwg+p1duO19YQ8oUBwAAbl77/Cigwa3tTnD1ydi5JZ19T/P
s9lG4bPIloGRP/+G2W9tp3vm29fyHIXEU3N4gAzk7aGFbSenxKbey4K0S6yqTipbXZ1CWTpY
wM4SN1mCaehC7vjvPCN2AnNGjVLm+KM02x+qJLzjw4b5uXDoynjTx8Pb74aNSiIPM42Gpurq
MLj28GgMbIXi+3m/Je847Z4bilnSkN9Pm5cAPDtPQy0FXz4JgD9Sy/R2KVWbtpW7U7SIiMAI
6MItN6kBnOIYT65ZlbMdNHMK78B7Yract0+aZQrlq8JmBBgRAgAmAhsMFiEEYeXub0lCMfga
osbuoS/vdZLM4eoFAmMj+OgFCR0cas4ACgkQoS/vdZLM4eq8ZACfRKujULdkA5ktils1ovkS
zv+oI44AnjASx0BH5uYuCSOkb6yncTZndCMH
Content-Language: en-US
 by: Lu Wei - Thu, 7 Sep 2023 10:14 UTC

I have a bunch of big CSV(comma separated value text) files that should
be joined. I can't use the simple copy command like:
copy 1.csv+2.csv result.csv
because every csv file has a header line. The correct joining should
keep only one header line.

Is it possible to do this by a command or batch file? JSrcipt or
VBScript is also fine, yet it seems all lines will be processed, which
would be slow. Is there an efficient way to remove the first line only?

--
Regards,
Lu Wei
IM: xmpp:luweitest@riotcat.org
PGP: 0xA12FEF7592CCE1EA

Re: Is there any simple way to do this?

<udcaas$2v8io$1@dont-email.me>

  copy mid

https://news.novabbs.org/computers/article-flat.php?id=3113&group=microsoft.public.windowsxp.general#3113

  copy link   Newsgroups: microsoft.public.windowsxp.general alt.comp.os.windows-xp
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: address@is.invalid (R.Wieser)
Newsgroups: microsoft.public.windowsxp.general,alt.comp.os.windows-xp
Subject: Re: Is there any simple way to do this?
Date: Thu, 7 Sep 2023 12:57:03 +0200
Organization: A noiseless patient Spider
Lines: 14
Message-ID: <udcaas$2v8io$1@dont-email.me>
References: <udc7r8$18g$1@toxic.dizum.net>
Injection-Date: Thu, 7 Sep 2023 10:57:32 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="efafb5849c07e061b2247dbcfbfd1b74";
logging-data="3121752"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+yRI0eLKqEejURR5pIiKfFO1aDYmfo+5F5blWcuz7A1w=="
Cancel-Lock: sha1:SoCKSHqou2b+30lDjagrueMywb8=
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-Priority: 3
X-MSMail-Priority: Normal
 by: R.Wieser - Thu, 7 Sep 2023 10:57 UTC

Lu Wei,

> JSrcipt or VBScript is also fine, yet it seems all lines will be
> processed,
> which would be slow. Is there an efficient way to remove the first line
> only?

Using VBScript you could read (and discard) the first line(s) using
".readline", which you can than follow-up with a ".readall".

Regards,
Rudy Wieser

Re: Is there any simple way to do this?

<84tmfi9qcatecf25i78bdodo6irddkc7rd@4ax.com>

  copy mid

https://news.novabbs.org/computers/article-flat.php?id=3205&group=microsoft.public.windowsxp.general#3205

  copy link   Newsgroups: microsoft.public.windowsxp.general
Path: rocksolid2!news.neodome.net!feeder1.feed.usenet.farm!feed.usenet.farm!tr3.eu1.usenetexpress.com!feeder.usenetexpress.com!tr3.iad1.usenetexpress.com!69.80.99.26.MISMATCH!Xl.tags.giganews.com!local-2.nntp.ord.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 08 Sep 2023 19:25:04 +0000
From: gfretwell@aol.com
Newsgroups: microsoft.public.windowsxp.general
Subject: Re: Is there any simple way to do this?
Date: Fri, 08 Sep 2023 15:24:41 -0400
Message-ID: <84tmfi9qcatecf25i78bdodo6irddkc7rd@4ax.com>
References: <udc7r8$18g$1@toxic.dizum.net>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 14
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-d8lwHaDryD8gQichyJJww0cJQwMWb6LtDLd3KoWy5eZi33osl7b1rS0fn869r4c9ETgLNcJxrB/MgUy!OaGp2QzEMZvCoRTEkCSlKLVmLtUimu/bvCpGfR1aLBHSOf1KxGFIBFuFPL3K3rw0HtubIw==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
 by: gfretwell@aol.com - Fri, 8 Sep 2023 19:24 UTC

On Thu, 7 Sep 2023 18:14:44 +0800, Lu Wei <luweitest@gmail.com> wrote:

>I have a bunch of big CSV(comma separated value text) files that should
>be joined. I can't use the simple copy command like:
>copy 1.csv+2.csv result.csv
>because every csv file has a header line. The correct joining should
>keep only one header line.
>
>Is it possible to do this by a command or batch file? JSrcipt or
>VBScript is also fine, yet it seems all lines will be processed, which
>would be slow. Is there an efficient way to remove the first line only?

I imagine Excel would do it if the fields are compatible. Append each
new one to the accumulated file and then export as a CSV

Re: Is there any simple way to do this?

<udrjps$2nr$1@toxic.dizum.net>

  copy mid

https://news.novabbs.org/computers/article-flat.php?id=3212&group=microsoft.public.windowsxp.general#3212

  copy link   Newsgroups: microsoft.public.windowsxp.general alt.comp.os.windows-xp
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!sewer!.POSTED.localhost!not-for-mail
From: luweitest@gmail.com (Lu Wei)
Newsgroups: microsoft.public.windowsxp.general,alt.comp.os.windows-xp
Subject: Re: Is there any simple way to do this?
Date: Wed, 13 Sep 2023 14:10:50 +0800
Organization: dizum.com - The Internet Problem Provider
Message-ID: <udrjps$2nr$1@toxic.dizum.net>
References: <udc7r8$18g$1@toxic.dizum.net> <udcaas$2v8io$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Injection-Date: Wed, 13 Sep 2023 06:11:08 -0000 (UTC)
Injection-Info: toxic.dizum.net; posting-host="localhost:127.0.0.1";
logging-data="2811"; mail-complaints-to="abuse@dizum.net"
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:52.0) Gecko/20100101 Firefox/52.0 Hamster-Pg/1.25.2.0
Thunderbird/52.9.1
Openpgp: id=61E5EE6F494231F81AA2C6EEA12FEF7592CCE1EA
Autocrypt: addr=luweitest@gmail.com; prefer-encrypt=mutual; keydata=
xsDiBEfowZoRBACCADBlqVDeCH7P6O66N5tSVPbgjaVTADFFUbpLSHnbkoqogTBFnKDOoQsr
HYXC4g/W0lLlfcIEdZ6alQTyIjCdHLwNQDVqOv//GL0jZQwBN2ziJfb7FaUOQmA6kiY6lWYQ
8Ij43sZh1+KdmTNAJy3EVnln9Gu4pJbDxWl5rygBzwCggSNybNNRl2S3Oiebd1YRi5gDEOMD
/0eFBG1Y8yNIxQZNjHWzYb2fRjI743Bi2C8x+NcfSSYy5pcTpYo47Xv5iv4INHionIHbTb2x
gFe5GkK3CQ1v/SOohU7GY6L6l3aAtVYkjGi1QSts0MiJ1+ZTz2Wfl54XwdRopPq5Ftek+Zki
afNMnLzh23X6cbvk1UATQVB7u1SWA/9CmUnS6cmlqg1LY9yEpSD/TbHWJuj0HYgMnEH36o5V
n2LkiWP6CcmBxhTIHh5uL0IWZSFBC64gVHs0UBEMwuxYKFTp8tiCUD9LLWwjaW9W1LX0i8M5
NguLEKvnRVuo7JTmQoOiZ3hKGyyhfGylZ5bp/4O8uDlpeD/K6wNZl/h+cs0cTHUgV2VpIDxs
dXdlaXRlc3RAZ21haWwuY29tPsKCBBMRAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIX
gAIZARYhBGHl7m9JQjH4GqLG7qEv73WSzOHqBQJjI/hOBQkdHGo0AAoJEKEv73WSzOHqtFoA
njpM4gQIDjEVcE6dg7bnbxCOKnLRAJ0TnFH9HDp2/Azn0a38BpzMYr1JfM7BTQRH6MGaEAgA
xWn2jga6API5DqQ2+WjiUt9PIdL/g7aOESXsZAzDIsSzI4teO+G9rb+Am1TitTNZe4S0itnK
wBaR4uUEMWwe75mqKqmlsz9lc8YDLa+WU6obZuvYtpRZ2DHVm1lAqulGM+LTr+H5wFpEliLt
MqtS/cfUa/BJWhFXQHmUNFvpXd518lazfPgU6N4Yin8FIlSmsStrJR73KXtzzt8SJxcJBSFD
yrj0nfkehWUbZU3F1EV4fK94scni+5UK/5xNvtyfYtVZTcOE/1NIHWSOU1cloIgaUI9F4xvv
FJmmvfxlwvDtHDMhwUGGAXS7E82QtUfpJHsqXuq2OV7V8SwKzyIZOwADBQgAn4GC4TKWckZF
H8m4j44UUKfC5nAysiDnKxa5fqwg+p1duO19YQ8oUBwAAbl77/Cigwa3tTnD1ydi5JZ19T/P
s9lG4bPIloGRP/+G2W9tp3vm29fyHIXEU3N4gAzk7aGFbSenxKbey4K0S6yqTipbXZ1CWTpY
wM4SN1mCaehC7vjvPCN2AnNGjVLm+KM02x+qJLzjw4b5uXDoynjTx8Pb74aNSiIPM42Gpurq
MLj28GgMbIXi+3m/Je847Z4bilnSkN9Pm5cAPDtPQy0FXz4JgD9Sy/R2KVWbtpW7U7SIiMAI
6MItN6kBnOIYT65ZlbMdNHMK78B7Yract0+aZQrlq8JmBBgRAgAmAhsMFiEEYeXub0lCMfga
osbuoS/vdZLM4eoFAmMj+OgFCR0cas4ACgkQoS/vdZLM4eq8ZACfRKujULdkA5ktils1ovkS
zv+oI44AnjASx0BH5uYuCSOkb6yncTZndCMH
In-Reply-To: <udcaas$2v8io$1@dont-email.me>
Content-Language: en-US
 by: Lu Wei - Wed, 13 Sep 2023 06:10 UTC

On 2023-9-7 18:57, R.Wieser wrote:
> Lu Wei,
>
>> JSrcipt or VBScript is also fine, yet it seems all lines will be
>> processed,
>> which would be slow. Is there an efficient way to remove the first line
>> only?
>
> Using VBScript you could read (and discard) the first line(s) using
> ".readline", which you can than follow-up with a ".readall".
>

Thank you. Now it works after I had some struggle with weird results of
UTF format inconsistency.

--
Regards,
Lu Wei
IM: xmpp:luweitest@riotcat.org
PGP: 0xA12FEF7592CCE1EA

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor