combining csv options with a delimiter longer than 1 character

[Yael_Bar_Corley_-_Personetics]

I need advice to solve configuration of

tFileInputDelimited.

I have to configure a delimiter of more than 1 character, for example: "~|~"

though With CSV options selected, the field separator can only be a single character, my aim in using csv options is to implement the escape char/text enclosure.

how can I support both using component:

tFileInputDelimited ?

[Anonymous]

Hello,

For your use case, have you tried to enabled the CSV options in tFileInputDelimited to see if it works?

If you wan to know more about these, try to create metadata in the repository by using CSV option and you can play with option and get to know how the would be extracted from that csv.

Elaborating your case with an example with input and expected output values will be helpful for us to give you a precise solution.

Best regards

Sabrina

[Yael_Bar_Corley_-_Personetics]

attached screen shot of the original configuration. I took out the separator configuration to a context variable so I will have the flexibility to change it according to my customer's needs

[Yael_Bar_Corley_-_Personetics]

attached a sample of expected input, I will attach also a more complex example

[Yael_Bar_Corley_-_Personetics]

in the attached more complex example I expect FIRST_NAME to be loaded to the DB as"

Joshua "The Big Brother" Junior

I have tried the above configuration & played with it - but with no success so far.

I will appreciate any advise.

[Yael_Bar_Corley_-_Personetics]

thank you for the response - I added below some more information. if you have any ideas that will be great.