endSeparator

[Former Member]

How to denote endSeparator value as empty string or end of file in file content conversion at the receiver side

i.e values for Recordset.endSeparator for above 2 cases.

typing '' (2 single quotes doesnt work...it prints the single quotes in the target file)

Thanks in advance,

regards,

Shaji

[STALANKI · Accepted solution]

USE '0'.It has to work..:)

[Former Member · Accepted solution]

Sravya,

It does work.

From help.sap.com.. it kinda said that '0' is not a separator and hence didnt try it out earlier.

From the site

"Special Characters in the String for Separators:

In all strings for separators (NameA.fieldSeparator, NameA.beginSeparator, and NameA.endSeparator), you can specify non-printable ASCII characters. These characters can each be inserted individually in the strings in the form ´0xHH´ (including the quotation marks), where HH represents the character coded as a hexadecimal value. A line break can be entered using the character ´nl´ (including the quotation marks); nl stands for new line. The special character ´0´ is not a separator character."

Thanks for the help..u'll get ur points.

[Former Member]

Shaji,

Give '0x1A' for end-of-file including the quotes.

regards,

Felix

[Former Member]

1 single quote definitely doesnt work for empty string.

for end of file felix it prints the '0x1A' in the file..so if i am having some elements after the recordset structure it prints as many instances of '0x1A'

[Former Member]

Shaji,

0x1A is the EOF character in DOS and windows for text files

That is the reason I asked you to try that for end of file, but you can't use that for binary files.

regards,

Felix

[Former Member]

Hi Felix,

I am sending text file itself.

regards,

Shaji

[Former Member]

Dont need a new line as end seperator

....u mean for an empty string i should use 1 single quote ....? i.e. ' and not 2 ..i.e ''

what about when i need denote endSeperator as End of File?

points awarded ofcourse if it works

[STALANKI]

use single quote..:)

it is 'nl'..:)

allot me points if u can..:)

[Former Member]

single quote doesnt twork for empty string