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