topic Re: multiple delimeter in transforms.conf is not working in Getting Data In

multiple delimeter in transforms.conf is not working

abhayneilam — Sun, 04 Nov 2012 17:45:27 GMT

Hi,

I have a data as :

and in my transfoms.conf I have written:
DELIMS="|","|"
but it is not working, it is only working for "|" delimeter but not for "|" delimeter,

How to make it work please let me know because if I dont use "|" as a delimeter then

singh|26 and
singh|28 both will will be considered as a single field value but "singh" is a separate value and "26" is a separate value

Please help

Thanks in advance

Re: multiple delimeter in transforms.conf is not working

Lucas_K — Mon, 28 Sep 2020 12:44:32 GMT

I think you should just be defining your delim ONCE not sure why you have it defined twice.
I believe you only specify it in that format when you want to key:pair value your data (which it doesn't appear you want to do).

So try something like the following in your transforms.conf
[my-extractions]
DELIMS="|"
FIELDS="first_name","middle_name","surname","age","location"

This should split out all of your fields.