TM1 Forum

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

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

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?

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

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 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,

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.

(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.

bank of Crays

Lost in translation again?

Eric wrote:

bank of Crays

Lost in translation again?

http://www.cray.com/

Just the thing for 9.4!