Capitalize all data for database import

  • Profile Image
    ricardostartit
    Asked on January 15, 2018 at 04:32 PM
    Eu preciso das minhas informações de DATABASE EM CAPS. Eu não me importo com o que parece no formulário ou no que parece no e-mail que vem para mim. Eu só me importo que seja TODOS OS CAPS no banco de dados real csv ou excel que é baixado.Há alguma maneira de fazer isso?Agora eu tenho que baixar o banco de dados e corrigir tudo e, em seguida, importá-lo para o software que eu preciso.

     

  • Profile Image
    EltonCris
    Answered on January 15, 2018 at 05:29 PM

    Unfortunately, it is not possible to change the casing in the submissions page unless the submitted data are already in upper casing.

    The workaround is to automatically capitalize all the letters submitted by the user. That is only possible when you implement casing function in your form source code by using custom scripts. Here's how to take your form source code http://www.jotform.com/help/104-How-to-Download-a-Source-Code-of-your-Form.

    Or, you can stay with what you did, download the submissions to excel, change the casing before uploading it to our database. This is pretty much the easiest way around since you can quickly change the text casing in Excel application. You can also use Macros in Excel to automatically capitalize all text.

    Sub Upper() 

    Dim Cell As Range 

    Application.ScreenUpdating = False 

            For Each Cell In Selection 

                 Cell.Formula = UCase(Cell.Formula) 

        Next 

    Application.ScreenUpdating = True 

    End Sub