Thanks very much Don! ... reply ... operations. They ... Programming. "T" ... for "silent"...
12420
Bauke P. de Vries
bpdevries
Sep 1, 2004 11:35 am
Hello, I'm looking for a clip that makes it possible to do a 'find & replace' in one or more columns within a csv-file. I've looked in several libraries but I...
12421
Don - htmlfixit.com
dpasseng
Sep 1, 2004 1:20 pm
... For all things CSV, Jody's noteblock library is the first place to turn. He has a replace in block clip there: ; Last updated on 07-27-2001 ^!IfTrue...
12422
Chris Valentine
hockeyshooter8
Sep 1, 2004 1:54 pm
... Yes - that did the trick. Thanks. Chris....
12423
Patricia Tidmarsh
patriciat.geo
Sep 1, 2004 2:48 pm
I have data bases with individuals whose dates of birth and death in various forms -- 15 May 1900 May 15, 1900 May 1900 1900 I would like to sort the data by...
12424
Jeff Scism
scismgenie
Sep 1, 2004 3:21 pm
In sorting by Date of Birth I recommend the following format: YYYY-MM-DD This will order them in descending order on sort. I was provided the below clip for...
12425
Don - htmlfixit.com
dpasseng
Sep 1, 2004 3:22 pm
... what format do you have it in now? is it csv formatted? I assume date isn't the only field why don't you attach one or two sample lines from the file even...
12426
Jeff Scism
scismgenie
Sep 1, 2004 3:53 pm
Modern Military Julian Calendar (ZULU or Coordinated Universal Time (old GMT)) The Military Dating system is a modernized version of the Julian system with...
12427
Bauke P. de Vries
bpdevries
Sep 1, 2004 4:29 pm
Hello, I'm sorry, but the 'Replace in block' clip in the NoteBlock lib is not what I need. I get (from a MySQL database) csv-files that look like this: ...
12428
Jody
notetabber
Sep 1, 2004 4:32 pm
Hi Patricia, ... That's a tall order! :) I don't know if I will have the time for this one - it'd be pretty difficult or at least time consuming to do, but I...
12429
Jody
notetabber
Sep 1, 2004 4:32 pm
Hi Bauke, ... The Replace in Block... had some problems <g>, so I reworked it. You can only do one column at a time. I still need to do more work, because as...
12430
Jody
notetabber
Sep 1, 2004 7:22 pm
Hi Bauke, ... The quotes there are part of the delimiter. Is that what you want to replace or is there actually other text where "1" is and it is within that...
12431
Jody
notetabber
Sep 2, 2004 12:24 am
Hi Bauke, ... I have NoteBlock:Replace in Block fixed now so that it will make replacements within a field/column, at least with common delimiters. It's really...
12432
Alec Burgess
alecb3ca
Sep 2, 2004 3:38 am
Bauke & Patricia (with Jody's forbearance I hope) Both these tasks can be done with Jody's clip stuff and/or purpose-built clips I think, but if what you...
12433
prlproductmanager
prlproductma...
Sep 2, 2004 12:51 pm
I'm seeing the postings fly by with a very tricky date question, can we start with a simpler question? Given a string which can be set as a variable...
12434
Dave Evartt
evartt
Sep 2, 2004 1:42 pm
Anybody know why ^!SetWizardLabel "xyz" does not work? I have seen it in a thousnad clips but in my clips, they never seem to work in mine Here is an example...
12435
Jody
notetabber
Sep 2, 2004 2:13 pm
Hi Rayellen, ... That can be done. Are those the only 4 date formats you have? What are all the different spelling you have for each month such as April, Apr. ...
12436
Jody
notetabber
Sep 2, 2004 2:22 pm
Hi Dave, ... Change from ^?[Brackets] to ^?{Braces} That'll fix you right up. ^!SetWizardLabel "Attributes for the CFPROCPARAM tag" ^!InsertWizardHtml...
12437
Don Daugherty
dondaugherty...
Sep 2, 2004 3:53 pm
... again if I find one. You're welcome. I do have an example to look at. Let me know if you need it posted....
12438
Dave Evartt
evartt
Sep 2, 2004 7:30 pm
Thanks, that did the trick. Is this documented anywhere? It seesm that whilre there are numerous examples of clips, I've found nothing like "the programmer's...
12439
Jody
notetabber
Sep 2, 2004 8:19 pm
Hi Dave, ... haha! I've had a pay version in mind and working on/off on for a few years. <vbg> I'd be more than happy to put it on a CD with your registered...
12440
prlproductmanager
prlproductma...
Sep 3, 2004 1:51 pm
Yes. Lets assume that these are the 4 date formats I will have. I'm sure I can modify on the fly if I run across an variation on this, or work something into...
12441
Jody
notetabber
Sep 3, 2004 4:50 pm
Hi Rayellen, ... March 01, 2004 MAR 1 2004 03/01/2004 03/01/04 ... It would be a lot easier to write if I/we saw some of the file they are in. Is it a table in...
12442
ntb-clips@yahoogroups...
Sep 3, 2004 6:18 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the ntb-clips group. File :...
12443
Alan
acummingsus
Sep 3, 2004 10:48 pm
Hi, I gather that it is not the current date and/or time that you are or that you need to work with but instead, you obtain a date from a doc and then that...
12444
Hugo Paulissen
hugo_paulissen
Sep 3, 2004 10:58 pm
... Jody, Rayellen, This might not be the smartest of clips but it does manipulate the dates in the given formats to the desired output. The regex is not...
12445
epement
Sep 4, 2004 5:22 pm
(This post is a slightly updated version of a message I inadvertently posted in the NoteTab Basic List.) My immediate need ("immediate" as in urgent) is for a...
12446
Ben B
benb_i26up@...
Sep 4, 2004 10:25 pm
On Saturday, Sep 04, 2004 epement wrote regarding "I need a paragraph reformat command"; ... I'm not familiar with WordStar, VDE, or Emacs but here is a...
12447
Ben B
benb_i26up@...
Sep 4, 2004 10:31 pm
On Saturday, Sep 04, 2004 Ben B wrote regarding "I need a paragraph reformat command"; ... That should be; 1) That the "pre-set left and right margins" are...
12448
Alan C.
acummingsus
Sep 5, 2004 9:23 am
... [ . . ] ... The enclosed clip: 1. puts 12 months into array (alphalist) 2. replace each space with a / 2b. replace , with nothing 2c. puts the date string...
