Text to Columns - Positional

Hi,

I have data in a field that I need to separate into columns, but there are no delimiters in the field -- I want to parse the data based on the position in the string. Can someone help me?

Original data:

################## (total 18 characters)

Need to parse below:

### / ## / ## / ### / ##### / ###

3 / 2 / 2 / 3 / 5 / 3

Datasets

Tips and Tricks

Parse

Accepted answers

NicholasM

Hey @eshimizu,

I was working on the exact same thing @NickSm suggested. Great minds think alike.

All comments

bpatel

Hi @eshimizu,

You can use the regex tool to parse. the formula would be (...)(..)(..)(...)(.....)(...) hope that helps!

NickSm

@eshimizu

Is it the same positions for each and every record? If so, RegEx may be the easiest way to go.

Could use a RegEx tool with the Parse setting, and an expression of:

(.{3})(.{2})(.{2})(.{3})(.{5})(.{3})

Where the "." means any character, followed by the number of characters for that group.

NicholasM

Hey @eshimizu,

I was working on the exact same thing @NickSm suggested. Great minds think alike.

JosephSerpis

Hi @eshimizu you can do this using left, substring and right formulas. I mocked up a workflow.

Substring_160919.yxmd

eshimizu

Perfect! Thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703