Facing problem to set boundaries in txt file

I am facing set boundaries because cut on number of line 68 so after 56 record boundaries out of field.

please suggest best way to create boundaries.

Hi Shahnawaz,

For text files with records that have different amount of lines you need to set the Boundaries to Trigger On Text and then the Operator to On Changes.

So in the sample linked below I selected the first number, “001”, change Trigger to On Text and the Operator to On Changes. After that set the Cut On Number Of Lines to 1.

So in your case you would want to find a field in your data that is unique to each record.

Download (Connect 2018.1.6)

Regards,

S