How to import a csv file with non-standard delimiter?

I have a csv file with delimiter as two pipes and a forward slash ||/

I know I can use Regex but can figure out the correct syntax.

Any recommendations? Thanks!

Regex

Accepted answers

Your workflow returns what I need, and the mockup data you came up with match exactly the data I have. Thank you so much! 👍

BTW, I read a post before talking about using a RegEx Tokenize function to parse the data. In that case the csv file delimiter was <|>

I tried to use the RegEx for ||/ as well, but just not working.

I am attaching the workflow from the other post.

Could you share a sample file. It will help us to parse it correctly.

Regards,

Hello @YZHE ,

I came up with this solution, let me know what you think

Edit: Thank you @Emil_Kos, now it is added 🙂

Regards

You forgot to attach the input file.

Your workflow returns what I need, and the mockup data you came up with match exactly the data I have. Thank you so much! 👍

BTW, I read a post before talking about using a RegEx Tokenize function to parse the data. In that case the csv file delimiter was <|>

I tried to use the RegEx for ||/ as well, but just not working.

I am attaching the workflow from the other post.