Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

Text_CaseShift ( myParam )

Convert Text from ANY Selection from ANY Field to Upper Proper Lower Case at ASCII Level (NOT a FileMaker Style)

  Average rating: 3.9 (40 votes) Log in to vote

Joel Englander Joel Englander http://www.asymptotes.com/

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [ /* Convert Text from ANY Selection from ANY Field to Upper or Proper or Lower Case at ASCII Level (NOT a FileMaker Style) or it also remove Format or anything you may add in that custom function (but from ANY Selection from ANY Field) and not only the All in the specify Field */ current_field = Get ( ActiveFieldName ) ; current_table = Get ( ActiveFieldTableName ) & "::" ; current_repetition = Get ( ActiveRepetitionNumber ) ; select_start = Get ( ActiveSelectionStart ) ; select_size= Get ( ActiveSelectionSize ) ; myfield = GetField ( current_table & current_field & "[" & current_repetition & "]" ) ; myfield_name = current_table & current_field & "[" & current_repetition & "]" ; myfield_length = Length ( myfield ) ; text_pre = Middle ( myfield ; 0 ; select_start - 1 ) ; text_select = Middle ( myfield ; select_start ; select_size ) ; text_post_start = select_start + select_size ; text_post = Middle ( myfield ; text_post_start ; myfield_length - text_post_start +1 ) ; text_select~new = Case ( myParam= "Upper" ; Upper ( text_select ) ; myParam = "Proper" ; Proper ( text_select) ; myParam = "Lower" ; Lower ( text_select ) ; myParam = "RemoveFormat" ; TextFormatRemove ( text_select ) ) ; myfield~new = text_pre & text_select~new & text_post ] ; Case ( myParam = "Start" ; select_start ; myParam = "End" ; select_start + select_size - 1 ; myParam = "Name" ; myfield_name ; myfield~new ) ) Click to copy

Convert Text from ANY Selection from ANY Field to Upper or Proper or Lower Case
at ASCII Level (NOT a FileMaker Style)
or it also remove Format
or anything you may add in that custom function
(but from ANY Selection from ANY Field) and not only the All in the specify Field
————————————————————————————————————————
Perform Script [ “Contact : Style : myScript”; Parameter: "Upper" ]
Perform Script [ “Contact : Style : myScript”; Parameter: "Proper" ]
Perform Script [ “Contact : Style : myScript”; Parameter: "Lower" ]
Perform Script [ “Contact : Style : myScript”; Parameter: "RemoveFormat" ]
———————————— Script for FM 10 ———————————————————
Set Variable [ $Select_Start; Value:Text_CaseShift ( "Start" ) ]
Set Variable [ $Select_End; Value:Text_CaseShift ( "End" ) ]
Set Field By Name [ Text_CaseShift ( "Name" ); Text_CaseShift ( Get ( ScriptParameter ) ) ]
Set Selection [ Start Position: $Select_Start; End Position: $Select_End ]
———————————Script for FM 7+8+8.5+9————————————————
Set Variable [ $Select_Start; Value:Text_CaseShift ( "Start" ) ]
Set Variable [ $Select_End; Value:Text_CaseShift ( "End" ) ]
Set Field [ Text_CaseShift ( Get ( ScriptParameter ) ) ]
Set Selection [ Start Position: $Select_Start; End Position: $Select_End ]
————————————————————————————————————————

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: