DSXchange

Hi,

I need to concatenate some text + newline(\n) + <input field>.
Can any one help how to add newline between some text and input field.

Thanks
Anju

Create a stage variable, let's call it svNewLine. In Windows, of course, the line terminator is actually two characters (carriage return and line feed), so initialize the stage variable to Don't assign any new value to this stage variable during per-row processing.
The derivation for your output column then becomes

Hi Ray,

I can view your answer till
"Create a stage variable, let's call it svNewLine. In Windows, of course, the line terminator is actually two characters (carriage return and line feed), so initialize the stage variable to Code:"

till here,can you explain me again how to get newline.

Thanks
Anju

Anju,


Ray's response is part of Premium content, which you can view if you were to sign up for that relatively inexpensive membership.

Even though the message is not currently viewable in it's entirety, the portion that is visible gives you the clue on how to solve your problem. Basically, a "\n" (UNIX), or <CR><LF> (Windows) is just another string that can be manipulated with normal string functions.

ok.
my frontend is Wincdows for datastage and backend is Unix.
I dont have an idea how to put a newline using CR /LF in datastage.Can you tell me how to do that.

Hi ArndW,
my frontend is Wincdows for datastage and backend is Unix.
I dont have an idea how to put a newline using CR /LF in datastage.Can you tell me how to do that.

LF (LineFeed) is Char(13)
CR (CursorReturn) is Char(10).

Lets say you want to have a new Line after "John" you code in Unix:

" In windows it is:

Hi, use the char() function which generates an ASCII character from its numeric code value. Then numeric value of LF is 10 and CR is 13.
So concatenate: "your text" : char(13) : char(10) : <input field>.

Are you sure that you need a Windows format file, as your backend is UNIX?

In UNIX you need only LF - char(10).

Thanks a lot.Its working now.I used char(10).

U r wellcome

vilasini, you should tag your post as "unix" not "windows" if your server platform is unix.