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

[YZHE]

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!

[messi007]

@YZHE,

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

Regards,

[afv2688]

Hello @YZHE ,

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

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

Regards

[Emil_Kos]

Hi @afv2688,

You forgot to attach the input file. 

[YZHE · Accepted solution]

Thanks @afv2688 

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.  

[echuong1]

For multiple character delimiters, I recommend using a replace to change it to a single delimiter. This makes it much easier for parsing!

In your case, I might use a formula with the following. You can then parse on a singe instance of | or another character of your choosing:

 replace([fieldname], "||/", "|").