conversions

Former Member — Tue, 04 Mar 2008 14:04:01 GMT

Hi All,

what is the difference between SAP_CONVERT_TO_CSV_FORMAT and SAP_CONVERT_TO_TEX_FORMAT.

Re: conversions

Former Member — Tue, 04 Mar 2008 14:34:27 GMT

The comma-separated values (or CSV; also known as a comma-separated list or comma-separated variables) file format is a file type that stores tabular data. The format dates back to the early days of business computing. For this reason, CSV files are common on all computer platforms.

CSV is one implementation of a delimited text file, which uses a comma to separate values (where many implementations of CSV import/export tools allow an alternate separator to be used; as is shown in the MS Access screen shot, below). However CSV differs from other delimiter separated file formats in using a " (double quote) character around fields that contain reserved characters (such as commas or newlines). Most other delimiter formats either use an escape character such as a backslash, or have no support for reserved characters.

In computer science terms, this type of format is called a "flat file" because only one table can be stored in a CSV file. Most systems use a series of tables to store their information, which must be "flattened" into a single table, often with information repeated over several rows, to create a delimited text file.

CSV format as follows:

1997,Ford,E350,"ac, abs, moon",3000.00

1999,Chevy,"Venture ""Extended Edition""",,4900.00

1996,Jeep,Grand Cherokee,"MUST SELL!

air, moon roof, loaded",4799.00

This CSV example illustrates that:

fields that contain commas, double-quotes, or line-breaks must be quoted,

a quote within a field must be escaped with an additional quote immediately preceding the literal quote,

space before and after delimiter commas may be trimmed, and

a line break within an element must be preserved.

The Rich Text Format (often abbreviated to RTF) is a proprietary document file format developed by Microsoft in 1987 for cross-platform document interchange. Most word processors are able to read and write RTF documents.

Microsoft is known for arbitrarily modifying this format specification between different versions of Microsoft Word. As a popular joke says, "RTF is defined as whatever Microsoft Word exports when one asks it to export to RTF".

It should not be confused with enriched text (mimetype "text/enriched" of RFC 1896) or its predecessor Rich Text (mimetype "text/richtext" of RFC 1341 and 1521) which are completely different specifications.

Contents [hide]

1 History

2 Sample RTF document

3 Character encoding

4 Human readability

5 Common implementations

6 See also

7 External links

[edit] History

This short section requires expansion.

Members of the Microsoft Word development team, Richard Brodie, Charles Simonyi, and David Luebbert developed the original RTF in the middle to late 1980s. The first RTF reader and writer shipped in 1987 as part of Microsoft Word 3.0 for Macintosh, which implemented the version 1.0 RTF specification.

All subsequent releases of Microsoft Word for the Macintosh and all versions of Microsoft Word for Windows have included built-in RTF readers and writers which translate from RTF to Word's .doc format and from .doc to RTF.

The standard is still owned by Microsoft to this date; as of January 2007 it is up to version 1.9.

Credit should be given to Donald Knuth for introducing the brace convention in his TeX typesetting program.[citation needed] Started in 1977, and first published in 1979, TeX used {\b } for bolding text, {\i } for italic, etc.

[edit] Sample RTF document

As an example, the following RTF code:

{\rtf1\ansi{\fonttbl\f0\fswiss Helvetica;}\f0\pard

This is some {\b bold} text.\par

}

would be rendered like this when read by an appropriate word processor:

This is some bold text.

A backslash (\) starts an RTF control code. The \par control code indicates the end of a paragraph, and \b switches to a bold typeface. Braces () define a group; the example uses a group to limit the scope of the \b control code. Everything else will be treated as clear text, or the text to be formatted. A valid RTF document is a group starting with the \rtf control code.

[edit] Character encoding

