I have a layout with fields that are all formatted as Uppercase.

Everytime I export records from this file from this layout some fields are exported formatted as uppercase and others as lowercase. I don

Hi LVA,

Since you haven't updated your profile, I'm not sure which OS and version of FM you are using. Therefore, I'll address my reply as if you are using a Mac and FM 6 or below.

WYSIWYG ?? in this case the "I" stands for isn't

Choosing the text attribute of UPPERCASE to be displayed for your filed in layout mode, doesn't actually change the text in the field to UPPERCASE. It retains the text styles used when the text is entered. However, you can convert the text by replacing it, using the Upper Function. My choice would be to do this using Replace, calculated result available in the menu.

Put your cursor in the field to be changed, hit Cmd =, click on the Specify button and select "Upper(text)", and put your field that you want to change in place of "text", hit okay, and the Replace.

HTH

Lee

Hi -

This is a common problem with database design. By formatting the fields on the layout the user believes that the database will correct however they enter data. Over time they forget to use the Shift key. Then they find, when they export their data it is all wrong and who gets the call. You the developer.

The problem is it takes effort on behalf of the developer to get the data right. See the download on the fusiondzine site "ForMAT Your dATa!!!" (http://www.fusiondzign.com/downloads/downloads.htm)

To guaranteee the data you will want to script the format process. Again, see the demo file "ForMAT Your dATa!!!" for an example of the scripting process.

HTH

Still if you put more data after the replace action, your eported data will not be formated, even if their's Upper calculation on the field?

That is correct in six, you are only replacing the text that existed when you run the replace. If your users continue to mix the text case, then you sould look at other options, such as having calculations for the export, or make a script or upgrade to v8 where you can add a calculation to the field to replace the existing format.

HTH

Lee

Thank you Lee.

I tried to include an

replace field contents with the Upper function

but I end up with the same - no upper case!

I'm confused. Are you saying this isn't working or is working?

Lee

Odds are that you have that field formatted at the field level as TitleCase? Change the text format to Plain and see if it changed for you. If it didn't, you must be sure to place your cursor in the field to change. And be sure to show all records first. :wink2:

So now that you own 8 Advanced, go to definition of your field and set the AutoEnter option "Calculated Value" to this calc:

Upper(YourField)

and be sure to uncheck the "Do not replace..."

Auto-Enter (Replace) works on vs. 7 as well. Agreed - stop all future incorrect entries. :wink2:

My field definition is already set to Auto-enter Calculation replace existing value with Upper(Cie)

When exported as Excel I loose the formating so I tried to include a replace field contents step in my export script but I get the same result, no uppercase. My -Cie- field applies the right formating in FM.

And "Do not replace existing value if field .. is uncheck

Edited May 28, 200619 yr by Guest

That seems impossible...

Can you send your file ?

I Thought I had it with the export options " Apply current layout's data formating to exported data"

But it just don't work.

As for sending my file I'm not really cool with that "No offending" There is many critical information about my customer in it.

Thank you for your offering.

And a clone ?

Thank's a lot guys, I got it!

I'LL explain in 5 minutes after I get the dog out!

Ok when I started the solution I had to make a nested custom function for special formated text.

Somehow I built the same function as Upper and use that custom function for export.

My custom function worked just fine in the data entry!

But not in the export, I don't know why but I just replace my custom function with the Upper default function and everything is formated as it should.

Thank you all for your support.