Extractors.Csv()

 

Updated: March 28, 2017

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

Copy 
// 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

Community Additions

ADD
Show: