Remove value in the string

[jsobrinho]

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.

[asinha1991]

maybe a calculated field like this?

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

not sure if I get you though

[Arthur_Fong]

Can you please provide a sample app?

[StarinieriG]

Hi 

try in this way

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

[SergeyMak]

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)

[Brett_Bleess]

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