How to split the characters into two different columns

[dunkindonut7777]

Hi I have a data here that I want to trim it according to specific character count (5) and the other characters will be separated on a different column:

Field	New Field1	New Field2
Apples	Apple	s
Banana	Banan	a

Could you help me with this one please.

[Qiu]

@dunkindonut7777 
I take the first 5 characters and the rest goes to the new field 2.

[MarqueeCrew]

Slightly different:

substring([field],5)

 it is faster. 

cheers,

 mark

[dunkindonut7777]

Hi Qiu, Thank you for this. The new field 1 for me is working but the new field 2 is not working on my end, there are other characters that contains spaces. Is there are othe option for me to cut it with chracters that have multiple words. Like I have a characters this long "to find out same meaning" and I want to separate it into two different columns because I want to trim it into 8 characters only and the other characters that left is put into another column.

For example:

Field	New Field1	New Field2
to find out same meaning	to find ou	t same meaning

Can you help me with this one pls?

[Qiu]

@dunkindonut7777 

Having space makes it a bit complicated. 😂