Delimeter Count

[Karthick461]

I have a file which has more number of Pipeline Delimeter ( | ) . while taking input i have mentioned (\0) as delimeter and taken all fields into single column. Now i need to calculate count of ( | ) pipeline in each row. I have tried Regex_Countmatches, but I am unable to add ' | ' symbol in formula section

 How to calculate delimeter (|) and based on counts I need to trigger email. like if Count is >50 , Email has to trigger from Alteryx. How to achieve this

[atcodedog05]

Hi @Karthick461 

Can you provide sample data

[Karthick461]

Sample File attached

Error

[atcodedog05]

Hi @Karthick461 

It seems to work for read it like below

Workflow:

Hope this helps : )