Use Macro to export table to csv

[ljbrewer]

I have a table with 5 fields in it, all text. When I export it manually the output is fine:
Accountid ApplicationN FirstName LastName Name
sm891 dev.racf 259

When I use a macro the second field is filled some type of numbers:

Accountid ApplicationN FirstName LastName Name
sm891 64 00 65 00 76 00 2E 00 72 00 61 00 63 00 66 00 259

What is going on here?

any insite would be appreciated

 

[NickHa]

The numbers you see are the hexadecimal equivalent of dev.racf. This reflects the way the field is stored as a null-terminated string. What is the data type of that field?

 

[NickHa]

... Might be worth adding that RACF is a clue ... This indicates an IBM mainframe which possibly uses EBCDIC code, so the origin of the dat file may be related to the data type.

 

[ljbrewer]

The data type of the field is Text just like the others. The value for the field, "dev.racf", is being typed in by the user. That is why I am so confused if it was actually being imported from the mainframe it would make sense for it to be in Hexidecimal.

Thank you for your notes though. Any other ideas?