Hello,
I am trying to match a dat file that one of our main suppliers is requiring us to export
The last line in this img is what I have now from filemaker the rest are what I am trying to mimic, I uploaded an screenshot here
http://db.tt/Mq4Fc9f
This is my field definition for every record:
Let( [
m = Month( date );
m = If( Length( m ) = 1; "0"; "" ) & m;
d = Day( date );
d = If( Length( d ) = 1; "0"; "" ) & d;
y = Year( date );
y = If( Length( y ) = 4; Right( y; 2 ); y);
rid = "*" & rollID & "*";
r = rollID & space( 20 - Length( rollID ) );
po = m & d & y & space( 20 - Length( m & d & y ) );
dte = If( Length( date ) < 10; "0" & date; date ) & space( 10 - Length( date ) )
];
"123456" & space( 6 ) & //scanner serial Number
"111" & space( 1 ) & //site code
"PHY" & " " & //Transaction code
dte & " " & //date of scan
space( 12 ) & " " & //delivery number
po & " " & //po number
space( 20 ) & " " & //physical ID
space( 18 ) & " " & //material Number
r //roll id & ""
)
/*
Field Start (1 based) Length Notes
Scanner Serial Number 1 12
Site Code 14 3
Transaction Code 18 3
Transaction Date 22 10
Delivery Number 34 12
Po Number 47 20
Physical Id 68 20
Material 89 18
Product Id 108 20
*/
ok now I have tried replacing the spaces in between each field with char(0) to get the nul character that does not work.
I have tried placing char( 12 ) at the end after the roll id that did not work it simply displays as shown above never showing the appropriate characters. I have confirmed by copying his FF into the data viewr and using the code function it does return 12 and the nul returns 0
I have tried exporting as tab and mer files with encoding set to ansi, aschii, utf-8, utf-16
Why can I not export char(0) as nul and char(12) as FF, can it be done? Before I spend more time on this I was hoping someone would have an answer or flat out tell me it can not be done.
Thanks