04-17-2014 09:56 PM
i have ran a code:
for some strange reason, after i get rid of Dec, I get a space between my year ie: (space)2013
how can i remove that space so that the ones that i removed Dec aligns with other year observations?
04-17-2014 10:41 PM
I think there's better ways to do what you want to do...but you need to provide more details.
You can use compress to remove spaces to solve your immediate problem.
04-18-2014 02:26 AM
In case you would like to remove the character data from the variable, you can try the below code
04-18-2014 03:13 AM
for some strange reason, after i get rid of Dec, I get a space between my year ie: (space)2
how can i remove that space
AnnualReportDate = tranwrd( annualreportdate, 'Dec2', '2' ) ;
You might need to repeat it for the 1900s if your reports go that far back (but that seems less likely)
04-18-2014 07:32 AM
To replace to null string, length 0, you need "new" TRANSTRN function and to specify a 0 length string you need a function like TRIMN.