How do I fix ALL CAPS names in my PSPA database or Panel Pages?
Unfortunately, these are not easily fixed within any of our software offerings. However (!) this is very easy to fix in your index.txt file prior to importing it.
Open your Index.txt file in Excel
Identify the First and Last name columns (in this case E and F) and then click on an empty cell in row 1 (
Use the PROPER() formula to change text to Proper case” title_margin_divider=”true” title_margin_css=”margin-bottom:5px;” content_font_preset=”mpc_preset_1″ content_font_color=”#334559″ content_font_size=”14″ content_font_line_height=”1.5″ content_font_align=”left” mpc_icon__icon_type=”character” mpc_icon__icon_preset=”preset_0″ mpc_icon__icon_character=”3″ mpc_icon__icon_color=”#334559″ mpc_icon__icon_size=”20″ mpc_icon__background_color=”#ffffff” mpc_icon__border_css=”border-radius:0px;” mpc_icon__padding_divider=”true” mpc_icon__padding_css=”padding-top:5px;padding-right:5px;padding-bottom:5px;padding-left:5px;” mpc_icon__margin_divider=”true” mpc_icon__margin_css=”margin-top:-6px;margin-right:15px;” mpc_icon__hover_icon_color=”#ffffff” mpc_icon__hover_background_color=”#275a7a” mpc_icon__hover_border_css=”border-radius:20px;” mpc_divider__disable=”false” mpc_divider__width=”10″ mpc_divider__align=”left” mpc_divider__content_padding_divider=”true” mpc_divider__content_padding_css=”padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;” mpc_divider__lines_color=”#dddddd” mpc_divider__padding_divider=”true” mpc_divider__padding_css=”padding-top:3px;padding-bottom:3px;” hover_padding_css=”padding:0px;”]In L1, use the Excel function =Proper() to convert the text from E1 into proper case.
[/mpc_icon_column][mpc_icon_column layout=”style_3″ alignment=”left” background_color=”#ffffff” padding_css=”padding:0px;” margin_divider=”true” title_font_preset=”mpc_preset_20″ title_font_color=”#f58020″ title_font_size=”17″ title_font_line_height=”1.4″ title_font_transform=”uppercase” title_font_align=”left” title=”Use the handle to replicate the formula” title_margin_divider=”true” title_margin_css=”margin-bottom:5px;” content_font_preset=”mpc_preset_1″ content_font_color=”#334559″ content_font_size=”14″ content_font_line_height=”1.5″ content_font_align=”left” mpc_icon__icon_type=”character” mpc_icon__icon_preset=”preset_0″ mpc_icon__icon_character=”4″ mpc_icon__icon_color=”#334559″ mpc_icon__icon_size=”20″ mpc_icon__background_color=”#ffffff” mpc_icon__border_css=”border-radius:0px;” mpc_icon__padding_divider=”true” mpc_icon__padding_css=”padding-top:5px;padding-right:5px;padding-bottom:5px;padding-left:5px;” mpc_icon__margin_divider=”true” mpc_icon__margin_css=”margin-top:-6px;margin-right:15px;” mpc_icon__hover_icon_color=”#ffffff” mpc_icon__hover_background_color=”#275a7a” mpc_icon__hover_border_css=”border-radius:20px;” mpc_divider__disable=”false” mpc_divider__width=”10″ mpc_divider__align=”left” mpc_divider__content_padding_divider=”true” mpc_divider__content_padding_css=”padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;” mpc_divider__lines_color=”#dddddd” mpc_divider__padding_divider=”true” mpc_divider__padding_css=”padding-top:3px;padding-bottom:3px;” hover_padding_css=”padding:0px;”]Click and drag the handle in the lower right corner of L1 and drag to select Columns L and M all the way down to the last record in your database. When you let go, excel will replicate the =PROPER() formula for each of the selected cells
[/mpc_icon_column][mpc_icon_column layout=”style_3″ alignment=”left” background_color=”#ffffff” padding_css=”padding:0px;” margin_divider=”true” title_font_preset=”mpc_preset_20″ title_font_color=”#f58020″ title_font_size=”17″ title_font_line_height=”1.4″ title_font_transform=”uppercase” title_font_align=”left” title=”Copy the new values” title_margin_divider=”true” title_margin_css=”margin-bottom:5px;” content_font_preset=”mpc_preset_1″ content_font_color=”#334559″ content_font_size=”14″ content_font_line_height=”1.5″ content_font_align=”left” mpc_icon__icon_type=”character” mpc_icon__icon_preset=”preset_0″ mpc_icon__icon_character=”5″ mpc_icon__icon_color=”#334559″ mpc_icon__icon_size=”20″ mpc_icon__background_color=”#ffffff” mpc_icon__border_css=”border-radius:0px;” mpc_icon__padding_divider=”true” mpc_icon__padding_css=”padding-top:5px;padding-right:5px;padding-bottom:5px;padding-left:5px;” mpc_icon__margin_divider=”true” mpc_icon__margin_css=”margin-top:-6px;margin-right:15px;” mpc_icon__hover_icon_color=”#ffffff” mpc_icon__hover_background_color=”#275a7a” mpc_icon__hover_border_css=”border-radius:20px;” mpc_divider__disable=”false” mpc_divider__width=”10″ mpc_divider__align=”left” mpc_divider__content_padding_divider=”true” mpc_divider__content_padding_css=”padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;” mpc_divider__lines_color=”#dddddd” mpc_divider__padding_divider=”true” mpc_divider__padding_css=”padding-top:3px;padding-bottom:3px;” hover_padding_css=”padding:0px;”]Click and drag on the headers for columns L and M to select both entire columns. Right click and Copy.
[/mpc_icon_column][mpc_icon_column layout=”style_3″ alignment=”left” background_color=”#ffffff” padding_css=”padding:0px;” margin_divider=”true” title_font_preset=”mpc_preset_20″ title_font_color=”#f58020″ title_font_size=”17″ title_font_line_height=”1.4″ title_font_transform=”uppercase” title_font_align=”left” title=”“Paste Special“ the new values into original columns” title_margin_divider=”true” title_margin_css=”margin-bottom:5px;” content_font_preset=”mpc_preset_1″ content_font_color=”#334559″ content_font_size=”14″ content_font_line_height=”1.5″ content_font_align=”left” mpc_icon__icon_type=”character” mpc_icon__icon_preset=”preset_0″ mpc_icon__icon_character=”6″ mpc_icon__icon_color=”#334559″ mpc_icon__icon_size=”20″ mpc_icon__background_color=”#ffffff” mpc_icon__border_css=”border-radius:0px;” mpc_icon__padding_divider=”true” mpc_icon__padding_css=”padding-top:5px;padding-right:5px;padding-bottom:5px;padding-left:5px;” mpc_icon__margin_divider=”true” mpc_icon__margin_css=”margin-top:-6px;margin-right:15px;” mpc_icon__hover_icon_color=”#ffffff” mpc_icon__hover_background_color=”#275a7a” mpc_icon__hover_border_css=”border-radius:20px;” mpc_divider__disable=”false” mpc_divider__width=”10″ mpc_divider__align=”left” mpc_divider__content_padding_divider=”true” mpc_divider__content_padding_css=”padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;” mpc_divider__lines_color=”#dddddd” mpc_divider__padding_divider=”true” mpc_divider__padding_css=”padding-top:3px;padding-bottom:3px;” hover_padding_css=”padding:0px;”]Select the columns where your original, mis-capitalized names appear (E and F in our example). Use “Paste Special” to paste the Values ONLY from the last step into these columns. Once you have done this, you can delete columns L & M.
[/mpc_icon_column][mpc_icon_column layout=”style_3″ alignment=”left” background_color=”#ffffff” padding_css=”padding:0px;” margin_divider=”true” title_font_preset=”mpc_preset_20″ title_font_color=”#f58020″ title_font_size=”17″ title_font_line_height=”1.4″ title_font_transform=”uppercase” title_font_align=”left” title=”Save as to save your work” title_margin_divider=”true” title_margin_css=”margin-bottom:5px;” content_font_preset=”mpc_preset_1″ content_font_color=”#334559″ content_font_size=”14″ content_font_line_height=”1.5″ content_font_align=”left” mpc_icon__icon_type=”character” mpc_icon__icon_preset=”preset_0″ mpc_icon__icon_character=”7″ mpc_icon__icon_color=”#334559″ mpc_icon__icon_size=”20″ mpc_icon__background_color=”#ffffff” mpc_icon__border_css=”border-radius:0px;” mpc_icon__padding_divider=”true” mpc_icon__padding_css=”padding-top:5px;padding-right:5px;padding-bottom:5px;padding-left:5px;” mpc_icon__margin_divider=”true” mpc_icon__margin_css=”margin-top:-6px;margin-right:15px;” mpc_icon__hover_icon_color=”#ffffff” mpc_icon__hover_background_color=”#275a7a” mpc_icon__hover_border_css=”border-radius:20px;” mpc_divider__disable=”false” mpc_divider__width=”10″ mpc_divider__align=”left” mpc_divider__content_padding_divider=”true” mpc_divider__content_padding_css=”padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;” mpc_divider__lines_color=”#dddddd” mpc_divider__padding_divider=”true” mpc_divider__padding_css=”padding-top:3px;padding-bottom:3px;” hover_padding_css=”padding:0px;”]Go to File > Save As… and save your file in .txt format in the same folder as your original index.txt file. Mac Users: make sure to select a “Windows Formatted Text (.txt)” file. Pixami Users: Your file must be named index.txt, so you will have to save over the original txt file. All Users: When warned that “This workbook contains features that will not work or may be removed….” click continue.
[/mpc_icon_column][mpc_icon_column layout=”style_3″ alignment=”left” background_color=”#ffffff” padding_css=”padding:0px;” margin_divider=”true” title_font_preset=”mpc_preset_20″ title_font_color=”#f58020″ title_font_size=”17″ title_font_line_height=”1.4″ title_font_transform=”uppercase” title_font_align=”left” title=”Your new index.txt is ready to import!” title_margin_divider=”true” title_margin_css=”margin-bottom:5px;” content_font_preset=”mpc_preset_1″ content_font_color=”#334559″ content_font_size=”14″ content_font_line_height=”1.5″ content_font_align=”left” mpc_icon__icon_type=”character” mpc_icon__icon_preset=”preset_0″ mpc_icon__icon_character=”8″ mpc_icon__icon_color=”#334559″ mpc_icon__icon_size=”20″ mpc_icon__background_color=”#ffffff” mpc_icon__border_css=”border-radius:0px;” mpc_icon__padding_divider=”true” mpc_icon__padding_css=”padding-top:5px;padding-right:5px;padding-bottom:5px;padding-left:5px;” mpc_icon__margin_divider=”true” mpc_icon__margin_css=”margin-top:-6px;margin-right:15px;” mpc_icon__hover_icon_color=”#ffffff” mpc_icon__hover_background_color=”#275a7a” mpc_icon__hover_border_css=”border-radius:20px;” mpc_divider__disable=”false” mpc_divider__width=”10″ mpc_divider__align=”left” mpc_divider__content_padding_divider=”true” mpc_divider__content_padding_css=”padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;” mpc_divider__lines_color=”#dddddd” mpc_divider__padding_divider=”true” mpc_divider__padding_css=”padding-top:3px;padding-bottom:3px;” hover_padding_css=”padding:0px;”][/mpc_icon_column][/mpc_connected_icons][vc_empty_space][/vc_column][/vc_row]