Importing Data with decimals

  • Resolved gtexeira

    (@gtexeira)


    7 years, 2 months ago

    Is it possible to import data containing values with decimals points?

    For example, having a file containing, 23.28,25.17

    • This topic was modified 7 years, 2 months ago by gtexeira.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 2 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Yes, that should not be a problem, TablePress does care about the used decimal separator at all. Are you having trouble with this? Have you tried the CSV import format?

    Regards,
    Tobias

    Thread Starter gtexeira

    (@gtexeira)

    7 years, 2 months ago

    When I import a CSV file containing just 23.28, the table shows 2 columns (A and B) instead of just A

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 2 months ago

    Hi,

    and in those columns, the value is 23 and 28, respectively? I guess the script is recognizing the . as the CSV separator then.

    One way around this might be to either add another (dummy) column that you delete after the import, or to escape the values in quotation marks, i.e. "23.28". This should then be recognized as one cell.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Importing Data with decimals’ is closed to new replies.