Reg Keyfigures data type in Transfer structure

[Former Member]

Hi Guys,

When we create a transfer structure for a falt file source system, keyfigures data type is getting converted into CHAR automatically and even the length is assigned . Whats the reason behind this?? How do we get the lenght of a keyfigure?

[former_member619464 · Accepted solution]

Hi Reddy,

CSV stands for "Comma Separated Value". This file format is often used to exchange data between disparate applications. The file format, as it is used in Microsoft Excel, has become a pseudo standard throughout the industry, even among non-Microsoft platforms whereas

<u>ASCII codes</u> represent text in computers, communications equipment, and other devices that work with text.

<u>The CSV File Format</u>

Each record is one line ...but

A record separator may consist of a line feed (ASCII/LF=0x0A), or a carriage return and line feed pair (ASCII/CRLF=0x0D 0x0A).

...but: fields may contain embedded line-breaks (see below) so a record may span more than one line.

Fields are separated with commas.

Example John,Doe,120 any st.,"Anytown, WW",08123

Leading and trailing space-characters adjacent to comma field separators are ignored.

So John , Doe ,... resolves to "John" and "Doe", etc. Space characters can be spaces, or tabs.

Fields with embedded commas must be delimited with double-quote characters.

In the above example. "Anytown, WW" had to be delimited in double quotes because it had an embedded comma.

Hope it helps...let me know

regards,

R.Ravi

[Former Member · Accepted solution]

Hi Ravi,

Thanks for the info. So can we say excel sheet as CSV file. In excel sheet we dont have to give any separators right!

[Former Member]

Hi,

Yes you can create the ".CSV" file in MS Excel. Enter the data in the columns and then save as a ".csv" file. It may throw some warnings you mat just ignore them. Now when open the same file in notepad you would find the data separated by commas.

Hope this helps.

Bye

Dinesh

[Former Member]

Hi,

Data fields separator, decimal sign and triada delimiter for Excel is set in Regional settings in control panel.

Best regards,

Eugene

[Former Member]

I think it's because flat file (CSV or ascii) are assumed as text file; in any case, if you use CSV file the lenght doesn't matter.

Hope this help.

Regards

[Former Member]

Hi,

Can yop please tell me what exactly are CSV and ASCII files? How do they differ? What are the scenarios to use them?

[Former Member]

Asci files are with fixed record lenght for example if you have account(char 10), cost center(CHAR 10) and amount(NUM 17) you'll ave a record like that:

ACCOUNT Cost C. Amount

0012345678 CC12345600000000000000100

In CSV (comma separeted file) each field has a character separator (usually , or ;); in that case the record is:

12345678;CC123456;100

Regards