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...
... 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...
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...
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...
... 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...
Modern Military Julian Calendar (ZULU or Coordinated Universal Time (old GMT)) The Military Dating system is a modernized version of the Julian system with...
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: ...
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...
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...
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...
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...
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...
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...
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...
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. ...
Hi Dave, ... Change from ^?[Brackets] to ^?{Braces} That'll fix you right up. ^!SetWizardLabel "Attributes for the CFPROCPARAM tag" ^!InsertWizardHtml...
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...
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...
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...
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...
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 :...
ntb-clips@yahoogroups...
Sep 3, 2004 6:18 pm
12443
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...
... 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...
(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...
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...
Ben B
benb_i26up@...
Sep 4, 2004 10:25 pm
12447
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...
Ben B
benb_i26up@...
Sep 4, 2004 10:31 pm
12448
... [ . . ] ... 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...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
