Bookmark and Share

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]

st: RE: Re: st: Re: st: From: Χρυσούλα Γιαννικοπούλου <[email protected]>


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   st: RE: Re: st: Re: st: From: Χρυσούλα Γιαννικοπούλου <[email protected]>
Date   Tue, 10 Aug 2010 13:17:55 +0200

<>

Well, the solution is already there for your consumption:

***********
clear*
input str20 num
44.311.90
7.660.60
2.964.52
1.229.357.80
1.376.146.80
279.161.53
856.551.10
end

replace num = reverse(subinstr ///
	(reverse(num), ".", ",", 1))
destring num, replace ignore(.) dpcomma
format num %9,0gc

li
***********

BTW, his name is "T", -li- is a Stata command...

HTH
Martin


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of ???s???a
G?a?????p?????
Sent: Dienstag, 10. August 2010 13:06
To: [email protected]
Subject: st: Re: st: Re: st: From: Χρυσούλα Γιαννικοπούλου
<[email protected]>

Hi Li,

many thanks for the immediate reply!

Unfortunately, this doesn't help. Ok, it's completely my fault that I
did't explain my problem more detailed.

So, I have a variable name "dealvalue" in string format  with 72914
observations!!!

These observations are numbers but each observation has a different
number of digits.
For example:

2.964.52
1.229.357.80
1.376.146.80
279.161.53
856.551.10

3.669.70
3.153.20
30.882.40
12.858.29
41.284.40

14.504.50
1.531.50

17.823.72
-1
9.009.00


I would like the "," to specify the decimals and the "." to be used
for the 1000 separator.

Hence, these numbers i would like to appear like :

2.964,52
1.229.357,80
1.376.146,80
279.161,53
856.551,10

3.669,70
3.153,20
30.882,40
12.858,29
41.284,40

14.504,50
1.531,50

17.823,72
-1,00
9.009,00

This is just a sample!!! I need a command to do it automatically for
all the observations.

Thanks again!!

I appreciate your help!



2010/8/10 Tirthankar Chakravarty <[email protected]>:
> Try this:
> **********************
> clear*
> input str20 num
> 44.311.90
> 7.660.60
> 2.964.52
> 1.229.357.80
> 1.376.146.80
> 279.161.53
> 856.551.10
> end
> compress
> replace num = reverse(subinstr ///
>        (reverse(num), ".", ",", 1))
> li
> **********************
>
> T
>
> 2010/8/10  <[email protected]>:
>> Hi all,
>>
>> how can format these numbers
>> 44.311.90
>> 7.660.60
>> 2.964.52
>> 1.229.357.80
>> 1.376.146.80
>> 279.161.53
>> 856.551.10
>> so that the last "." to be "," ?
>>
>>
>> thanks a lot!!
>>
>> chrysa
>> *
>> *   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/
>>
>
>
>
> --
> To every ω-consistent recursive class κ of formulae there correspond
> recursive class signs r, such that neither v Gen r nor Neg(v Gen r)
> belongs to Flg(κ) (where v is the free variable of r).
>
> *
> *   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/


*
*   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index