Sources: Reading .rtf rich text files?

daniel · January 27, 2014 6:38AM

I have an example data file in .rtf format but Omniscope does not read this properly. The main separator looks like an underscore "_" but I when I load it into Omniscope it comes up with an unrecognised character:

donald · January 27, 2014 10:24AM

The character in the rtf file that you have as a main separator is ascii character 01 (normally called SOH) , this is normally a control character.
If you use a text editor such as Notepad++ you can see it displayed as SOH and can copy the character and paste it into the separator field. It cannot be displayed as a character because it is a control character.

We do not recommend importing your data from a rich text document as text.

Normally text based data imported into Omniscope is in a tabular format.
See these pages:
http://www.visokio.com/kb/data-file-formats
http://www.visokio.com/import-data-phase

Can you describe in more detail what you are trying to achieve and why you are using rtf ?

We may be able to advise a more suitable method for importing your data.

daniel · January 27, 2014 10:36AM

Thanks,

That was just the format the data was provided by our data supplier. I think it will be fine for now to copy and paste the SOH to read the data. It's only a temporary thing which will could change later on.

	RTF.PNG	28K
	Example_TrafficScope_File.rtf	9K

Welcome!

Categories

Ideas Parade

Tagged