Splitting of Values into 2 or more lines

[poornima.chandramouli]

Hi,

I've a input file which holds a column of length 20 characters.
I've to write it in the target which has the column length as 8 characters.
So the first 8 characters should be written in first line of the column & the next 8 characters should be written to the nest line,.....

But the values of the other columns should remain same.

Code: Select all

Input:

Name    Explanation
Jai         My pet name is Huby
Ram      My Pet name is Tiger

Output:

Name    Explanation
Jai         My pet name
             is Huby
Ram       My Pet name
              is Tiger

How to achieve it in datastage.

[nirdesh2]

In Transformer, use 2 output links and write first 8 chacacter is first link and rest character in second link and then use funnel stage to combine both the output.

[Sainath.Srinivasan]

or easier still, convert the req char to newline.

[poornima.chandramouli]

In Transformer, use 2 output links and write first 8 chacacter is first link and rest character in second link and then use funnel stage to combine both the output.

Hi Nirdesh,

Thanks for ur reply.
But if in the case of my input having more characteres,which has to be written in more than two lines in the output,then having 2 outputs from a transformer won't workout.

[poornima.chandramouli]

or easier still, convert the req char to newline.

Hi Sainath,

Could you please elaborate a bit.

[Sainath.Srinivasan]

In pseudocode.....

If you find that 'n'th char is where you need to break, do it like

Code: Select all

keyField = keyField
nonKeyField = nonKeyField[1, n - 1] : newlineChar : nonKeyField[n + 1, 9999]

I will leave it to you to derive the value of 'n' and 'newlineChar'

[ray.wurlod]

If you're prepared to use a server job this is a very easy task.

Code: Select all

Convert(@TM,@FM,Fmt(InLink.TheString,"8L"))

and write to a text file.

[dganeshm]

In pseudocode.....

If you find that 'n'th char is where you need to break, do it like

Code: Select all

keyField = keyField
nonKeyField = nonKeyField[1, n - 1] : newlineChar : nonKeyField[n + 1, 9999]

I will leave it to you to derive the value of 'n' and 'newlineChar'

Need help to define the 'newlineChar' , if I give '\n' it doesnt recognise it and loads it as '\n' , what should be the value of newlingChar so that it is recognised...

[anbu]

This gives a new line character

Char(10)

[dganeshm]

This gives a new line character

Char(10)

Thanks Anbu..