Focal Point
exl2k - leading spaces

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9241004202

December 20, 2006, 09:21 AM
Pam Kratt
exl2k - leading spaces
Does anyone know a neat trick to get leading spaces to appear in exl2k? I tried coding:
DEFINE WORD/A20=' ABC'; but it ignores the spaces

I tried using positional markers putting the indented information in subheads, but that didn't work either.

It was suggested to just put some characters like dashes in the front of the words to indent so that is what I've done but it doesn't look pretty. I can't right justify or center because that would look odd also.

Any suggestions?


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
December 20, 2006, 09:47 AM
Prarie
Here's a way to make spaces and then you can use them where ever you want...just make the
SP05 as ' ' so no title appears.

SP/A1 = HEXBYT(160, 'A1');
SP01/A1 = SP;
SP02/A2 = SP|SP;
SP05/A05 = SP|SP|SP|SP|SP;
SP10/A10 = SP05|SP05;
SP15/A15 = SP10|SP05;
SP20/A20 = SP10|SP10;


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 20, 2006, 09:55 AM
susannah
Pam have you tried '&|nbsp;'
works like a charm in html
don't know about exl2k, tho.
Prarie's suggestion may be the only way to go for Excel. Just curious if you've tried the standard html one.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 20, 2006, 10:08 AM
mgrackin
Try the RJUST function:

TABLE FILE CAR
PRINT RCOST DCOST
COMPUTE NEWCNTY/A10=RJUST(10,COUNTRY,NEWCNTY);
BY COUNTRY
ON TABLE PCHOLD FORMAT EXCEL
END


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
December 20, 2006, 10:11 AM
mgrackin
Sorry Pam. I didn't see the part about no Right Justification.

The following works fine for me:

(the compute has 10 spaces in the concate. the post only shows one)

TABLE FILE CAR
PRINT RCOST DCOST
COMPUTE NEWCNTY/A20=' ' | COUNTRY;
BY COUNTRY
ON TABLE PCHOLD FORMAT EXCEL
END


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
December 20, 2006, 10:16 AM
Tony A
Pam,

I would recommend Prairie's solution as the x'160' character is not (or doesn't appear to be) interpreted by WF and is therefore not removed as a leading space.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
December 20, 2006, 10:58 AM
Pam Kratt
Thanks for all the suggestions. Suzannah, I got the following when I tried your suggestion:
  Change Detail Report
instead of spaces. We do that code for HTML so I just copied the code. Excel doesn't seem to like the nbsp.

I tried the 20 spaces as Mickey suggested and it did not work in exl2k but it does work in excel. We're now on exl2k so that wasn't an option.

I actually tried Prairie's suggestion first and it put a funky character on my report. When I went to do it again to show the results on the forum, it worked perfectly. So, I'm going with Prairie's suggestion.

Thanks for all the suggestions.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
December 20, 2006, 11:13 AM
Prarie
Glad it worked...I've been having fights with Excel for a few months...I think I've tried it all.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 20, 2006, 12:28 PM
Pam Kratt
I was wrong. Prairie's suggestion didn't work. It works in excel, but does not work in exl2k.
DEFINE FILE ABC
SP/A1 = HEXBYT(160, 'A1');
SP01/A1 = SP;
SP02/A2 = SP|SP;
EVENTNAME/A50=SP02|EVENTNME;
END

TABLE FILE ABC
SUM CNT.OUTPUT_TYPE AS 'TOTALCNT'
BY EVENTNAME
BY OUTPUT_TYPE
ON TABLE HOLD AS OUTFILE FORMAT EXL2K
END
I don't know if you can see the character or not, but it displays as a box in exl2k.

牋Change Detail Report

Any other suggestions?? Exl2k is supposed to be an improvement so we just converted all our applications over the summer to go to it.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
December 20, 2006, 03:08 PM
Prarie
DEFINE FILE CAR
SP/A1 = HEXBYT(160, 'A1');

SP01/A1 = SP;
SP05/A5 = SP|SP|SP|SP|SP;
EVENTNAME/A50=SP05|CAR;
END

TABLE FILE CAR
SUM CNT.SEATS AS 'TOTALCNT'
BY EVENTNAME

ON TABLE PCHOLD FORMAT EXL2K
END

This worked for me. Wonder if it's your version


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 20, 2006, 03:17 PM
Pam Kratt
that did work on my desktop. I'll have to look into why it won't work on our server. Very interesting.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
December 20, 2006, 04:35 PM
Tony A
Pam,

I tried this locally using Dev Studio (Win XP) server and our W2003 server. Worked as per Prarie on both.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10