tFileInputPositional Padding

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

ok, thanks

[Anonymous]

Hi arve,
Is it working for your issue? Is there any update?
Best regards
Sabrina

[Sudhee_Maximus]

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

the last record wouldn't have got insertedfile looks like this with fixed with delimited