Tab delimited and Right justified fields

[Former Member]

Hi

My requirement is to produce an output file where the line items consists of 5 fields of variable lengths and all of them are tab delimited and right justified at the same time

for eg.

ABC 123456ghtje 4567.45678 67.45678 pqr

where all the values in the first field 'ABC' and 2nd field '123456ghtje' are right justified and are tab delimited and asme is the case for '4567.45678' , '67.45678' and 'pqr'

they are all separated from each other by a tab but are not fixed lengths

How can i achieve that ? i am using File Receiver Adapter ??

Can it be done without Adapter Module ?

Thanks

Dev

Edited by: sd on Feb 22, 2010 2:25 PM

Edited by: sd on Feb 22, 2010 2:26 PM

[VijayKonam · Accepted solution]

> they are all separated from each other by a tab but are not fixed lengths

When thay are not fixed length fields, why do you have to worry about left or right justification? In delimetted files, you would only have the delimitter between the fields. You do not need to fill spaces for justifying them.

VJ

[Shabarish_Nair]

Right justification should be done in your mapping.

Use a simple UDF to help you.

TAB limited file can be created using your adapter using FCC.

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter - this is for the sender but you can use the similar settings for the receiver.