Ebedding a Horizontal TAB Character in a String

(imported topic written by jclark91)

I have been trying to embed a horizontal tab character into a string returned by relevance language. I have tried using the “%09” construction, but that doesn’t seem to work. Here is an example of my attempt at separating strings with TAB characters:

(name of it & “%09” & (free space of it / 1000 / 1000) as string & “%09” & (total space of it / 1000 / 1000) as string & “%09” & (free space of it * 100/ total space of it) as string) of drives whose (type of it = “DRIVE_FIXED”)

Any suggestions are welcome.

(imported comment written by jessewk)

I think you’re doing the right thing and your string actual does contain a TAB character. My guess is that TABs are not displayed they way you’d like them to be displayed in the console / relevance debugger / web reports.

Does it have to be tabs? I would write your query like this:

(name of it , (free space of it / 1000 / 1000) , (total space of it / 1000 / 1000) , (free space of it * 100/ total space of it)) of drives whose (type of it = “DRIVE_FIXED”)