i have a string concatenated of length 20 , all i need is to replace saying 10th position to 12th as blank irrespective of any value in those positions.
is there a way to do this?
@Nandy,
Did it work out?
Best,
Yalmar
Hi @Nandy,
The most easy way to do it is to use the formula tool and use the following formula.
Replace([Field1],Left(Right([Field1], Length([Field1])-10),3),' ')
Where field1 is the field containing your string.
Nice solution, @yalmar_m.
Here's another way to approach this:
left([String],1+[Start])+" "+right([String],length([String])-[Stop]-1)
[Start]==10 and [Stop]==12. The "+1" and "-1" were added to to produce the results based on your specifications in your post.
