Table of contents
TOC
Collapse the table of content
Expand the table of content

Extractors.Csv()

Michael Rys|Last Updated: 5/15/2018
|
4 Contributors

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

© 2018 Microsoft