Export line feed
Walter Vaughan
wvaughan at steelerubber.com
Tue Oct 17 19:12:51 PDT 2006
George wrote:
> I thought I understood the syntax on adding a line feed from some previous
> posts, however I'm having a problem getting each record processed to add a
> line feed CHR("10") to the last field. Note the last field is & with a
> chr("10"), but the exported file does not reflect spaces between lines.
>
> What am I missing here?
>
> ::fn="/u/tmp/foo/"{"U"{@tm:
> :'Export ASCII, comma delimited; 1 line/record:export ascii exp=(fn) r=\n
> f=, -x:
> :'start with first field =barcode:exp(1)=1:
> :'Day of the week served mtwhfsu:exp(2)=25:
> :'Route number:oa=mid(2,"3","2"); exp(3)=oa:
> :'Stop Sequence:exp(4)=26:
> :'account number sending 8 character account number:exp(5)=2:
> :'type of garment from item number:exp(6)=4:
> :'Identity or wearer of garment name:exp(7)=3:
> :'Final routing/destination.:exp(8)="":
> :'27 ne "" 'auto routing code:exp(9)=27:
> :'27 eq "":'exp(9)="A":
> :28 ne "Y" 'Posting record to Softrol routing machine.:28="Y":
> :28 eq "":28="," & chr("10"):
> :28 ne "":28=28 & chr("10"):
> ::end:
You don't tell us what if any edits are on field 28
You don't tell us what is actually on the disk (I'm going to guess the LF's are)
You don't tell us how you are pulling the data from field 28 in the other app
that reads field 28 sends it to the "softrol routing machine"
You don't tell us what you really want in field 28. It seems like you want
hex 59 0A, since I can't see any condition where the second to last line
(the one with the comma) could be true. The line above always makes
field 28 equal to "Y" AFAICT before you append the LF character.
--
Walter
More information about the Filepro-list
mailing list