Thank you so much Razzak and the Dream Team. You just officially emptied my sock drawer.
Have a safe, healthy and most excellent day! Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: "A. Razzak Memon" <[email protected]> To: [email protected] Date: 11/20/2020 12:00 AM Subject: [EXT] [RBASE-L] - Tip of the Day: Wrap Long Text Values in Spreadsheet/Workbook Exports Sent by: [email protected] Friday, November 20, 2020 Tip of the Day: Wrap Long Text Values in Spreadsheet/Workbook Exports Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) Build.........: 10.5.3.11119 or higher Sections......: File Gateway Keywords......: Export, GATEWAY, XLS, XLSW, Wrap Text, Spreadsheet Did you know that long text values may now be set to be "wrapped" within MS Excel Spreadsheet/Workbook output? With the GATEWAY EXPORT command syntax, the added WRAP_TEXT parameter for the XLS and XLSW export formats specifies to wrap long text values within the output. -- Example GATEWAY EXPORT XLS D:\DataStore\Contacts.XLS + SELECT * FROM Contacts + OPTION BLANK_IF_ZERO ON + |COL_NAMES ON + |MESSAGES OFF + |WRAP_TEXT ON With the File Gateway utility, the "Wrap Text" option for the MS Excel Spreadsheet/Workbook export formats is available. See attached image: Export_WrapText.jpg The Export Wizard also includes the Wrap Text option, where wrapping long text values within the Excel output may be included with .RGW specification files. See attached image: Export_Origin_WrapText.jpg Very Best R:egards, Razzak. https://www.rbase.com http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0M8ftl-1kJEsF2Khf-00wFqz%40mrelay.perfora.net . [attachment "Export_WrapText.jpg" deleted by Mike Ramsour/AKSTEEL] [attachment "Export_Origin_WrapText.jpg" deleted by Mike Ramsour/AKSTEEL] Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/OF8ECC6CB8.1AD8A435-ON85258626.00458508-85258626.0046AAF3%40aksteel.com.
