Hi I need to clean up some data i have an input column which has data i want to split it up into two column and then get final output column. The Split input 1 and split input 2 are just for understanding purpose i need to get the final result as shown in column output. InputSplit Input 1Split Input 2OutputHETH HA11 -HETHHA11 -HA11MARO MU32:BMAROMU32:BMU32:BTGRA TB01:BTGRATB01:BTB01:BBURL BS02 -BURLBS02 -BS02CAMP CM47:DCAMPCM47:DCM47:DSPLE SG19 -SPLESG19 -SG19 EDGE EC05 LEDGEEC05 LEC05

Data Cleaning

Hi I need to clean up some data i have an input column which has data i want to split it up into two column and then get final output column. The Split input 1 and split input 2 are just for understanding purpose i need to get the final result as shown in column output.

Input	Split Input 1	Split Input 2	Output
HETH HA11 -	HETH	HA11 -	HA11
MARO MU32:B	MARO	MU32:B	MU32:B
TGRA TB01:B	TGRA	TB01:B	TB01:B
BURL BS02 -	BURL	BS02 -	BS02
CAMP CM47:D	CAMP	CM47:D	CM47:D
SPLE SG19 -	SPLE	SG19 -	SG19
EDGE EC05 L	EDGE	EC05 L	EC05

Tips and Tricks

Accepted answers

atcodedog05

Hi @ahsansalik

Fixed it. Made the below change.

clean.yxmd

All comments

Emil_Kos

Hi @ahsansalik,

I have prepared a workflow for you:

The output:

Data Cleaning.yxmd

atcodedog05

Hi @ahsansalik

Here is how you can do it.

1. Split to column using text to columns delimiter space

2. Trim space and hyphen

Hope this helps 🙂

clean.yxmd

ahsansalik

Thanks for your kind response in row 7 if you see the L is still in the final output which i want to get rid off

ahsansalik

Thanks for your kind response in row 7 if you see the L is still in the final output which i want to get rid off aswell as i dont need - and any extra character like L

ahsansalik

I can however using your workflow add another formula to remove L but if i get anything else then i would have to add another formula function so i need to make it geneic

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703