On Fri, Nov 13, 2009 at 9:25 AM, Ada Ma <[email protected]> wrote:
> Dear Sergiy
>
> Thanks a lot for all the links and for the command you have written!
>
> I have one more question - how does one turn the hex back into ascii?
. inten 16 61
97
. di `"`=char(r(ten))'"'
a
>
> Regards,
> Ada
>
> On Thu, Nov 12, 2009 at 11:00 PM, Sergiy Radyakin
> <[email protected]> wrote:
>> Dear Ada,
>>
>> for numerical variables setting format to %21x is quite useful:
>> . sysuse auto
>> (1978 Automobile Data)
>>
>> . format price %21x
>>
>> . list price in 1/5
>>
>> +-----------------------+
>> | price |
>> |-----------------------|
>> 1. | +1.0030000000000X+00c |
>> 2. | +1.28d0000000000X+00c |
>> 3. | +1.dae0000000000X+00b |
>> 4. | +1.2d00000000000X+00c |
>> 5. | +1.e930000000000X+00c |
>> +-----------------------+
>>
>>
>> For string variables see below.
>>
>> Best regards,
>> Sergiy Radyakin
>>
>> net from http://www.adeptanalytics.org/radyakin/stata/hexstring
>> or
>> http://www.adeptanalytics.org/radyakin/stata/hexstring/hexstring.exe
>> for Windows users
>> or
>> http://www.adeptanalytics.org/radyakin/stata/hexstring/hexstring.zip
>> for single file download
>>
>>
>> -hexstring- a command to create a new string variable containing ASCII codes
>> of values of another string variable.
>>
>> Author: Sergiy Radyakin, Consultant, DECRG, The World Bank
>> Date: 12nov2009
>>
>> Syntax:
>> hexstring varname, generate(newvarname) [separator("something") decimal]
>>
>> Explanation:
>> varname - is the name of existing string variable
>> newvarname - is the name of the new variable to be generated and hold
>> the codes
>> separator - if specified, this character will separate the byte codes
>> in the resulting strings
>> decimal - if specified, codes should be decimal codes, default (if
>> this option is not specified) is hexadecimal (base 16) codes
>>
>> Command will issue warnings for every observation where there is not enough
>> space to store the codes of all the characters in the resulting variable.
>> Current Stata's limit for string variables is 244 characters.
>>
>> -hexstring- will store as many characters as possible.
>>
>> Use command -hexstring_vars- for multiple variables.
>>
>> Syntax:
>> hexstring_vars varlist, stub(string) [separator("something") decimal]
>>
>> Explanation:
>> varlist - is the list of variables to be converted
>> stub - is the prefix for the new variable name, e.g. if stub is "codes",
>> then variable "make" will be encoded into "codes_make"
>> Other options are described above in help for -hesxtring-
>>
>> hexstring_test.do and hexstring_vars_test.do are examples of use of
>> these commands.
>>
>> Examples:
>>
>> .
>> . sysuse auto
>> . hexstring make, generate("make_hex")
>>
>> . list make make_hex in 1/5, notrim
>>
>> make make_hex
>> 1. AMC Concord 41 4d 43 20 43 6f 6e 63 6f 72 64
>> 2. AMC Pacer 41 4d 43 20 50 61 63 65 72
>> 3. AMC Spirit 41 4d 43 20 53 70 69 72 69 74
>> 4. Buick Century 42 75 69 63 6b 20 43 65 6e 74 75 72 79
>> 5. Buick Electra 42 75 69 63 6b 20 45 6c 65 63 74 72 61
>>
>> .
>> . display "Decimal character codes"
>> Decimal character codes
>>
>> . hexstring make, generate("make_dec") decimal
>>
>> . list make make_dec in 1/5, notrim
>>
>> make make_dec
>> 1. AMC Concord 65 77 67 32 67 111 110 99 111 114 100
>> 2. AMC Pacer 65 77 67 32 80 97 99 101 114
>> 3. AMC Spirit 65 77 67 32 83 112 105 114 105 116
>> 4. Buick Century 66 117 105 99 107 32 67 101 110 116 117 114 121
>> 5. Buick Electra 66 117 105 99 107 32 69 108 101 99 116 114 97
>>
>> .
>> . hexstring make, generate("make_hexdot") separator(".")
>>
>> . list make make_hexdot in 1/5, notrim
>>
>> make make_hexdot
>> 1. AMC Concord 41.4d.43.20.43.6f.6e.63.6f.72.64
>> 2. AMC Pacer 41.4d.43.20.50.61.63.65.72
>> 3. AMC Spirit 41.4d.43.20.53.70.69.72.69.74
>> 4. Buick Century 42.75.69.63.6b.20.43.65.6e.74.75.72.79
>> 5. Buick Electra 42.75.69.63.6b.20.45.6c.65.63.74.72.61
>>
>>
>> *** END OF FILE ***
>>
>>
>>
>>
>> On Thu, Nov 12, 2009 at 3:26 PM, Ada Ma <[email protected]> wrote:
>>> Hi Statalisters,
>>>
>>> The -hexdump- command screens a file to check out what characters
>>> appear within a file. I am hoping to do something similar - but only
>>> with a subset of the variables within the data.
>>>
>>> I know that I can do it by saving the variables in a separate file,
>>> and do a -hexdump- on that file. I am just wondering if there are
>>> other command which would allow me to save that step.
>>>
>>> I have a couple dozens of string varibles and I want to check that
>>> they only have alphabetical and numerical characters within them, and
>>> strip out the characters which aren't. It's kind of hard to know what
>>> I need to strip out if I don't know what are in there to be strip out.
>>> Thus my question above.
>>>
>>> Many thanks for your help in advance!!
>>>
>>> Regards,
>>> Ada
>>>
>>>
>>> --
>>> Ada Ma
>>> Research Fellow
>>> Health Economics Research Unit
>>> University of Aberdeen, UK.
>>> http://www.abdn.ac.uk/heru/
>>> Tel: +44 (0) 1224 555189
>>> Fax: +44 (0) 1224 550926
>>> *
>>> * For searches and help try:
>>> * http://www.stata.com/help.cgi?search
>>> * http://www.stata.com/support/statalist/faq
>>> * http://www.ats.ucla.edu/stat/stata/
>>>
>>
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/statalist/faq
>> * http://www.ats.ucla.edu/stat/stata/
>>
>
>
>
> --
> Ada Ma
> Research Fellow
> Health Economics Research Unit
> University of Aberdeen, UK.
> http://www.abdn.ac.uk/heru/
> Tel: +44 (0) 1224 555189
> Fax: +44 (0) 1224 550926
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
