Dividing String

[Bhandi]

Hi,

I have the string which is similar to "R2.030E05" this. I want TAB between aplhabate and numeric. 

One major thing about this string is, alphabate and numeric are not constant. So i am not able to use search/split string. Is there any other simple method to do this?

Thanks.

[smercurio_fc]

If I understood correctly you want to insert a tab between the "R" and the "2" in your example, but the character(s) and number(s) will vary. The easiest way to do this is with the Match Pattern function:

[Bhandi]

Yes, You understood the problem correctly. And thanks for the solution.

[Mathan]

---

Bhandi wrote:
Yes, You understood the problem correctly. And thanks for the solution.

---

Could you please mark smercurio's post as solution. You can do this by selecting from options menu located on the top right corner of smercurio's post. This will help others in future who are looking for a solution for same kind of problem.

Thanks for your understanding,

Mathan

[Bhandi]

Hi,

I am facing one more problem with the same type. My String is  "C-2.435E-07" or "R1.982E04" and i need to divide it so that it look like "C -2.435E-07"or  "R 1.982E04". Where my Minues sign also not constant, it also changes accoding to input. 

Thanks.