Export is Changing Comma placement in Numbers

  • Resolved thoseguys26

    (@thoseguys26)


    9 years ago

    We have an event with 5 digit ticket numbers. Some people input multiple tickets #####, #####, ##### and others don’t use a comma they just use a space ##### #####. For some reason, certain data, once exported and opened in Excel the number format is changed to a single amount with comma’s to the thousands.
    Example:
    input: 12345, 67891
    Output: 1,234,567,891

    Form Code is:

    [text* TicketNumbers id:TicketNumber placeholder “xxxx, xxxx, xxxx”]

    This is capturing from Contact Form 7.

    We have hundreds of entries and there seems to be no pattern to which entries get changed during export but there are a lot!

    Any help would be greatly appreciated!

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    CFDB just saves what CF7 gives it. I assume the values you see in the CFDB dashboard page are the same as those in the email that CF7 generates after a form is submitted. If you think the pattern should be enforced, then that is a CF7 issue, not a CFDB issue.

    As for the export, CFDB is just copying the values in a CSV file without changing them. Excel is trying to be smart and interpret the values with commas as one number. After you open the file, you might try formatting such columns as “Text” and Excel may show you the actual text values that are in the file.

    As the saying goes, garbage in, garbage out.

    Thread Starter thoseguys26

    (@thoseguys26)

    Thank you for the reply Michael. I will see if excel can correct them or I’ll just do them manually..

    They look fine in CFDB until I export them, that’s what’s strange.

    Thread Starter thoseguys26

    (@thoseguys26)

    Thanks

    Plugin Author Michael Simpson

    (@msimpson)

    If you open the exported .csv file in a text editor then you can see exactly what Excel is reading in.

    Thread Starter thoseguys26

    (@thoseguys26)

    I did as followed and text edit showed no commas at all just all numbers.

    Thread Starter thoseguys26

    (@thoseguys26)

    Sorry that is incorrect. I exported a .csv and opened it in text edit and the numbers look good. Excel must be messing it up some how.

    I’ll keep you posted on what I figure out in case another person has a similar issue as mine.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Export is Changing Comma placement in Numbers’ is closed to new replies.