RTF is an 8-bit format. That would limit it to ASCII, but RTF can encode characters beyond ASCII by escape sequences. The character escapes are of two types: code page escapes and Unicode escapes. In a code page escape, two hexadecimal digits following an apostrophe are used for denoting a character taken from a Windows code page. For example, if control codes specifying Windows-1256 are present, the sequence \'c8 will encode the Arabic letter beh (ب).

If a Unicode escape is required, the control word \u is used, followed by a 16-bit signed decimal integer giving the Unicode codepoint number. For the benefit of programs without Unicode support, this must be followed by the nearest representation of this character in the specified code page. For example, \u1576? would give the Arabic letter beh, specifying that older programs which do not have Unicode support should render it as a question mark instead.

The control word \uc0 can be used to indicate that subsequent Unicode escape sequences within the current group do not specify a substitution character.

[edit] Human readability

Unlike most word processing formats, good RTF code can be made human-readable. That is to say that when an RTF file is opened in a text editor, the text is legible and the markup is not too distracting or counter-intuitive. The RTF files produced by most programs, such as MS Word, will contain such a large number of control codes for compatibility with older programs that most files will easily be an order of magnitude larger than the raw text and very difficult to read. Formats such as MS Word's .doc are, in contrast, binary formats with only a few scraps of legible text.

Nowadays, human-readable XML-based formats are becoming more common, but RTF's readability was a rare thing when it came out. Note that the XML-based OpenDocument and Office Open XML formats are often not immediately human-readable due to there being a bundle of several different files within a ZIP archive.

[edit] Common implementations

Most word processing software implementations support RTF format import and export, often making it a "common" format between otherwise incompatible word processing software.

The WordPad editor in Microsoft Windows creates RTF files by default. It once defaulted to the Microsoft Word 6.0 file format, but write support for Word documents was dropped in a security update.

The free and open-source word processors AbiWord, OpenOffice.org, and KWord can view and edit RTF files.

The default editor for Mac OS X, TextEdit, can also view and edit RTF files.

Regards,

sasi

Please reward points if useful.

Re: conversions

Former Member — Tue, 04 Mar 2008 15:46:14 GMT

Hi Rajee,

The only difference between SAP_CONVERT_TO_CSV_FORMAT and SAP_CONVERT_TO_TEX_FORMAT is, you can only convert text into a CSV file (comma separated valeu) using SAP_CONVERT_TO_CSV_FORMAT, whereas you can convert a text into a file having values that are sperated by your own delimiter like asterisk ( * ) or backslash ( \ ) or double qoutes ( " ).

Re: conversions

Former Member — Wed, 05 Mar 2008 09:28:36 GMT

hi,

thanks for your answer.

but problem is iam getting data in excel sheet instead of comma separation .why iam getting like that

Re: conversions

Former Member — Wed, 05 Mar 2008 10:18:04 GMT

hi,

chk this prog,

data: xht(1) TYPE x VALUE '09',

Filename TYPE dxfile-filename c lower case,

Delimiter TYPE char01 value ';',

Ouput_String TYPE truxs_t_text_data with header line.

*Use FM SAP_CONVERT_TO_CSV_FORMAT and pass a Delimiter and ITAB. This

returns an Ouput_String

Convert Internal Table to ; delimited format
There is a filename parameter on this FM but I don't think it's used

call function 'SAP_CONVERT_TO_CSV_FORMAT'

exporting
i_field_seperator = Delimiter "default ';'
i_filename = Filename

tables

i_tab_sap_data = ITAB

changing

i_tab_converted_data = Ouput_String

exceptions

conversion_failed = 1

others = 2.

Then

open dataset Filename for output in text mode encoding default. ( not sure

maybe binary mode)

Loop at output_string.

replace all occurrences of Delimiter in Ouput_String with xht.

transfer Ouput_String to Filename.

Endloop.

close dataset Filename.

chk this link..

Hope this helps u,

Regards,

Arunsri

topic conversions in Application Development and Automation Discussions

conversions

Re: conversions

Re: conversions

Re: conversions

Re: conversions