Skip to Content
0
Former Member
Mar 23, 2010 at 07:05 PM

Flat File Transfomation omiting delimiter

40 Views

I am working on a project transforming an XML file to Flat File.

The Flat File Delimiter is {//}

There is 37 columns target. Therefore there should be 36 delimiters of {//} in each row.

The problem is that when i transform a file. The first 3 have 36 delimiters but the 4th row has 35. Which is throwing the data off in the target system.

I've narrowed down on what column the issue is happening at. It is column 19 which is a date field on the source. But can't determine what is wrong because it works in Row 3 and not in Row4

Any help is appreciated..

Row 3 when broken down looks like this

Audit Finding{//}
AUDFND-1147{//}
1{//}
AQR{//}
krenzdc{//}
SSome Data Comments really long Description.{//}
2009-10-27T21:42:04Z{//}
2009-12-02T19:42:02Z{//}
Span, Victor{//}
{//}
{//}
{//}
{//}
{//}
{//}
{//}
Yes{//}
{//}
{//}
{//}
{//}
{//}
Recommendation a.:  All clip loader validations should be reviewed more data goes here extremely long summary{//}
Standard{//}
ISO 13485{//}
7.5.2.1{//}
No{//}
{//}
{//}
{//}
{//}
Critical{//}
Validation{//}
{//}
{//}
Validation - Process Validation{//}
JOB1267117228099 

Row 4 looks like this

Audit Finding{//}
AUDFND-1436{//}
1{//}
AQR{//}
forddm{//}
88. some data goes here a very long description{//}
2009-12-09T18:13:15Z{//}
2009-12-15T03:43:47Z{//}
Nich, Liz{//}
{//}
{//}
{//}
{//}
{//}
{//}
{//}
Yes{//}
{//}
{//}
{//}
{//}
A lot of text goes here about results{//}
Regulation{//}
21CFR820{//}
.198(c){//}
No{//}
{//}
{//}
{//}
{//}
No Rating{//}
Complaints and Product Actions{//}
{//}
AQR Report{//}
Complaints and Product Actions - Product Complaint Management{//}
JOB1267117228099