Exporting comma delimited file problem

[gj0519]

I have a formula that creates a comma delimited file.
When I export the data into a text format my formating is changing.
This is my formula:

ToText({Command.MEMBER_NBR},0,"") & "," &
ToText({Command.SHARE_NBR},0,"") & "," &
"Y"

This is what I am getting after I export the data.
12345,8,Y
12345,8,y
12345,8,y
My problem is all the data should line up to the left, not with a space before the first character after the first line.
Any suggetions on how to fix this?

Thanks,

-Glenn

 

[reidtw]

Try: -

ToText({Command.MEMBER_NBR},"00000",5) & "," &
ToText({Command.SHARE_NBR},"0",1) & "," &
"Y"

where "000000",6 and "0",1 needs to be adjusted for the length of each field you want to output.

This should hopefully keep the columns together, otherwise you may have to change the way you are exporting.

T

 

[gj0519]

Thanks for the suggestion reidw. I downloaded a hot fix from Crystal and that fixed my problem.

Glenn

 

[Marichele]

Glenn,

What version are you and which hotfix did you download?

Thanks
Mary
CR 8.5

Thanks,
Mary