• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] FilePositionalDelimited

#1 2011-09-21 13:46:02

Vijay Muthiah
Member
Registered: 2011-07-27
Posts: 11

[resolved] FilePositionalDelimited

Dear All,

I have a price value as 1500.00. I am using FileOutputPositional to place the price value. Which has 10 as size. So the output will be 0001500.00

My requirement is have to mark negative value in the left most corner of the value i.e., -001500.00

Any one please help me.

I have attached the image for your reference.

Any help will be appreciated


Uploaded Images

Offline

#2 2011-09-22 05:49:23

shong
Talend team
Registered: 2007-08-29
Posts: 10306
Website

Re: [resolved] FilePositionalDelimited

Hi
I think you need to hard code a routine for appending "0" at the begin of value and then adding "-" on tMap before FilePositionalDelimited.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Online

#3 2011-09-22 07:40:03

Vijay Muthiah
Member
Registered: 2011-07-27
Posts: 11

Re: [resolved] FilePositionalDelimited

I tried that, its working fine.

Thank you.

Regards,
Vijay Muthiah

Offline

#4 2011-09-22 07:41:43

shong
Talend team
Registered: 2007-08-29
Posts: 10306
Website

Re: [resolved] FilePositionalDelimited

Vijay Muthiah wrote:

I tried that, its working fine.

Thank you.

Regards,
Vijay Muthiah

Good news, would you like to share the code with community?

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Online

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] FilePositionalDelimited

Board footer

Powered by FluxBB