stateemk,
I would first create such field in query and then take it out to a text file.
To create such field you can use expression in your query like this:
- FinalString: [EMP_ID]&Format(Fix([dedamt]) & Right(Format([dedamt];"#,00");2);"00000000")
Please note here that i'm using symbols ; and , as it is adjusted to my local settings (Croatia)
You might need to replace some of those with your own smbols, but you should get the result.
regards,
h.