RE: [U2] CSVs' (Different Question)
Thank you, I have been trying to find an answer to this problem for days myself, as we are about to do some major data extraction to excel. What a valuable list. Regards, J Garratt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno Sent: Tuesday, 17 January 2006 11:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] CSVs' (Different Question) Mark Johnson wrote: Where do I quote these? A,B,C,12345,000123 The info I posted about single quotes in my last post wasn't helpful in this context. Let me try this way: A,B,12,34,Hi World Excel doesn't need quotes unless you're doing something special, which explains why the A and B values are exactly the same. The 12,34 is special because it embeds a comma. Quotes are also needed when spaces are embedded, although sometimes leading or trailing spaces may also get removed. The \Hi World\ example is interpreted as alpha in the first place, so any quotes embedded in that value are considered part o the text string. 000123,=000123 The number with leading zeros is recognized it as numeric, so 000123 becomes 123 in the sheet. The =000123 value tells Excel that this is a formula (preceded by equal sign). The formula returns a string which is not reinterpreted as above. 12/10/05 This date, even in quotes, is interpreted because there is not a forumula telling Excel to do otherwise, and will get converted to display 12/10/2005. The value itself will be converted to an internal numeric much like the internal Pick date. =12/10/05 , =12/10/05 These two values show equivalent formulas for expressing the date as a string, not a date to be converted as above. This just goes to show that sometime you need to escape a quote by preceding it with another quote. There are no formal standards which govern how CSV files work. There are generally accepted conventions, but of course these aren't all followed by Excel. Using the guidelines above you can experiment with certain kinds of data to see how it behaves. And none of this is related to U2. There are thousands of websites with this sort of information available. T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
Over years experience using pick, uv, sb, sb+ I believe that this is the best and most controlled way. Jim Garratt CTI Logistics Ltd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, 5 January 2006 1:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] DCOUNT I'm finding that I'm doing a lot of programming for the processing through multi-valued attributes. I'm wondering if the method I'm using is the best way to determine the last element. LAST=DCOUNT(REC15,@VM) FOR I=1 TO LAST (process something) NEXT I There was a REMOVE thread a few months ago and I use that when I expect that the number of elements could test the patience of the EXTRACTs. REMOVE doesn't give you the MV counter for the associated fields by itself. You have to manage separately and hope to keep in sync. That's more code. I know that in VB certain object array variables (a list box for example) has a property for the number of elements. Is there anything in MV that I'm not aware of for determining the last multi-value that's easier to type than the DCOUNT expression. I'm looking at reducing my keystrokes. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Old IBM RT
I worked for a company which had at lease 10 machines working. I would suggest that you contact Carl Keogh at Austral Bricks in Perth Western Australia who aquired the old Bristile company. When I left 8 years ago they had just decomisioned two of the IBM RT's running Pick OA 2.02 and System Builder. Unfortunately your request came too late by 6 months. I had a fully operating model I put together from parts that I send to the tip including the 40kg of manuals and operating system disks that went with it. It was not running Pick but Unix. If you are going to load pick on an RT you will need the access code, else you will not be able to load the mini disks, unless the operating system is still on the hard drive. The system could take a configuration of 1 x 310mb Hard Disk to 3 x 310 MB Hard Disks. The mini disks are stored on any of the drives installed. You will also need the the Virtual Disks 1 2 if you want to run Pick OA. Regards Jim Garratt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver Sent: Saturday, 24 September 2005 11:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Fwd: U2 to be posted Posted for another U2 user. Begin forwarded message: From: Henry Keultjes [EMAIL PROTECTED] Date: September 24, 2005 5:39:49 AM PDT To: Clifton Oliver [EMAIL PROTECTED] Subject: U2 to be posted Wanted: Pick Open Architecture for IBM RT Pick Open Architecture on the IBM RT was a historic turning point away from native Pick and also the first Pick to run on a RISC platform. We are trying to preserve some of that history by restoring at least one RT model to an operating condition. Please contact Henry Keultjes at 419-571-9127 or hbkeultjes(at)earthlink (dot)net if you are willing to contribute any Pick related items or if you know of someone who could. Tax deductable contributions can be made to BrainTree, a 501(C)(3) non-profit organization http://www.braintreepartners.org/ braintreeitalliance.htm Database Scientifics Project c/o BrainTree 201 East Fifth Street Mansfield OH 44902 . Clifton Oliver wrote: Sure. Write it as you want it posted, and I'll forward it verbatim to the list. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/