February 15, 2010 at 9:14 am
Has anyone worked with .tdf files?? I received some data in *.tdf
It is data and i can open it with notepad but the format is awful. Anyone suggest a tool or a better way to get at decent formatted data in .tdf??
February 15, 2010 at 10:28 am
Can you open it with Profiler?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 15, 2010 at 10:40 am
no, can't with profiler.
2 minutes ago i gave it a shot with excel and it opened just fine. It is data in column and rows. I have no idea what created it. received from an external resource.
so if anyone comes across this type, excel worked for me.
February 15, 2010 at 11:12 am
I think it's a template for Profiler that can be imported. It only shows settings for a trace.
February 22, 2010 at 12:30 pm
TDF is an acronym for "Tab Delimited File (or Format)." Any non-numeric columns may be enclosed in quotes. Yes, Excel will open it, although you'll get a 'conversion' message in Office 2007 (or later, I suppose; we just upgraded to 2007.)
April 4, 2010 at 7:21 pm
PeterG-377490 (2/15/2010)
Has anyone worked with .tdf files?? I received some data in *.tdfIt is data and i can open it with notepad but the format is awful. Anyone suggest a tool or a better way to get at decent formatted data in .tdf??
Open it in word, do a global edit/replace to conver "^t" to ",", and save that; and then it's just comma delimited text and lots of things will handle it - probably excel is the easiest.
I think newer versions (than Office 6 or whatever I remember from the distant past that didn't do it) of Excel may recognise tdf antway, that may be better than coverting the tabs to commas.
Tom
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply