RE: [E] Re: Multiple Delimiter Format

["Wilburn, Scott" <Sc...@VerizonWireless.com.INVALID>]

Jim,
Just to clarify, I'm trying to use Drill on files that contain records where the fields are delimited by multiple different characters. 

Example record: 10-20-16,4477,99;98,aab,99;66,aab

Desired result:
columns[0] = 10-20-16
columns[1] = 4477
columns[2] = 99
columns[3] = 98
columns[4] = aab
columns[5] = 99
columns[6] = 66
columns[7] = aab

In this example, the record contains 8 fields when split by comma and by semicolon. 
Is something like this possible?

Thanks,
Scott Wilburn


-----Original Message-----
From: Jim Scott [mailto:jscott@maprtech.com] 
Sent: Thursday, February 18, 2016 03:46 PM
To: user
Subject: [E] Re: Multiple Delimiter Format

Scott,

You would need a format defined for each file type. e.g. csv has commas, tsv has tabs, so on

If you are looking for multiple delimiters within the same file or potentially with a single file extension that isn't supported.

Jim

On Thu, Feb 18, 2016 at 5:43 PM, Wilburn, Scott < Scott.Wilburn@verizonwireless.com.invalid> wrote:

> Hello,
> Is there a way to specify multiple delimiters when configuring a 
> storage plugin record format? For example, could I split records into 
> fields by comma or by semicolon characters.
>
> Thanks,
> Scott Wilburn
>
>


--
*Jim Scott*
Director, Enterprise Strategy & Architecture
+1 (347) 746-9281
@kingmesal <https://twitter.com/kingmesal>

<http://www.mapr.com/>
[image: MapR Technologies] <http://www.mapr.com>

Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>