HOLD FILE WIDTH

[PeterG5]

Hi,

What is the maximum width for a Lotus hold file and can this setting be changed?

Thanks.

 

[jimster06]

Here is what I found at IB's site:
HOLD/SAVE FORMAT LOTUS files on MF FOCUS releases 68 and earlier are limited to a 240 byte record. With release 7.0 and higher, the LRECL was increased to 512 bytes. One option is to use ON TABLE HOLD FORMAT EXCEL or HOLD FORMAT EXL2K if the ultimate desire is to import into an EXCEL compatible spreadsheet. If it must be FORMAT LOTUS, we can manually generate a comma-delimited file that can be imported to LOTUS. In a comma-delimited file, alphanumeric data is enclosed in double quotes and the data fields are separated by a comma. By using DEFINE to generate a field that contains a comma and another that contains a double quote, we can manually create a comma-delimited file that can be any length. The following is an example of this technique using the CAR file:

DEFINE FILE CAR
COMMA/A1 WITH COUNTRY=',';
QUOTE/A1 WITH COUNTRY='"';
END
TABLE FILE CAR
PRINT QUOTE COUNTRY QUOTE COMMA QUOTE CAR QUOTE COMMA
RETAIL_COST COMMA DEALER_COST
ON TABLE SAVE AS SAVCAR
END
Does it address your situation???

 

[craigiep]

Are you on a platform where you can use FORMAT COM or FORMAT COMT ?

These create comma delimited files without the restrictions associated with FORMAT LOTUS.

 

[PeterG5]

Hi Jimster06,

Thanks for this tip; It could be used if I cannot set the width appropriately. I have used MF Focus and been able to output up to 512 characters. The WebFocus limit seems to be between 300 and 400.

Hi Craigiep,
Unfortunately, neither COM nor COMT seem to be supported on my platform. Thanks anyway.

Peter.