Get startedGet started for free

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.

This exercise is part of the course

Cleaning Data in Java

View Course

Exercise 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.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

import java.time.LocalDate;

import java.time.format.DateTimeFormatter;
import org.apache.commons.lang3.math.NumberUtils;

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);
    }
}
Edit and Run Code