newline character

vilasini · Post by **vilasini** » Tue Mar 04, 2008 1:06 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 2:05 am

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: Select all

Char(13):Char(10)

Don't assign any new value to this stage variable during per-row processing.
The derivation for your output column then becomes

Code: Select all

"some text" : svNewLine : InLink.InputField

vilasini · Post by **vilasini** » Tue Mar 04, 2008 2:24 am

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

ArndW · Post by **ArndW** » Tue Mar 04, 2008 2:28 am

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.

vilasini · Post by **vilasini** » Tue Mar 04, 2008 3:40 am

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.

vilasini · Post by **vilasini** » Tue Mar 04, 2008 3:40 am

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.

WoMaWil · Post by **WoMaWil** » Tue Mar 04, 2008 3:57 am

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:

"

Code: Select all

John":char(13)

In windows it is:

Code: Select all

"John":char(13):char(10)

admiral1969 · Post by **admiral1969** » Tue Mar 04, 2008 3:58 am

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>.

ArndW · Post by **ArndW** » Tue Mar 04, 2008 4:10 am

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

admiral1969 · Post by **admiral1969** » Tue Mar 04, 2008 4:37 am

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

vilasini · Post by **vilasini** » Tue Mar 04, 2008 4:40 am

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

admiral1969 · Post by **admiral1969** » Tue Mar 04, 2008 4:49 am

U r wellcome

PhilHibbs · Post by **PhilHibbs** » Tue Mar 04, 2008 5:49 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 6:01 am

Please mark the thread as resolved.