Jump to content

Capital letter field becomes small letters in export


Sean O'Donoghue
 Share

This topic is 7228 days old. Please don't post here. Open a new topic instead.

Recommended Posts

There's a difference between what you see, and what's there. smile.gif" border="0

For the field in question: has the Style of it been formatted to UPPERCASE?

If not, and what you've entered was indeed ALLCAPS, then I am stumped too.

If so, then the following will hopefully clarify, but sadly not help. frown.gif" border="0

Even when you enter or type lowercase letters upon data entry, it will show up as Uppercase in the field if you've formatted that field (in that layout) to do so. There is a difference between what you've entered, and what you see.

The Style functions are very handy for various modes of Output (email, printing, lists, reports, etc.), but do not work too well for Exporting (into a Tab delimited file for instance).

When Exporting, FMP tends to stick to the basics -- which is usually good, but not in your case.

There is a 'Format Output Using Current Layout' option when you Export, but I've never seen it work.

I have not been able to run a script that will automatically reset the field to be true ALLCAPS, but maybe someone else can help out here.

Otherwise, you will need to reset the fields manually -- or of course utilize a format function in the system you will eventually be importing the data. This is what I usually do. the data just needs to be correct, the formatting of it is taken care of in the environment it ends up in.

HTH

Link to comment
Share on other sites

quote:

Originally posted by Sharka:

I have not been able to run a script that will automatically reset the field to be true ALLCAPS, but maybe someone else can help out here.

FieldName = Upper(FieldName) would do the trick, although you may want to define another field, say, FieldName_UpperCase and simply export its contents instead. This way you're not messing around with your original data.

e.g.

FieldName_UpperCase(unstored, text) =Upper(FieldName)

Hope this helps!

Link to comment
Share on other sites

Thanks both for your responses

Sharka - I have the field automaticall capitalised

The Bridges - sounds simple but afraid I do not get it - I am very much a beginner at Filemaker.

The field I want to create as capitals for exporting is an "Author" field - as it is at the moment, everything, including first letter are exporting as small letters - are you suggesting I create a script to do what you say or just a calculated field - which I tried unsuccessfully to do.

Thanks for your help

Sean O'Donoghue

Link to comment
Share on other sites

quote:

Originally posted by Sean O'Donoghue:

The field I want to create as capitals for exporting is an "Author" field - as it is at the moment, everything, including first letter are exporting as small letters - are you suggesting I create a script to do what you say or just a calculated field - which I tried unsuccessfully to do.

Okay, so working with what you've told me, let's say you have a text field called Author. Now define a new field called Author_Uppercase. Make it a calculation field. The calculation you want to enter is:

code:


Upper(Author)

Make sure Calculation Result is Text.

Click on Storage Options... and make sure that Do Not Store Calculation Results -- Calculate Only When Needed has a check beside it.

When you export your records, do not export the Author field; export the Author_Uppercase field instead.

Hope this is more clear!

Link to comment
Share on other sites

Exporting with export the EXACT data just as it was entered without any formatting information and in whatever the system considers the default font.

So if you typed in "albert einstein" and set your layouts to format it as "Albert Einstein", exporting will give you "albert einstein".

You can select the "Format Output Using Current Layout" option in your export dialog box and that should format number, date and time fields as they appear on the current layout screen. However text fields are left alone.

The best bet is to deal with the data formatting in your destination application or to fix the data entry.

Link to comment
Share on other sites

My pleasure, Sean!

As CaptKurt suggested, the calculation I gave you will not "fix" the data that has already been entered as lowercase. I suggested creating a new field only so that you wouldn't be messing around with your original data. If you wanted to convert all existing data in the Author field, you could create a looping script that would perform the calculation I gave you on the Author field itself. Another option would be the Replace... command, again with the same calculation. To make sure users entered only uppercase names in the Author field, you could set validation based on the same calculation. This is, of course, when you're adventurous enough to overwrite your existing data... make a backup first! smile.gif" border="0

Link to comment
Share on other sites

This topic is 7228 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.