 | |
Removing extra spaces in records
comp.databases.filemaker comp.databases.filemaker
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Removing extra spaces in records -
05-03-2007
, 12:50 PM
#2
| |||
| |||
|
|
I imported an Excel file into FileMaker and didn't realize that many records had excess trailing spaces. I could have fixed it easily in Excel, but I'm not so confident in FM (8.5 Pro). Is there a simple script or S&R routine that I can implement? Thanks... Rick A. Pleasanton CA |
Trim function?
Matt
#3
| |||
| |||
|
|
On 05/03/2007 13:50:25 "Rick Altman" <rick.a (AT) NOSPAMaltman (DOT) com> wrote: I imported an Excel file into FileMaker and didn't realize that many records had excess trailing spaces. I could have fixed it easily in Excel, but I'm not so confident in FM (8.5 Pro). Is there a simple script or S&R routine that I can implement? Thanks... Rick A. Pleasanton CA Trim function? Matt |
Select the field (theField).
Use Records/Replace Field Contents to replace the existing contents with a calculation:
Trim ( theField ).
This can also be scripted if you need to do it repeatedly.
Matt
#4
| |||
| |||
|
|
On 05/03/2007 15:47:28 Matt Wills <I'm (AT) witz (DOT) end> wrote: On 05/03/2007 13:50:25 "Rick Altman" <rick.a (AT) NOSPAMaltman (DOT) com> wrote: I imported an Excel file into FileMaker and didn't realize that many records had excess trailing spaces. I could have fixed it easily in Excel, but I'm not so confident in FM (8.5 Pro). Is there a simple script or S&R routine that I can implement? Thanks... Rick A. Pleasanton CA Trim function? Matt Sorry. more specifically... Select the field (theField). Use Records/Replace Field Contents to replace the existing contents with a calculation: Trim ( theField ). This can also be scripted if you need to do it repeatedly. |
they type in these extra spaces in the first place. ;o)
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
#5
| |||
| |||
|
|
In article <531557.OSYGPHQJ (AT) news (DOT) verizon.net>, Matt Wills <I'm (AT) witz (DOT) end wrote: On 05/03/2007 15:47:28 Matt Wills <I'm (AT) witz (DOT) end> wrote: On 05/03/2007 13:50:25 "Rick Altman" <rick.a (AT) NOSPAMaltman (DOT) com> wrote: I imported an Excel file into FileMaker and didn't realize that many records had excess trailing spaces. I could have fixed it easily in Excel, but I'm not so confident in FM (8.5 Pro). Is there a simple script or S&R routine that I can implement? Thanks... Rick A. Pleasanton CA Trim function? Matt Sorry. more specifically... Select the field (theField). Use Records/Replace Field Contents to replace the existing contents with a calculation: Trim ( theField ). This can also be scripted if you need to do it repeatedly. It might be better to repeatedly smack users over the head whenever they type in these extra spaces in the first place. ;o) |
M
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.