Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to handle a file with double pipe || delimiter in data loading file activity ACC

ratika
Level 2
Level 2

Hi Everyone,

 

I have a requirement for data import flows where in the import files are delimited with double pipe ||.

Sample as below

 

ratika_0-1618066173994.png

Can anyone please help me handle this? I tried changing the delimiter as || in the data loading activity but that doesn't seem to work.

ratika_1-1618066265002.png

 

1 Accepted Solution
Amit_Shinde
Correct answer by
Level 3
Level 3

Hi Ratika,

 

You need to enable the option Consider the consecutive delimiter as one & need to give the single pipe as the column separator.

 

Below is the screenshot for reference. Hope this helps.

 

Amit694_0-1618226812645.png

 

Thanks,

Amit

View solution in original post

3 Replies
Milan_Vucetic
Community Advisor
Community Advisor

Hi @ratika

for delimiters one character is used in most cases.
Maybe someone will have better idea but I would suggest that you use only one pipe "|" as a delimiter. This will produce a lot of additional empty columns. Later in Enrichment node just pick the ones you need.

Regards,

Milan

Amit_Shinde
Correct answer by
Level 3
Level 3

Hi Ratika,

 

You need to enable the option Consider the consecutive delimiter as one & need to give the single pipe as the column separator.

 

Below is the screenshot for reference. Hope this helps.

 

Amit694_0-1618226812645.png

 

Thanks,

Amit

View solution in original post

Sukrity_Wadhwa
Employee
Employee

Hi @ratika,

Were you able to resolve this query with any of the given solutions or do you still need more help here? Do let us know.

Thanks!