Fixed Width Report - Problem First Field

[reportdr]

Hello

I have created a report for a 3rd party vendor who reuqires a certain format for importing into their system. I export as tab separated values though set up as fixed width. Everything is working perfectly except the first field imports with a bar at the start and a quotation mark at the end. The formula:

numbervar requiredlength:=4;
numbervar currentlength:=length({@Salutation});

if currentlength<requiredlength then
{@Salutation}+replicatestring(" ",requiredlength-(length({@Salutation}))) else
if currentlength>=requiredlength then
left({@Salutation},requiredlength)

The value of Salutation is simply "".

Please note that the creation of this field is exactly like I created any other field that was required to be set up even though the fields are blank.

Can someone please help? Thanks.

S.

 

[synapsevampire]

If {@Salutation} is blank then why would you bother with this formula and not just use 4 spaces?

You stated The value of Salutation is simply "".

Perhaps you meant something else by that...

Anyway, since your post doesn't make any sense, just use brute force:

numbervar requiredlength:=4;
numbervar currentlength:=length({@Salutation});
stringvar Output:="";
if currentlength<requiredlength then
Output:= " "+mid({@Salutation}+replicatestring(" ",requiredlength-(length({@Salutation}))),2,2)+" "
else
if currentlength>=requiredlength then
Output:= left({@Salutation},requiredlength)

-k

 

[reportdr]

Hi

Thanks for the suggestion but it still isn't working - same characters show up.

Anyone else?

S.