Problem with FMP4.1 for windows 
Author Message
 Problem with FMP4.1 for windows

Pt1: how do you get rid of any hidden formatting that may be stored in a
field?
Basically, I imported 40,000 records or so from Excel. Whoever was
keeping the database in Excel used various techniques for colour coding
etc...
The thing is, after the import the colour coding and various font sizes
used have seemed to stick with the records. I was under the impression
that any formatting in FMP was generated in real time according to the
formats specified on the layout, not stored with that field in that
record.
Basically on one layout, there is a troublesome record whose details
come through in 10pt font, the rest all come through in 8pt (the one set
with the field in layout mode). How do i stop this?

Pt2: secondly, on exporting to excel (via both dbf and csv formats),
some records (seems to be those that had multiple related records below
them in the relationship hierarchy) have a square   at the end of them.
I've tried find and replace but it isn't any of the alt+0xxx numbers for
arial font. When I copy the character to the clipboard and paste it into
the Excel 97 find dialog however, it comes through as a space. How can I
get rid of these without going through 10000 exported records one by
one. therefore how do I get rid of this in filemaker so they are not
exported like this again in the future?

all answers would be appreciated - could you cc: to my email address as
well?
thanks loads,

--
Ben Bradley UK
http://www.***.com/



Tue, 19 Aug 2003 00:54:24 GMT
 Problem with FMP4.1 for windows

For the first question, field formatting, Set Field or Replace will restore
the layout formatting, whereas Paste maintains imported formatting. Replace
reaquires the field be on on the layout; Set Field requires a loop.

For Replace, simply select the field and chooses Replace from the Record
menu, and then choose "Replace with calculated result", and then choose the
field itself.

For Set Field:

Find All
Go to Record/Request/Page[First]
Set Field["Your_Field", "Your_Field"]
Loop
   Go to Record/Request/Page[Exit After Last, Next]
   Set Field["Your_Field", "Your_Field"]
End Loop

For the space character, it's not clear to me if you are trying to parse the
text in Excel or in Filemaker. For Text parsing in Filemaker, use the
various Text functions to edit out unwanted characters.

If the space is at one end or the other, consistently, of the string, you
can use the Replace script step and Trim function to shorten the string:

Replace("Your_Field", "Trim(Your_Field)").

If the space occurs within the middle of the string, consistently, you can
use the Middle function, along with Replace (as above).

If the space occurs inconsistently, you can use the Substitute function,
along with Replace, (as above).

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> Pt1: how do you get rid of any hidden formatting that may be stored in a
> field?
> Basically, I imported 40,000 records or so from Excel. Whoever was
> keeping the database in Excel used various techniques for colour coding
> etc...
> The thing is, after the import the colour coding and various font sizes
> used have seemed to stick with the records. I was under the impression
> that any formatting in FMP was generated in real time according to the
> formats specified on the layout, not stored with that field in that
> record.
> Basically on one layout, there is a troublesome record whose details
> come through in 10pt font, the rest all come through in 8pt (the one set
> with the field in layout mode). How do i stop this?

> Pt2: secondly, on exporting to excel (via both dbf and csv formats),
> some records (seems to be those that had multiple related records below
> them in the relationship hierarchy) have a square   at the end of them.
> I've tried find and replace but it isn't any of the alt+0xxx numbers for
> arial font. When I copy the character to the clipboard and paste it into
> the Excel 97 find dialog however, it comes through as a space. How can I
> get rid of these without going through 10000 exported records one by
> one. therefore how do I get rid of this in filemaker so they are not
> exported like this again in the future?

> all answers would be appreciated - could you cc: to my email address as
> well?
> thanks loads,

> --
> Ben Bradley UK
> http://www.thenetzone.co.uk



Tue, 19 Aug 2003 01:26:10 GMT
 Problem with FMP4.1 for windows
Well, Ben. the   is probably a soft return. I don't have FM with me here,
but I believe it's the Ascii character of 10

--
****************************************************************************
********************************
Deskside Guru - The definition of Just in Time Training
Providing live, customized on-demand training to the world.

****************************************************************************
********************************


Quote:
> Pt1: how do you get rid of any hidden formatting that may be stored in a
> field?
> Basically, I imported 40,000 records or so from Excel. Whoever was
> keeping the database in Excel used various techniques for colour coding
> etc...
> The thing is, after the import the colour coding and various font sizes
> used have seemed to stick with the records. I was under the impression
> that any formatting in FMP was generated in real time according to the
> formats specified on the layout, not stored with that field in that
> record.
> Basically on one layout, there is a troublesome record whose details
> come through in 10pt font, the rest all come through in 8pt (the one set
> with the field in layout mode). How do i stop this?

> Pt2: secondly, on exporting to excel (via both dbf and csv formats),
> some records (seems to be those that had multiple related records below
> them in the relationship hierarchy) have a square   at the end of them.
> I've tried find and replace but it isn't any of the alt+0xxx numbers for
> arial font. When I copy the character to the clipboard and paste it into
> the Excel 97 find dialog however, it comes through as a space. How can I
> get rid of these without going through 10000 exported records one by
> one. therefore how do I get rid of this in filemaker so they are not
> exported like this again in the future?

> all answers would be appreciated - could you cc: to my email address as
> well?
> thanks loads,

> --
> Ben Bradley UK
> http://www.thenetzone.co.uk



Tue, 19 Aug 2003 01:43:59 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Windows 98 Dial-up and FMP4/5

2. Converting FMP4 from Windows to Macintosh

3. Quick FMP4 Question (Windows 98)

4. Security Problem FMP4.1?

5. FMP4 Menu Bar problem

6. Show Window / Hide Window / Zoom Window problems

7. chinese Character problem on Oracle, windows 98 and windows 2000

8. paradox 7 for Windows 95 and Windows NT - nothing but problems

9. Problem with Windows NT and Paradox for Windows 4.5

10. Windows 95/Windows 3.1 compilation problems

11. 4D for Windows v3.50c and Window pos problem (Win95)

12. Problems with ViaDuct for Windows on Windows 95


 
Powered by phpBB® Forum Software