substring

[#1]

Hi all

  I have text file.substring values are

file1 india,hyd pune

file1 india,hyd,chennai

i want to display only pune chennai.how can i do this?

[prma7799]

Why you want to use substring here  you have other way to do it.

Please share some sample data with expected output.

[Anil_Babu_Samineni]

May be use?

If(Match(file1, 'pune','chennai'), file1)

[Anonymous]

Hi,

Do you have this value in your table ? then you can use filter condition.

Please share some sample files for better understanding