4 Replies Latest reply on May 7, 2012 4:10 PM by NikkiSidhu

    Ectopic Values when Exported

    NikkiSidhu

      Title

      Ectopic Values when Exported

      Post

      Hello, I'm wondering if someone can help me with this...

      I have a data set that I had previously recorded. 

      Recently, for a checkbox field, I changed the values from "O-Yes" and "1-No" to "0-No" "1-Yes". I went back and adjusted the values for the data that had already been entered. 

      The problem is that now, when I export my data to excell, these values show up as "10", and NOT the 1 or 0 they should. I don't have this problem for any new data I enter. 

      This is a 500+ entry database so I'd really like to not have to delete and re-enter data. Is there a way around doing that? 

       

      Thank you!!!

        • 1. Re: Ectopic Values when Exported
          philmodjunk

          I went back and adjusted the values for the data that had already been entered.

          How did you do that? Sounds like you changed the value list, then clicked the appropriate check box.

          I suggest pulling up these older records in FileMaker, then using a copy of this field, but formatted as an edit box to see the actual data present in the field. Do you get a 1 on one line and a zero on the next inside the field? Do you see some fields as 10 and others as 01, with the first digit the original value and the second digit the correct value?

          Once you can determine the actual state of the data stored in your field, we can set up a replace field contents batch operation that cleans up your data so that it exports correctly.

          • 2. Re: Ectopic Values when Exported
            NikkiSidhu

            Thanks, Phil. 

             

            I've went ahead and done this and you are right. How would I be able to do a replace field contents batch operation? 

             

            Thank you

            • 3. Re: Ectopic Values when Exported
              philmodjunk
              1. Put an edit box formatted copy of this field on a layout based on the table in which it was defined.
              2. Make a copy of your database. Replace Field contents can modify up to every record in a given table and cannot be undone.
              3. Examine your data to determine what is supposed to be in this field. If you see 10 and it should be 0, Perform a find for all records that have 10 in this field.
              4. Edit this field on one record to give it the correct value (0) and leave the cursor in the field.
              5. Select Replace Field Contents and use the current value option to update all the other records in your found set to have the same value.
              6. Repeat for each different value that needs to be changed.
              • 4. Re: Ectopic Values when Exported
                NikkiSidhu

                perfect. thank you!