[U2] Formatting Data Update
Thanks to all your help I was able to finally get it working. However, it did mean that I had to compile as a BASICTYPE U and not as a BASICTYPE P. I did this by writing a little paragraph that does the following: PA BASICTYPE U BASIC BP EPCS9010.4 CATALOG BP EPCS9010.4 DIRECT FORCE BASICTYPE P I have to do this in every account I move this program to because our software (Avanti) runs as BASICTYPE P. My question: Is there something I can put in the source code of my program that tells it to compile as a BASICTYPE U so that when I do: OS.ED BP EPCS9010.4 FIBCDF It compiles as BASICTYPE U? I'm concerned that when I need to recompile all the BP entries in mass using a select list this program will compile back to the default BASICTYPE P and it stops working. Thanks. Al --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data Update
Hi Al, Certainly, you can use the $BASICTYPE compiler directive to assert a BASICTYPE U within your compilation, it's documented at http://publibfi.boulder.ibm.com/epubs/pdf/9163.pdf... Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Friday, August 26, 2005 3:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Formatting Data Update Thanks to all your help I was able to finally get it working. However, it did mean that I had to compile as a BASICTYPE U and not as a BASICTYPE P. I did this by writing a little paragraph that does the following: PA BASICTYPE U BASIC BP EPCS9010.4 CATALOG BP EPCS9010.4 DIRECT FORCE BASICTYPE P I have to do this in every account I move this program to because our software (Avanti) runs as BASICTYPE P. My question: Is there something I can put in the source code of my program that tells it to compile as a BASICTYPE U so that when I do: OS.ED BP EPCS9010.4 FIBCDF It compiles as BASICTYPE U? I'm concerned that when I need to recompile all the BP entries in mass using a select list this program will compile back to the default BASICTYPE P and it stops working. Thanks. Al --- 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] Formatting Data Update
$BASICTYPE U at the top of the program should do the trick (HELP $BASICTYPE) Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Friday, August 26, 2005 3:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Formatting Data Update Thanks to all your help I was able to finally get it working. However, it did mean that I had to compile as a BASICTYPE U and not as a BASICTYPE P. I did this by writing a little paragraph that does the following: PA BASICTYPE U BASIC BP EPCS9010.4 CATALOG BP EPCS9010.4 DIRECT FORCE BASICTYPE P I have to do this in every account I move this program to because our software (Avanti) runs as BASICTYPE P. My question: Is there something I can put in the source code of my program that tells it to compile as a BASICTYPE U so that when I do: OS.ED BP EPCS9010.4 FIBCDF It compiles as BASICTYPE U? I'm concerned that when I need to recompile all the BP entries in mass using a select list this program will compile back to the default BASICTYPE P and it stops working. Thanks. Al --- 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] Formatting Data
Al, This works on universe: TEXT = CHANGE(TEXT, @SM:@SM, @VM:@VM) TEXT = CONVERT(@SM, , TEXT) TEXT = FMTS(TEXT, 50T) TEXT = CONVERT(@VM:@TM, @SM:@SM, TEXT) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
I had a similar problem a few months ago while converting from D3 to UD. UniBasic lacks the FOLD() function that D3 had. Lots of folks here offered great advice and I put together this subroutine from the best pieces form all of it. SUBROUTINE FOLDER(DATA.IN,COL.WIDTH,DELIM,DATA.OUT) *** break monolithic string on word space nearest desired *** column width and return data with delimiters DATA.IN = TRIM(DATA.IN) DATA.OUT = TEMP = LINE.CNT = 0 NUMWORD = DCOUNT(DATA.IN, ) FOR X = 1 TO NUMWORD WORD = FIELD(DATA.IN, ,X) WORDLEN = LEN(WORD) TEMPLEN = LEN(TEMP) IF (TEMPLEN + WORDLEN + 1) COL.WIDTH THEN LINE.CNT += 1 IF LINE.CNT 1 THEN DATA.OUT := DELIM DATA.OUT := TEMP TEMP = END IF TEMP # THEN TEMP := TEMP := WORD NEXT X IF TEMP # THEN LINE.CNT += 1 IF LINE.CNT 1 THEN DATA.OUT := DELIM DATA.OUT := TEMP TEMP = END RETURN Perhaps you could use this by taking your data, stripping all @TM, @SVM, @VM to leave a big chunk of just text and feed it through the subroutine. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Vegetables are what food eats. === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Al DeWitt Sent: Wednesday, August 24, 2005 6:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Formatting Data Part of the problem, I believe is that our ECLTYPE and BASICTYPE are P, Pick. Commands are not working the way I expect because I'm approaching this from a UV mindset (I can't help it, it's what I know). I'm being told that NEWLINE = FMT(TRIM(LINE),'55T') would turn 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,' into 'Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] 'on this continent a new nation,' However, the command: NEWLINE = FMT(TRIM(LINE),'55T') does not work. It just gives me the letter T. The command: NEWLINE = FMT(TRIM(LINE),'T#55') sort of works. If LINE = 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,', the FMT command produces 'TFourscore and seven years ago our fathers brought forth' but loses 'on this continent a new nation,' I don't think UniData's Pick flavor is up to the task, but I'm open to any ideas. --Al -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, August 24, 2005 6:02 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Formatting Data Consider Socratic Programming... that is, break the problem down into elemental pieces. Please consider broadcasting a few lines of the bug-laden code. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 8/24/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
The use of the callable routine !FOLD was suggested a day or two ago. It is very affective in that it naturally breaks on space. If you use the remove to display the folded text it save a great deal of coding. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Formatting Data
Yesterday I posed the question about reformatting a multi-value down to l or more lines of no more than 55 characters each. I received some great suggestions, but I can't get them to work. The FMT command doesn't seem to want to return anthing more than the first 55 characters. Below I have mocked up comments coming in and how I need them to reformat. I have tried converting all the sub-value marks to spaces and then using FMT. I have tried FMT without converting the sub-value marks. Nothing seems to work. Any help would be appreciated. Thanks. Input Data Fourscore and seven years ago our fathers brought forth on this continent a new nation,@SM conceived in liberty, and dedicated to the proposition that all men are created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing whether that nation or any nation [EMAIL PROTECTED] conceived and so dedicated can long endure. We are met on a great battlefield of [EMAIL PROTECTED] war. We have come to dedicate a portion of that field as a final resting place [EMAIL PROTECTED] those who here gave their lives that that nation might live. It is altogether [EMAIL PROTECTED] and proper that we should do this. Reformatted to no more than 55 characters per line. Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] on this continent a new nation, conceived in liberty,@SM and dedicated to the proposition that all men [EMAIL PROTECTED] created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing [EMAIL PROTECTED] that nation or any nation so conceived and so [EMAIL PROTECTED] can long endure. We are met on a great battlefield [EMAIL PROTECTED] that war. We have come to dedicate a portion of [EMAIL PROTECTED] field as a final resting place forthose who here [EMAIL PROTECTED] their lives that that nation might live. It [EMAIL PROTECTED] altogether fitting and proper that we should do this. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
You're going to have a problem with the 'blank' line. If you convert the @SMs to spaces, then it will wrap the rest of the lines up and won't preserve the line break. You're probably going to need to do some coding something like this: * Assuming TEXT contains the current text delimited by @SM NEWTEXT = NEWLINE = LOOP REMOVE LINE FROM TEXT SETTING MORE.TEXT IF TRIM(LINE) = THEN NEWLINE = FMT(TRIM(NEWLINE),'55T') CONVERT @TM TO @SM IN NEWLINE NEWTEXT1,1,-1 = NEWLINE NEWLINE = IF MORE.TEXT THEN NEWTEXT := @SM END ELSE NEWLINE := TRIM(LINE): END WHILE MORE.TEXT REPEAT HTH Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Wednesday, August 24, 2005 2:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Formatting Data Yesterday I posed the question about reformatting a multi-value down to l or more lines of no more than 55 characters each. I received some great suggestions, but I can't get them to work. The FMT command doesn't seem to want to return anthing more than the first 55 characters. Below I have mocked up comments coming in and how I need them to reformat. I have tried converting all the sub-value marks to spaces and then using FMT. I have tried FMT without converting the sub-value marks. Nothing seems to work. Any help would be appreciated. Thanks. Input Data Fourscore and seven years ago our fathers brought forth on this continent a new nation,@SM conceived in liberty, and dedicated to the proposition that all men are created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing whether that nation or any nation [EMAIL PROTECTED] conceived and so dedicated can long endure. We are met on a great battlefield of [EMAIL PROTECTED] war. We have come to dedicate a portion of that field as a final resting place [EMAIL PROTECTED] those who here gave their lives that that nation might live. It is altogether [EMAIL PROTECTED] and proper that we should do this. Reformatted to no more than 55 characters per line. Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] on this continent a new nation, conceived in liberty,@SM and dedicated to the proposition that all men [EMAIL PROTECTED] created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing [EMAIL PROTECTED] that nation or any nation so conceived and so [EMAIL PROTECTED] can long endure. We are met on a great battlefield [EMAIL PROTECTED] that war. We have come to dedicate a portion of [EMAIL PROTECTED] field as a final resting place forthose who here [EMAIL PROTECTED] their lives that that nation might live. It [EMAIL PROTECTED] altogether fitting and proper that we should do this. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 8/24/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 8/24/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Formatting Data
Goo'day, I'll include asnippet of ours that works a treat in situations like this: * THIS.DESC = FMT(TRIM(THIS.DESC),27T) THIS.DESC = CHANGE(THIS.DESC,@TM,@VM) * X = DCOUNT(THIS.DESC,@VM) FOR I = 1 TO X PRINT ON 1 THIS.DESC1,1'L#27' NEXT I * where we have a long description that we want to break up over multiple lines, breaking the lines on spaces (word boundaries) at or up to the 27th character. At 16:44 24/08/05 -0500, you wrote: Yesterday I posed the question about reformatting a multi-value down to l or more lines of no more than 55 characters each. I received some great suggestions, but I can't get them to work. The FMT command doesn't seem to want to return anthing more than the first 55 characters. Below I have mocked up comments coming in and how I need them to reformat. I have tried converting all the sub-value marks to spaces and then using FMT. I have tried FMT without converting the sub-value marks. Nothing seems to work. Any help would be appreciated. snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 24/08/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 24/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
Consider Socratic Programming... that is, break the problem down into elemental pieces. Please consider broadcasting a few lines of the bug-laden code. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Al DeWitt Sent: Wednesday, August 24, 2005 5:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Formatting Data Yesterday I posed the question about reformatting a multi-value down to l or more lines of no more than 55 characters each. I received some great suggestions, but I can't get them to work. The FMT command doesn't seem to want to return anthing more than the first 55 characters. Below I have mocked up comments coming in and how I need them to reformat. I have tried converting all the sub-value marks to spaces and then using FMT. I have tried FMT without converting the sub-value marks. Nothing seems to work. Any help would be appreciated. Thanks. Input Data Fourscore and seven years ago our fathers brought forth on this continent a new nation,@SM conceived in liberty, and dedicated to the proposition that all men are created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing whether that nation or any nation [EMAIL PROTECTED] conceived and so dedicated can long endure. We are met on a great battlefield of [EMAIL PROTECTED] war. We have come to dedicate a portion of that field as a final resting place [EMAIL PROTECTED] those who here gave their lives that that nation might live. It is altogether [EMAIL PROTECTED] and proper that we should do this. Reformatted to no more than 55 characters per line. Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] on this continent a new nation, conceived in liberty,@SM and dedicated to the proposition that all men [EMAIL PROTECTED] created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing [EMAIL PROTECTED] that nation or any nation so conceived and so [EMAIL PROTECTED] can long endure. We are met on a great battlefield [EMAIL PROTECTED] that war. We have come to dedicate a portion of [EMAIL PROTECTED] field as a final resting place forthose who here [EMAIL PROTECTED] their lives that that nation might live. It [EMAIL PROTECTED] altogether fitting and proper that we should do this. --- 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] Re: [U2} Formatting data...
Oops!Sorry 1,1 should be 1,I for the sharp-eyed among us... I'll include a snippet of ours that works a treat in situations like this: * THIS.DESC = FMT(TRIM(THIS.DESC),27T) THIS.DESC = CHANGE(THIS.DESC,@TM,@VM) * X = DCOUNT(THIS.DESC,@VM) FOR I = 1 TO X PRINT ON 1 THIS.DESC1,I'L#27' NEXT I * Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 24/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
Assuming you have your sample data in a single variable, you can try something like this: MYDATA = @RECORDX,Y MYDATA = CHANGE(MYDATA,@SVM:@SVM,@VM) MYDATA = CHANGE(MYDATA,@SVM, ) MYDATA = CHANGE(MYDATA,. ,. ) MYDATA = CHANGE(MYDATA,. ,. ) VM.CNT = DCOUNT(MYDATA,@VM) NEW.DATA = '' VM = '' FOR A = 1 TO VM.CNT PARA55 = FOLD(MYDATA1,A,55) CONVERT @FM TO @SVM IN PARA55 NEW.DATA := VM:PARA55 VM = @VM NEXT A NEW.DATA = CHANGE(@VM,@SVM:@SVM,NEW.DATA) ;* CHANGE THE PARAGRAPHS TO DELIMIT WITH @VM. ;* MAKE EACH PARAGRAPH ONE LONG STRING. ;* MAKE ALL SENTENCE ENDINGS THE SAME WITH ONE SPACE. COULD USE TRIM(). ;* NOW CHANGE ALL DOT-SPACE TO DOT-SPACE-SPACE. YOU MAY NEED TO ACCOUNT FOR ADDITIONAL SENTENCE ENDING PUNCTUATION CHARACTERS. ;* GET A COUNT OF PARAGRAPHS. ;* INIT OUTPUT VAR AND A DELIMITER VAR TO NULL ;* LOOP FOR EACH 'PARAGRAPH' ;* FOLD PARAGRAPH TO A 55 CHAR MAX LENGTH ;* CHANGE @FM TO @SVM INSIDE PARAGRAPH ;* ADD TO OUTPUT THE CURRENT VALUE OF DELIMTER AND FORMATTED PARAGRAPH ;* SET DELIMITER TO @VM VALUE ;* AT END OF LOOPING CHANGE @VM TO DOUBLE @SVM FOR SPACING BETWEEN PARAGRAPHS. NEW.DATA should now have the formatting you are looking for. Bob Woodward Programmer/Analyst Harbor Wholesale Grocery [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Wednesday, August 24, 2005 2:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Formatting Data Yesterday I posed the question about reformatting a multi-value down to l or more lines of no more than 55 characters each. I received some great suggestions, but I can't get them to work. The FMT command doesn't seem to want to return anthing more than the first 55 characters. Below I have mocked up comments coming in and how I need them to reformat. I have tried converting all the sub-value marks to spaces and then using FMT. I have tried FMT without converting the sub-value marks. Nothing seems to work. Any help would be appreciated. Thanks. Input Data Fourscore and seven years ago our fathers brought forth on this continent a new nation,@SM conceived in liberty, and dedicated to the proposition that all men are created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing whether that nation or any nation [EMAIL PROTECTED] conceived and so dedicated can long endure. We are met on a great battlefield of [EMAIL PROTECTED] war. We have come to dedicate a portion of that field as a final resting place [EMAIL PROTECTED] those who here gave their lives that that nation might live. It is altogether [EMAIL PROTECTED] and proper that we should do this. Reformatted to no more than 55 characters per line. Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] on this continent a new nation, conceived in liberty,@SM and dedicated to the proposition that all men [EMAIL PROTECTED] created [EMAIL PROTECTED] @SM Now we are engaged in a great civil war, testing [EMAIL PROTECTED] that nation or any nation so conceived and so [EMAIL PROTECTED] can long endure. We are met on a great battlefield [EMAIL PROTECTED] that war. We have come to dedicate a portion of [EMAIL PROTECTED] field as a final resting place forthose who here [EMAIL PROTECTED] their lives that that nation might live. It [EMAIL PROTECTED] altogether fitting and proper that we should do this. --- 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] Formatting Data
Part of the problem, I believe is that our ECLTYPE and BASICTYPE are P, Pick. Commands are not working the way I expect because I'm approaching this from a UV mindset (I can't help it, it's what I know). I'm being told that NEWLINE = FMT(TRIM(LINE),'55T') would turn 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,' into 'Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] 'on this continent a new nation,' However, the command: NEWLINE = FMT(TRIM(LINE),'55T') does not work. It just gives me the letter T. The command: NEWLINE = FMT(TRIM(LINE),'T#55') sort of works. If LINE = 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,', the FMT command produces 'TFourscore and seven years ago our fathers brought forth' but loses 'on this continent a new nation,' I don't think UniData's Pick flavor is up to the task, but I'm open to any ideas. --Al -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, August 24, 2005 6:02 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Formatting Data Consider Socratic Programming... that is, break the problem down into elemental pieces. Please consider broadcasting a few lines of the bug-laden code. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
Can you use $BASICTYPE U at the beginning of this routine? You're right, BASICTYPE P doesn't seem to cut it, but changing BASICTYPE to U makes it work peachy. -K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Wednesday, August 24, 2005 5:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Formatting Data Part of the problem, I believe is that our ECLTYPE and BASICTYPE are P, Pick. Commands are not working the way I expect because I'm approaching this from a UV mindset (I can't help it, it's what I know). I'm being told that NEWLINE = FMT(TRIM(LINE),'55T') would turn 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,' into 'Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] 'on this continent a new nation,' However, the command: NEWLINE = FMT(TRIM(LINE),'55T') does not work. It just gives me the letter T. The command: NEWLINE = FMT(TRIM(LINE),'T#55') sort of works. If LINE = 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,', the FMT command produces 'TFourscore and seven years ago our fathers brought forth' but loses 'on this continent a new nation,' I don't think UniData's Pick flavor is up to the task, but I'm open to any ideas. --Al -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, August 24, 2005 6:02 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Formatting Data Consider Socratic Programming... that is, break the problem down into elemental pieces. Please consider broadcasting a few lines of the bug-laden code. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
Hmmm... Good question. I only use BASICTYPE U, so I'm not sure. What does the following line do? NEWLINE = TRIM(LINE) 'T#55' Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Wednesday, August 24, 2005 4:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Formatting Data Part of the problem, I believe is that our ECLTYPE and BASICTYPE are P, Pick. Commands are not working the way I expect because I'm approaching this from a UV mindset (I can't help it, it's what I know). I'm being told that NEWLINE = FMT(TRIM(LINE),'55T') would turn 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,' into 'Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] 'on this continent a new nation,' However, the command: NEWLINE = FMT(TRIM(LINE),'55T') does not work. It just gives me the letter T. The command: NEWLINE = FMT(TRIM(LINE),'T#55') sort of works. If LINE = 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,', the FMT command produces 'TFourscore and seven years ago our fathers brought forth' but loses 'on this continent a new nation,' I don't think UniData's Pick flavor is up to the task, but I'm open to any ideas. --Al -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, August 24, 2005 6:02 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Formatting Data Consider Socratic Programming... that is, break the problem down into elemental pieces. Please consider broadcasting a few lines of the bug-laden code. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 8/24/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 8/24/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/