How to cut text in column

[michak80]

Hello, 

I have a column with some text. For example 0470900034312900034312 as you can see below. I need cut only these text 0470 900034312 900034312. Could you please help? 

[marcus_sommer · Accepted solution]

Just use string-functions like left/right/mid() with the appropriate number of chars which should remain.

[Anil_Babu_Samineni · Accepted solution]

@michak80 Perhaps Right(Fieldname, 9)