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

[RolandSchubert]

Hi @Karthick461 ,

try 

REGEX_CountMatches([Field1], "\|")

Let me know if it works for you.

Best,

Roland

[atcodedog05]

Hi @Karthick461 

You would need to use a character like \| reason being pipe is a special character if you want to search for a special character you need to use \ (backslash) escape character before it like below.

Hope this helps : )

[Karthick461]

Thanks @atcodedog05 & @RolandSchubert 

 How to generate Email from this output.. Like in your example , count is 3 and 2.. if count > 2 , then I need to trigger Email with the field which is having more delimeter

[atcodedog05 · Accepted solution]

Hi @Karthick461 

You can create a table for the rows which has count greater and send it through mail like below.

Hope this helps : )

[Karthick461]

Thanks @atcodedog05 . I got it 

[atcodedog05]

Happy to help : ) @Karthick461 

Cheers and have a nice day!

[Karthick461]

Instead of '|' , if I using tab as delimiter means , what is the function i need to use in Regex_countmatches(Field, ? )..

I tried with /t . but it not worked

[atcodedog05]

Hi @Karthick461 

Try \t 

Hope this helps : )

[Karthick461]

Hi @atcodedog05 

Both '/t' and '\t' not working