I have a complicated structure
I am using FieldSeperator and I am getting errors
I thought of using FieldFixedLengths
Client wants structure in a string without any seperator
Segment one in first line, with five fields
Segment two in second line, with around fifty fields
The problem is some of the fields that are not mandatory are not coming
For ex: In Segment 2, field seven is dynamic
It can have either some value or it may not have any value at all
Requirement is it should occupy forty spaces. So I used a udf. If there are five fields, I use thirty five spaces. I there are no values at all I pad forty spaces.
1) If I empty spaces for an entire field, will the communication channel treat it as a field or throw errors?
Secondly, I was not able to seperate segment two and segment three into different lines. Both these segments occur unlimited times and the first field of the third segment comes in second segment only. So I used a dummy segment seven.
Similary I used a dummy segment eight to get segment three and segment four in seperate lines
2) Will these dummy fiels throw error in FCC?