Try either the Trim() or TrimAll() functions
Maybe you ca use the Substitute fonction like this :
Substitute([YourField] ; " " ; "")
Hi kvalley and jml
Thank you for your replies, the problem is that i don't know how many characters there will be used i only know the maxium number, for instance Name is max 25 characters. But when the first records contains J Doe and the second record contains BR van Wilder the records would read like this where ^ reads as a space.
And Record 2:
I think i will have to loop where there is a count for how many spaces there used and then trim, substitue of read with left, right and middle but don't know how
How about this;
if(trim(Intials) = ""; "" ; trim(Intials) & " ") &
if(trim(Prefix) = ""; "" ; trim(Prefix) & " ") &
if(trim(Name) = ""; "" ; trim(Name) & " ") &
Ruben van den Boogaard
1 of 1 people found this helpful
If you use a function like substitute you don't have to know how many spaces are existing,
Substitute(YouField ; " " ; "") will replace every spaces (" ") by nothing.
^^^^^J^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Doe => JDOE
You don't even need to use any loop if your records are already imported in FM.
You just have to select all records click in the right field then use the replace option in "Records" menu to apply Subsitute fonction (hope is the good name in english, this menu is named "Enregistrements" in French localized version) .
Use TrimAll(Name, 0, 0)
This should yield "J Doe", "BR van Wilder"
Thanks you for your quick replies, obvisously i was thinking far to difficult haha, thanks for the help.
This will work...
Substitute ( List ( Trim ( Initials ) ; Trim ( Prefix ) ; Trim ( Name ) ) ; "¶" ; " " )
Hi David thanks for you reply!