InfoPath Dev

 Hello all.

I have concat a string from repeating table textbox  separated by a Semicolon ";" .ie Sam;Stela;Jon;Methues

Now my requirement is to remove a  string as Jon.Then i remove Jon with the help of translate function as  translate(., Jon, "").

But Semicolon is remaining. I am also tried  translate(., concat("Jon",";"), "") but didn't get any success.

Or how i concat a string without this string(Jon), I am using that formula

substring(eval(eval(EmployeeDetail, 'concat(my:Employee, "; ")'), ".."), 0, string-length(eval(eval(EmployeeDetail, 'concat(my:Employee, "; ")'), "..")) - 1)

Any one tell me how this problem will solved.

Any help will greatly appreciated. Thanks in advance.

Hi RickyPonting,

Fancy evals you are using fine sir! :)  I'm wondering why you need the eval(eval(...)) for the string-length. Seems a bit weird.

How does translate(., Jon, "") work at all. I'd think you would need to have Jon in double quotes - translate(.,"Jon","")

If that works, then the concat with semicolon should work too.

More later,

The answer to your second question is easier.  You can use:

eval(eval(EmployeeDetail[my:Employee != 'Jon'], 'concat(my:Employee, "; ")'), '..')

If you don't want a last semicolon at the end, you can do this:

substring(eval(eval(EmployeeDetail[my:Employee != 'Jon'], 'concat("; ", my:Employee)'), '..'), 3)