SPLIT COLUMNS

[RodrigoOlmedo]

I have this "simple" problem but I am stuck, can you help me?

I want to split a big raw from pos2 to pos5 and other from pos10 until pos13, how can I do that ?

STRING	COL1, FROM 2 - 5	COL2, FROM 10 - 13
ABCDEFGHIJKLMN	BCDEF	JKLM

Thank you for your help

[echuong1]

You can use substring()

[Qiu · Accepted solution]

@RodrigoOlmedo 
Lets use Substring. Alterux counts the start from 0.

[AkimasaKajitani]

Hi @RodrigoOlmedo 

You can use RegEx tool.

RegEx Expression:

.(.{5}).{3}(.{4})

'.' means one letter.

Output: