CommencerCommencer gratuitement

Parsing text into dates and numbers

You're preparing to validate the data types in the coffee shop sales. Set up the functions to check dates and numbers on sample data.

The necessary packages such as DateTimeFormatter, and NumberUtils have been imported for you.

Cet exercice fait partie du cours

Cleaning Data in Java

Afficher le cours

Instructions

  • Specify the date format for the data as M/d/yy.
  • Parse the transaction amount as a Double.
  • Check if the transaction amount can be parsed as a number.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

public class CoffeeSalesExample {
    private static LocalDate parseDate(String dateStr) {
        // Specify the date format for the data
        DateTimeFormatter format = ____.____("M/d/yy");
        return LocalDate.parse(dateStr, format);
    }
    
    private static double parseAmount(String amount) {
        // Parse the amount as a Double
        return ____.____(amount.replace("$", "").trim());
    }

    public static void main(String[] args) {        
        LocalDate date = parseDate("1/10/23");
        System.out.println("Date: " + date);
        
        String amount = "$30.61";
        // Check if the amount can be parsed as a number
        boolean isAmountParsable = ____.____(amount);
        System.out.println("Is amount parsable? " + isAmountParsable);
        
        Double parsedAmount = parseAmount(amount);
        System.out.println("parsedAmount: " + parsedAmount);
    }
}
Modifier et exécuter le code