Split Column by Number of Characters

DustinPGT · 2023-06-13T17:55:30+00:00

There was an error rendering this rich post.

Can we add an option to split a column by the number of characters in the field? I.e. split column by number of characters as far left or as far right. This is a very useful feature in PBI Power Query Editor especially when you have strange date formats like 1231201 or concatenated fields with an order number of a specific length followed by a name 000001Jones.

Find more posts tagged with

Magic ETL

Submitted and awaiting review from product team

Status: Submitted and awaiting review from product team

Comments

ColemenWilson

Hi Dustin,

You could use the split columns tile in magic etl and use the REGEX option with (?<=.{4}).+ as shown in the screenshots below, just change the 4 to be whatever number of characters you want to split on:

Screen Shot 2023-06-14 at 9.51.15 AM.png

Vinay_Jain_

Hi @colemenwilson, Thanks for your comment. It pretty much solves the OP's problem. Can you provide any concise documentation to learn how to create Regex queries for general queries in domo?

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of