Remove part of a string

[#1]

Hi I have a string in a variable vCourseFamily 'abc', 'def','hhh' . I want to remove the last part of the string 'hhh' from the string. Kindly suggest.

Thanks!

[settu_periasamy]

Hi,

What is your expression for the variable vCourseFamily?

[#3]

=Concat(DISTINCT chr(39)&'*' & [CourseFamily]&chr(39) , ', ')

[settu_periasamy]

do you want to remove the last 3 characters? or it would by dynamic one?

Can you just post small qv app with output?

[#5]

I want any occurrence of the word 'hhh' in the above string to be removed

[sunny_talwar · Accepted solution]

May be this

=Concat({<CourseFamily -= {'hhh'}>} DISTINCT chr(39)&'*' & [CourseFamily]&chr(39) , ', ')

[richard_chilvers]

In your CONCAT, can you not ignore [CourseFamily] whenever it contains 'hhh' ?

[#8]

Thanks Sunny!