Share via

Extractors.Csv()

  • Article

Summary

The Csv() extractor disallows the delimiter parameter and defaults the field delimiter to ',' (comma). All other parameters are the same. See Extractor Parameters (U-SQL) for all supported parameters and their defaults values.

Examples

  • The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.

  • The example below uses the sample data provided with your Data Lake Analytics account. See Prepare source data for additional information.

      // Excel CSV (ANSI with ASCII only)
  // You need to quote ASCII with [] to make sure it is not read as a reserved U-SQL keyword
  @Trips =
      EXTRACT date    DateTime,
          driver_id   int,
          vehicle_id  int,
          trips       string // Array
       FROM "/Samples/Data/AmbulanceData/DriverShiftTrips.csv"
       USING Extractors.Csv(encoding: Encoding.[ASCII]);

  OUTPUT @Trips 
  TO "/Output/ReferenceGuide/BuiltIn/UDOs/extractorCsv_DriverShiftTrips.csv" 
  USING Outputters.Csv();

See Also