Hi,
I am using fixed width to read text file.
But after using same setting i am not getting proper data.
This is the field setting i am using.
below is the setting.
As we can see in the preview the data is not proper according to the fixed width rule.
Please help me on this.
Hi @vijaylnyadav ,
can you post a workflow as an example?
maybe if try importing the data as csv and using other tools to transform the data?
Cheers,
BR/Jonny
@Jonny i cant post here because of confidentiality. Here, I cant use any other file format but Text only as an input source.
@vijaylnyadav You can first save and export the setting from "Flat File Layout"
Post which you can use the same file as a reference and select:
"Use Field Settings from File" as a reference document.
Let me know if this works.
Can you cut and paste a text sample? I don't see anything wrong though. Your first screenshot shows where your fields are supposed to split and the red lines confirm it.
Your second screenshot shows your data split at those red lines. It doesn't match up with what we would see as fields - but it matches up with your first screen shot which controls where the splits occur - the field with the word "hart" in it is just left aligned instead of right aligned...