Handling multi-chars field separators

#1

Hi,

I must work with flat files with field separators made of multiple characters ("|;|" for instance).
Is there a way to make it work with Dremio ?

Best regards,
Damien

0 Likes

#2

Hi, any feedback ?

Dremio UI allows us to put multiple characters as column separator but it is only using the first character entered.
Is there a way around that ?

0 Likes

#3

Hi @damiencoueron

Where are you entering multiple separation characters? Can you please send us a screenshot?

Thanks
@balaji.ramaswamy

0 Likes

#4

Hi @balaji.ramaswamy,

Here is how my raw file looks like. You can see the field separator ( “|;|” ) :

Here is what happens when I try to set a custom field delimiter. Apparently only the “|” pipe is interpreted by Dremio :

Thanks for your help,
Damien

0 Likes