Split line break into rows

Hi everyone,

How do I split this into multiple rows:

Name	Asset
Apple	[sign on]Orange Database DFW - gfwac.dsau DIO - frosds.hss CDC - adreirs

So I want to split each line break into separate rows. Also, would like to get rid of anything in the bracket so my final result looks like this.

Name	Asset
Apple	Orange Database
Apple	DFW - gfwac.dsau
Apple	DIO - frosds.hss
Apple	CDC - adreirs

Many thanks in advance.

Datasets

Accepted answers

CharlieS

Use Text to Columns tool with the delimiter set to \n (the reference for the newline character) and configure the tool to split to rows instead of columns. That will take care of the first request.

To eliminate the bracketed text, here's an expression that can be used in a Formula tool on the [Asset] field: The idea is that it identifies the brackets (and anything between) and replaces it with nothing, effectively removing it.

REGEX_Replace([Asset],"(\[.*])","")

All comments

JordyMicheal

Hey bb,

A text to columns will help you greatly here.
Just split to rows on a "\n" and on "asset"

I've attached the workflow

TTC.yxzp

CharlieS

Use Text to Columns tool with the delimiter set to \n (the reference for the newline character) and configure the tool to split to rows instead of columns. That will take care of the first request.

REGEX_Replace([Asset],"(\[.*])","")

JordyMicheal

REGEX_Replace([Asset],"(\[.*])","")

Nice call @CharlieS missed the 2nd ask!

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335