I would like to split the text file into multiple columns and the desired output should be in excel format. The characters in each column should be as such: 1313115168815151111713111242 Can anyone please help me with the same? I am attaching a sample text file to this query. Thanks in advance. sample1.txt

@binu_acs what if we have to split multiple text files at a time? Can we use Directory tool ? If so in the REGEX tool should we use Directory as the path?

binu_acs

@Sunithaprdp you need to combine all the text file then apply the Regex formula if you want to split all the files in same character length.

for combining the text files you can use the directory tool and a batch macro

Sunithaprdp

@binu_acs yes I could join them but however the output generated is giving me first two columns with a combined data. I would only require only from third column. What should we do in such cases?

binu_acs

@Sunithaprdp good to know that you solved it. please let me know if you see any assistance.

Sunithaprdp

@binu_acs Sure, Thank you so much.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703