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.
@dunkindonut7777
I take the first 5 characters and the rest goes to the new field 2.
Slightly different:
substring([field],5)
it is faster.
cheers,
mark
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?