Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: String problem
From
Carlos Avellaneda Suárez <[email protected]>
To
[email protected]
Subject
Re: st: String problem
Date
Tue, 18 Mar 2014 10:54:18 -0500
Thanks a lot Nick, that is really useful (and thanks for the prompt
answer as well)! Your first suggestion works fine for my situation.
Best regards,
Carlos
2014-03-18 10:27 GMT-05:00 Nick Cox <[email protected]>:
> On this example, the problem is trailing "*/". That could be fixed with
>
> replace ref = subinstr(ref, "*/", "", .)
>
> if "/*" never occurs otherwise, or with
>
> replace ref = substr(ref, 1, length(ref)-2) if substr(ref,-2, 2) == "/*"
>
> more conservatively.
> Nick
> [email protected]
>
>
> On 18 March 2014 15:22, Carlos Avellaneda Suárez
> <[email protected]> wrote:
>> Dear Statalist,
>>
>> I have to merge several datasets where my key variable is a string
>> variable, with no specific rule about the length of each string
>> observation. The problem is that there are some characters (i.e. */)
>> that are mistakenly added at the end of some observations. I would
>> like to know how to eliminate those characters because they are
>> causing me troubles when I merge the datasets. I am sorry if this is a
>> basic question, but I have never faced this problem before and I don't
>> know how to solve it.
>>
>> Here is an example of what I have:
>>
>> ref
>> WG1855515
>> WG1855515*/
>> WIN18555R15
>> WIN18555R15*/
>> PCAV
>> PCAV*/
>> HKK20560R16
>> HKK20560R16*/
>>
>> Here is what I would like to obtain:
>>
>> ref
>> WG1855515
>> WG1855515
>> WIN18555R15
>> WIN18555R15
>> PCAV
>> PCAV
>> HKK20560R16
>> HKK20560R16
>>
>> Any help is highly appreciated. Best regards.
>> Carlos
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/