csv import: strip commas from number fields on importing

[squigglybob]

Is your feature request related to a problem? Please describe.
When importing a formatted number such as 1,200 into a number field, an error is thrown

Describe the solution you'd like
If the commas were stripped before the import this could alleviate this issue occurring.

Alternative solution
Is to strip the commas manually before upload, but this can be tricky, as google sheets displays commas when they don't exist, and libreoffice doesn't display commas in numbers when they do exist (by default)

[Nenad-016]

Hello,
your problem is in the file dt-import-procesor.php, you need to change this part:

case 'number':
if ( !is_numeric( $raw_value ) ) {
throw new Exception( "Invalid number: {$raw_value}" );
}
$result = floatval( $raw_value );
break;

into something like this:
case 'number':
// Normalize formatted numbers like "13,400,000" → "13400000"
if ( is_string( $raw_value ) ) {
// stirp white spaces
$raw_value = trim( $raw_value );

    // if is in format 1,234 ili 13,400,000, strip comas
    // (classic EN thousands separator)
    $raw_value = str_replace( ',', '', $raw_value );
}

if ( !is_numeric( $raw_value ) ) {
    throw new Exception( "Invalid number: {$raw_value}" );
}

$result = floatval( $raw_value );
break;

that should do the trick. To explain you are testing something like '13,400,000' with is_numeric function -> always will be false ...

[corsacca]

hey @Nenad-016, welcome do Disciple.Tools theme.
Curious how you've heard about D.T?

[Nenad-016]

hey @Nenad-016, welcome do Disciple.Tools theme. Curious how you've heard about D.T?

Did not heard till now, pls update me on the issue
!