Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jsobrinho
Creator
Creator

Remove value in the string

Hi guys,

I have a field called C in my script like Concat(fieldA,'|',fieldB) in my application I have a filter from fieldA, so when I selected a fieldA , my field C show the result concatenated fieldA|fieldB

Its possible remove this result fieldA and show just fieldB without |? because I already selected the fieldA

 

I dont know if its clear, but I need this concatenation in my script to show the result, but I only dont need repeat the value from field A because I already did the filter by list box.

Labels (4)
5 Replies
asinha1991
Creator III
Creator III

maybe a calculated field like this?

if(GetSelectedCount(FieldA)>0,FieldB,FieldA&'|'&[FieldB])

not sure if I get you though

 

 

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Can you please provide a sample app?

StarinieriG
Partner - Specialist
Partner - Specialist

Hi 

try in this way

 

if(GetSelectedCount(FieldA)>0,PurgeChar(C,'|'),C)

SergeyMak
Partner Ambassador
Partner Ambassador

Not sure why can't you just show FieldB?
If you still need to display Field C, but just second part, than try Subfield([field C],'|',2)
Regards,
Sergey
Brett_Bleess
Former Employee
Former Employee

Jose, did any of the posts help you with what you needed to solve here, or are you still trying to figure things out?  If you need further help, please provide an update and per Arthur's comment, an example app may help a great deal here too.  If someone's post did help, please use the Accept as Solution button on that post to give them credit, you can do more than one post as well if multiple posts helped you sort things out.  If you did something else completely, consider posting what you did and then mark that as the solution so others will know what worked in this case.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.