Sigh, the perfect pain for Friday afternoon.
I'm trying load some data from a flat file, the numeric values have been exported with a comma as a the decimnal separator.
I can't get TI to recognise it.
I've changed in the data source tab.
I've changed it by assigning the it to the local variable DatasourceASCIIDecimalSeparator=',';
and I've also tinkered with the regional settings on the server and restarted it.
All to no avail. This means that a value like 1234,56 (i.e. 1,234.56) gets loaded as 123456.00, which really made my head ache when I was reconciliing the load...
Anyone know of a trick to get this working? I guess I can resort to treating the values as text and replacing the comma with full stop.
Version of server is 9.0 SP3 U9
TIA in advance for any ideas.
Cheers and bonne weekend!
Steve
Decimal Separator in TI
- Steve Rowe
- Site Admin
- Posts: 2415
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Decimal Separator in TI
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Decimal Separator in TI
Oddly enough I hit this last September at the French sub of your and my friends in the Middle East...
My quote from an email follows....
It appears that if you do everything in pure TI script then it's fine - it's only the frontend that gets confused
My quote from an email follows....
It appears that if you do everything in pure TI script then it's fine - it's only the frontend that gets confused
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: Decimal Separator in TI
If the file isn't HUGE and if it's only a one time thing I would rip it into excel, change it and more on. However, if this would be a recurring problem I got nothing. How difficult is it to change the script that is delivering the output?
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
- Steve Rowe
- Site Admin
- Posts: 2415
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Decimal Separator in TI
Just a quick update on this, I'd messed the data type up while fiddling around trying to get the load to work.
So in version 9.0 SP3 U9
Setting the decimal separator to , in the data source tab does not work.
Setting it to , using DatasourceASCIIDecimalSeparator=','; in the prolog does work.
Cheers,
Steve
So in version 9.0 SP3 U9
Setting the decimal separator to , in the data source tab does not work.
Setting it to , using DatasourceASCIIDecimalSeparator=','; in the prolog does work.
Cheers,
Steve
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Decimal Separator in TI
Nevermind excel, when having problems like I use PFE (Programers File Editor.) It is free software that you find easily using google. It is designed to handle both small and large files. for those of you that can't be bothered looking I have attached a zip file containing the loose files for said software,
Jim.
Jim.
- Attachments
-
- pfe101i.zip
- (607.26 KiB) Downloaded 461 times
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Decimal Separator in TI
That's one scary application. It has search and replace, the ability to create keyboard macros so that you can repeat blocks of code, the ability to toggle line numbering down the margin... oooooooh, I'm sure that I must need a bank of Crays to run it.jim wood wrote:Nevermind excel, when having problems like I use PFE (Programers File Editor.) It is free software that you find easily using google. It is designed to handle both small and large files. for those of you that can't be bothered looking I have attached a zip file containing the loose files for said software,
(Well, that's the only reason I can think of for why we (still) don't find such features in the TI editor...)
Thanks for that one Jim; could be useful.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: Decimal Separator in TI
bank of Crays
Lost in translation again?
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Decimal Separator in TI
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.