Re: How to iterate through a (semicolon;separated;list)

From: Marty List (Bill.Gates_at_sun.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 15:50:28 -0600

"Csaba Gabor" <news@CsabaGabor.com> wrote in message
news:eN6SYh2PEHA.2520@TK2MSFTNGP11.phx.gbl...
> Aaarggghh, sorry about the messed up title of my earlier post.
> In the meantime, I have an answer, but it is not wholly satisfying
> so I am modifying my question to ask whether there is any
> command line 'replace string'?
>
> The original question was to find out how I can iterate through
> a list of semicolon separated values (where the list was coming
> from a rows of a database). Here is my batch file solution:
>
> FOR /F "tokens=1,* delims=:" %%G ^
> IN ('c:\sqlite.exe c:\Mydb^
> "SELECT Id||':'||myList FROM myTable;"')^
> DO @FOR %%K IN (%%H) DO @ECHO %%G-^>%%K
>
>
> But I am getting lucky with that inner FOR loop. Really
> I would like to have a (regular expression preferred)
> 'replace string' in my arsenal.
>
> Thanks for any tips,
> Csaba Gabor
>

This doesn't support regular expressions, but the only thing built-in to the
OS that I can think of is %name:a=b% syntax. This is from SET /?:

===================================================

    %PATH:str1=str2%

would expand the PATH environment variable, substituting each occurrence
of "str1" in the expanded result with "str2". "str2" can be the empty
string to effectively delete all occurrences of "str1" from the expanded
output. "str1" can begin with an asterisk, in which case it will match
everything from the begining of the expanded output to the first
occurrence of the remaining portion of str1.

===================================================

You don't need to use the SET command, you can do it on the fly:

Echo %WINDIR:C:=D:%

Relevant Pages

  • Re: char * ptr = "amit", in which area of memory it is stored (heap,stack,code,global)
    ... >> It will crash, I feel str1 will be stored in code section. ... > Your str1 is assigned to string "amit" when you do strcatyour ... The object 'str1' in the OP's sample code is pointing to a string ...
    (comp.lang.c)
  • Re: newbie trouble making array of instances
    ... A new string instance was created by the Removemethod, and the reference to this new instance was assigned to str1. ... Notice there is no verbiage describing special-casing around a string that happens to come back as empty; it says it *always* returns a new string. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: TransferText Export Problem
    ... Sub ExportDataToCSV() ... Dim DB As DAO.Database, RS As DAO.Recordset, fld As DAO.Field, str1 As ... String ... There is also a Write command ...
    (comp.databases.ms-access)
  • Re: [PATCH] update checkpatch.pl to version 0.05
    ... I want the string to be \{... ... +# Check for switch and associated case and default ... semantics of '' and "" are well known, to change to qrI would have to ... be expressed as qras it would expand variables but treat \ as if we ...
    (Linux-Kernel)
  • Re: Windows file paths, again
    ... normalfilepath =ormalize_path ... # expand all the normally formed environ variables ... Now this may have nothing to do with the data you get from ConfigParser or QueryValueEx, but it sure makes testing confusing. ... It seems like you're trying to somehow build a version of the string that would pass muster as a literal string. ...
    (comp.lang.python)
Quantcast