How to create a folder, if its not existing already

[vencric]

How to create a folder, if its not existing already

[atcodedog05]

Hi @vencric 

Something below would be better and easy to maintain as a list.

Hope this helps : )

[vencric]

Thanks @atcodedog05 .But the list will be changed dynamically based on the input.. thats why i used REGEX_CountMatches

[atcodedog05]

Hi @vencric 

Here is the Regex way

(:?) is used to create an unmarked group which checks the input for the chars in the list.

Hope this helps : )

[vencric]

Even in this case, only 4th option should be true... rest should be false..

[atcodedog05]

Hi @vencric 

can you explain why?

[vencric]

I want to check only, if B is followed by 5 and not other way around..

[atcodedog05]

Hi @vencric 

But row 1-3 has C5 which is part of the list hence returning true.

[vencric]

ohh... ya.. in this case , its true... but i found one more string where it given the opposite result... let me check that scenario... thanks..

[atcodedog05]

Sure, you can check and let me know 🙂

[vencric]

Hi @atcodedog05 how to concatenate values in same rows till blank value is found