Re: FileMaker Pro 9 OS X Defining text fields and numerical fields to aviod the quote in the fields to avoid it from exporting out to an Excel Spread*** or Text File.


"Lee39" <sargenkenospammin@xxxxxxxxxxx> schreef in bericht
news:260920071700075727%sargenkenospammin@xxxxxxxxxxxxxx
I have been reading the help files in FileMaker Pro 9 about Text
formats but have yet to find my solution, perhaps there is not one or
it is a formula that is beyond my scope at this time.

I have fields that are strictly numbers and the fields have been
defined for numbers and I have no " around the text.

I have field I have defined as text for it is a mix of text and number
or text and non text characters such as / or ? or . or , or * and the
like and they get " " in the field. I want to prevent that.

How do I do this where none of my input gets the open and closing
double quotes and is just standard text and numerical and non
alphanumerical characters without double quotes.

How do I define the fields so I don't get these quotes?

I export to Excel and then I have to remove the quotes, I use BBEdit
but we are talking large columns of data several column wide that have
to be copied and pasted into BBEdit then have the quoted removed.

Lee38

Try switching between tab and csv delimited

Keep well, Ursus


.

Quantcast