Skip to Content
0
Jun 30, 2015 at 12:19 PM

FieldFixedLengths

21 Views

Hi

Segment1

Segment2

Segment7

Segment3

Segment8

Segment4

Segment5

Segment6

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?