tFileInputPositional Padding

One Star

tFileInputPositional Padding

I have fixed width files which contain a padding of "||"
The file looks like this:
368822441   ||29520250    ||48          ||CA||KINGS                              ||06||031

If I try to change the padding from space to || it gives me an error and I can't define a start end of the row.
How do I process this?
Seventeen Stars

Re: tFileInputPositional Padding

I would not use padding here. To get rid of the space you can trim the fields after reading through this component.
Your example looks more like a delimiter separated data sets (delimited with "||").
One Star

Re: tFileInputPositional Padding

ok, thanks
Highlighted
Moderator

Re: tFileInputPositional Padding

Hi arve,
Is it working for your issue? Is there any update?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tFileInputPositional Padding

Hi Xdshi ,
I have same issue where I am not able to trim columns even checking the option trim all columns in advanced section.

pic1.pngthe last record wouldn't have got insertedpic2.pngfile looks like this with fixed with delimited

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads