Getting rid of the quote character generated by asciioutput

Post Reply
Jeroen Eynikel
Community Contributor
Posts: 139
Joined: Mon Sep 15, 2008 1:45 pm

Getting rid of the quote character generated by asciioutput

Post by Jeroen Eynikel »

Hi,

I have a file created by asciioutput whose contents look as follows

"2012-03-22 12:00:00|VDEVAPPNOSO2|DAYMO|LogIn|CFG535||||"
"2012-03-22 14:00:00|VDEVAPPNOSO2|DAYMO|LogOut|CFG535||||"
"2012-03-22 01:00:00|VDEVAPPNOSO2|DAYMO|LogIn|AAJ549||||"

This file is to be imported in another application and is almost what I need except for one thing. I need to get rid of the quote characters on each line.

Now I don't think there is a way to do this using pure TM1 - although I would be delighted if it turns out I am wrong :)

So if not possible by using pure TM1 I guess my next best option is to have a batch script called by TI after the filecreation to get rid of the quotes.

Anyone happen to have such a script lying around (or know of a way to get this done in TM1 after all)?

Thx,

Jeroen
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Getting rid of the quote character generated by asciiout

Post by qml »

You are indeed wrong. ;)

Check out this thread from just a few days ago.
Kamil Arendt
Post Reply