Newbie Questions

Re: Remove Char from Concat string

Jimmy — Sat, 09 Jul 2011 03:37:06 GMT

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)

Re: Remove Char from Concat string

Patrick Halstead — Fri, 08 Jul 2011 19:53:37 GMT

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,

Remove Char from Concat string

rickyponting — Tue, 05 Jul 2011 17:15:19 GMT

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.