format text in textbox

Question

I have 1 text box with 8 digits (always 8 digits only)

eg: "12345678" (this is a string no int but always a numeric string because some time its 00000001 also)

now I just wan to show it as 1234 5678

I mean after 4 digits I want to enter a space

that's all I want Please help.

---

Pradeep Yadav (Social MSDN)

Answer 1

Hi Pk,

Use expression in the textbox field,

=LEFT(Fielld!Value.Vaue,4) + Right(Fielld!Value.Vaue,4)  - in case total lenght of string is 8 character if not yoy can always go for combination of other function like LEN,SubString, IIF etc.

for complete list of string function in ssrs follow this link:

http://msdn.microsoft.com/en-us/library/ms157328.aspx#Stringz

---

Regards Harsh

Answer 2

working code

=LEFT(Fielld!Value.Vaue,4) + " " + Right(Fielld!Value.Vaue,4)

---

Pradeep Yadav (Social MSDN)