LaRetta Posted March 30, 2014 Posted March 30, 2014 If I have a field which contains: MP1-01, TV-01, TV-02, TV-03, TV-04 it sometimes, because it breaks at the end of the page, looks as this: MP1-01, TV-01, TV-02, TV-03, TV- 04 It seems there was a shift/key combination on Windows which inserted a space which stopped the break; I forget what it is called now so I can't even look it up. Is there a way of doing the same thing with the dash? It would need to be turned into a word character which isn't used much but this is for display so ... Whatever that key-combination, use Substitute ( field ; "-" ; " - " ) ... where the spaces are actually that key combination. Ah well, it's late. Oh, actually it's 4:30 am, time to stop. Time flies when having fun! I searched for the name of this invisible connector going on two hours. I throw myself on the mercy of the forum. BTW, these are normalised, separate values which have been concatenated in a calculation and I'm just trying to make the list easier for Users to read on the job.
LaRetta Posted March 30, 2014 Author Posted March 30, 2014 - - - please respond to this thread and not the others - - - system winked out and now I have no delete button to delete my dups. We will clean it up later. - - -
LaRetta Posted March 30, 2014 Author Posted March 30, 2014 Non-breaking space! It just came to me! So something like: Let ( break = " " ; Substitute ( text ; "-" ; break & "-" & break ) ) Option-spacebar. It works!
LaRetta Posted March 30, 2014 Author Posted March 30, 2014 Well, that leaves spaces. Probably simpler just to replace the dash with the tilde which achieves the same thing and looks almost the same except possibly a bit wiggly..
LaRetta Posted March 30, 2014 Author Posted March 30, 2014 Ah, that's perfect - a great thing to wake up to! None-breaking hyphen ... what will they think of next? You rock!
LaRetta Posted April 22, 2014 Author Posted April 22, 2014 (edited) FMPA13.0v2 Â Attached is a screenshot using this non-break hyphen. Â When the file is opened on Mac (Maverick) it works perfectly as first image. Â However, when opened on Windows 7, the second image is the result ... notice the extra space after the dash. Â Is there any alternative character? Â The only other thing I can think of is to have someone on windows copy the non-break dash right into text or calculation for me (my Windows system is not yet updated). Â Added: Â The third image is how it properly adjusts on Maverick when there are several lines. Â Â I have been searching and I can't find any other character other than 8209 but I thought maybe someone else might have ideas. Edited April 22, 2014 by LaRetta
comment Posted April 22, 2014 Posted April 22, 2014 Have you tried switching to another font? The only other thing I can think of is to have someone on windows copy the non-break dash right into text or calculation for me (my Windows system is not yet updated). Not sure how that would help. There should be no difference between using Char (8209) and inserting the actual character between quotes in a calculation formula.
LaRetta Posted April 26, 2014 Author Posted April 26, 2014 Hi Michael! The client tried Arial, Times New Roman and Tahoma. Unfortunately, all produced the space after the dash. I appreciate the idea. I was thinking that if Microsoft Word generated a non-break dash and it was placed between quotes that it might be a different html code or at least Windows would *see* it since it came from a Microsoft product. I realised it was major WAG. I do not know if this breaks always or whether it only breaks in this calculation. Could someone on Windows open the attached and see if they get a space after the dash on the calculation? Possibly, something else in the original calculation is causing the failure or possibly it is because it was a v11 file which was converted to 13. TestHyphen.fmp12.zip
Josh Ormond Posted April 27, 2014 Posted April 27, 2014 Tested in 12 and 13, Windows 8.1. I am also seeing the expanded space after the non breaking hyphen. Oddly, at 100% the character doesn't render and I get the unrendered box. At any other zoom level, it shows as a hypen-space.
Charity Posted April 28, 2014 Posted April 28, 2014 I get the space after the dash too. I tried creating it in Word and pasting in but I get same thing.
comment Posted April 28, 2014 Posted April 28, 2014 The client tried Arial, Times New Roman and Tahoma. Admittedly clutching at straws, but how about Arial Unicode?
LaRetta Posted May 15, 2014 Author Posted May 15, 2014 Hi Josh - Charity! Thank you so much for testing this for me. I will report it. Hi Michael! I just heard back from the client and that does not work either, unfortunately. Thank you for trying anyway. :-)
LaRetta Posted May 15, 2014 Author Posted May 15, 2014 I posted this issue on FMI's Report An Issue forum here: http://forums.filemaker.com/posts/8ebd9bd484?commentId=290504#290504 And they have already responded.
Recommended Posts
This topic is 3902 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now