A couple of things to check:
- What formatting (if any) is applied to the source text field on the layout you are looking at?
- Is there an Auto-Enter Calculation (replace existing content) that formats the content to UPPER CASE?
- Which application is the text being pasted from?
- Have you tried hitting ctrl-Z (Win)/cmd-z (Mac) immediately after pasting to remove existing formatting from the pasted text?
1. The source text field "input Method" = Automatic. It appears correctly in the source field when viewing it, just not when using it in a calc.
3. MS Word (windows) I think???
4. I actually want to retain the formatting, undo removes the formatting.
Note, if I type the text over the existing text, it appears fine.
Take a look at the enclosed screen snap shot. You can see the first two characters are UPPER case, because the rest of the text I have typed in, but prior to me typing over the existing text, it was all UPPER case. The tooltip is showing "Self", but a calc field displays the same thing.
Well, then, I got nuthin'!
Something odd with that text chunk... in FileMaker, it appears title case, which is the same as all other text put into that field (except when I use it in a calc)... however, when I copy and paste the text out of that field into Word, guess what... it's UPPER case... yippie. So I am now going to ask for the source text. Perhaps the text is formatted in word using Styles, rather than actuall text formatting??
Not sure that Styles makes a difference - all the Styles functions do is apply pre-set combinations of text formatting.
However, it still sounds like there is some Word weirdness going on. From your comments, I take it you are not on site with the users. Once you get the source document, it would be interesting to see what you get when you paste into other applications.
Another option that has just sprung to mind: is the text in Word formatted in Small Caps? Maybe the transition to FileMaker is making a mess of that.
yes, you are correct, I am not on site with the client, I have requested the original document, I will investigate
If it were me I don't think I'd be trusting any Word formatting. My approach would be to use an auto replace by calculation utilising the Self function to replace whatever text is imported with a formatted version of itself. That way you can apply your desired formatting and control it within FileMaker.
Ah yes, but there ilies the problem...
I want to retain all formatting (bold, italics etc), except I don't want UPPER case, which is kind of tricky, because what would I use to correct it?
Proper? That's not going to work, because there are company names in the text like iCloud. Small i, big C.
Essentially what I mean is decide what formatting you want and apply that but …
It sounds like you are wanting to format at a word by word level, and that will defy any logical option to automate it because it will vary from one paste to the next. Bummer!
No worries, the data is only as good as the source. Clean the source and the result will be ok.