Data Cleaning

[ahsansalik]

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

[Emil_Kos]

Hi @ahsansalik,

I have prepared a workflow for you:

The output:

[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 🙂

[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

[atcodedog05 · Accepted solution]

Hi @ahsansalik 

Fixed it. Made the below change.

[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