|
PureBytes Links
Trading Reference Links
|
Hi Pernin,
This has been accomplished in another way.
I exportd to ACSII from the old database, one more column extra,
which is stripped of unwanted suffix "EQ" by using string function.
And imported to new database, skipping the old ticker.
and it is perfect without any editing.
My problem is resolved.
rgds
Murty
--- In amibroker@xxxxxxxxxxxxxxx, "pernin22" <pernin22@xxxx> wrote:
>
> Try to remove it with Word, it has no such limitation.
>
> The other way to do it with Excel or Notepad is to split the
original
> ascii file in several ones, smaller.
>
>
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "mrmurty" <mrmurty@xxxx> wrote:
> > My sample data is given here.
> > I want to remove "EQ" from Ticker symbol.
> > This can be accomplished by exporting to ASCII and editing
> in "Excel" or any ascii editor.
> > But excel has 65000 rows limitation. Notepad program hangs.
> > Now the problem is :
> > 1. Any idea of setting of default 'ticker' column in explore
> > 2. Any method to remove string suffix from ticker.
> > 3. Or can I change tickers in the database without exporting.
> > The ascii file should not be edited.
> >
> > Thanks in advence
> > rgds
> > murty
> >
> > **************************************************************
> > ACCEQ 8/20/2003 216.55 220.80 213.65 217.58
4060704
> > ACCEQ 8/21/2003 217.85 221.45 215.20 218.73
4587142
> > ACCEQ 8/22/2003 220.00 222.20 215.25 218.84
2926373
> > ACCEQ 8/25/2003 219.00 219.45 201.10 211.38
3089299
> > ACCEQ 8/26/2003 207.90 215.00 206.70 211.72
2608349
> > ACCEQ 8/27/2003 217.80 217.80 212.65 214.83
2208888
> > ACCEQ 8/28/2003 212.00 212.00 204.00 206.90
4599912
> > ACCEQ 8/29/2003 207.00 215.75 206.00 211.61
4280955
------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|