Formatting Data for this Forum

[raskew]

Hi -

Looking to see if anyone has a trick for formatting data examples for this forum.

Example:

At http://www.access-programmers.co.uk/forums/showthread.php?t=165152 (Post #4) I copied several rows of a query to serve as an example. In query view it was all nicely aligned, but pasting it to the forum, it ends up looking like:

Company Name Expr3 SumOfFreight
Alfreds Futterkiste September 1995 $29.46
Alfreds Futterkiste November 1995 $84.96

...truly ugly, and it makes it hard to follow. I've seen this problem for years but have yet to find a solution.

Any takers?

Bob

 

[gemma-the-husky]

put it in quotes or code wrappers seems to let you embed multi spaces

 

[raskew]

Thanks, Gemma, for that -

This is a test:

1) Using code wrappers:

Company Name	        Expr3	        SumOfFreight
Alfreds Futterkiste	September 1995	$29.46
Alfreds Futterkiste	November 1995	$84.96

2) Using quotes:

"Company Name Expr3 SumOfFreight"
Alfreds Futterkiste September 1995 $29.46
Alfreds Futterkiste November 1995 $84.96

Interesting! In test 1 (code wrappers), the actual data lines up fine. It's just a matter of horsing-around with the title line, e.g. (added spaces then click on Preview Post -- keep doing it until the alignment is correct).

Test 2, as you can see (unless I'm somehow incorrectly applying the quotes) was a total bust.

Test 1 is definitely doable, although a bit of a pain.

Thanks, Gemma, for your prompt reply.

Best Wishes - Bob

P.S. Refer back to my link. I applied Test1, took a couple of minutes to get it right.

 

[gemma-the-husky]

i didnt mean using quote marks

i meant using the quote wrapper (ie similar to the code wrapper) , or the code wrapper to add html tags

just depends how you want the block to be titled, since neither are strictly correct

 

[raskew]

OK -

My misunderstanding. Here's Test2 repeated with Quote markers

Company Name Expr3 SumOfFreight
Alfreds Futterkiste September 1995 $29.46
Alfreds Futterkiste November 1995 $84.96

Not so good. It appears that one space is automatically inserted between each block of text.

Code markers is definitely the way to go.

Thanks again - Bob

 

[boblarson]

Yeah, either code tags or PHP tags should work.

 

[gemma-the-husky]

i thought you could put spaces in quote tags also - obviously not

 

[raskew]

OK -

Test3. Trying with PHP markers:

Company Name        Expr3           SumOfFreight    
Alfreds Futterkiste September 1995  $29.46  
Alfreds Futterkiste November 1995   $84.96

Alright! This worked without any adjustment whatsoever.

Thank you Bob and Gemma!

Bob

P.S. What does PHP stand for? Have never used it up till now.

 

[boblarson]

P.S. What does PHP stand for? Have never used it up till now.

Don't know what it stands for but it is a web based programming language.