Data preparation

[Pickaxe]

Hi All,

I need idea's for formatting as seen below,  Suggestions and solutions are welcomed

Data source	Data needed
hg_and_format	HGAndFormat
hg_nothing	HGNothing
hg_and_empty_to_format	HGAndEmptyToFormat

Basically remove "_" underscore and capitalize the first letter and combine them into so.

I have been looking for solution all over for a few days , pls assist .

Thanks

[atcodedog05]

Hi @Pickaxe 

Here is how you can do it.

Workflow:

Hope this helps : )

[Emil_Kos]

Hi @Pickaxe,

did you tried using Data cleansing tool?

[binuacs]

@Pickaxe another method using text-to-column tool

[Emil_Kos]

Hi @Pickaxe,

As I have mentioned this can be achieved using a data cleansing tool. 

I actually wanted to test if this would truly work 😛 

[atcodedog05]

Hi @Emil_Kos 

Interesting i am curious on how exactly is it taking HG as title case.

Thanks for the share 😀

[Emil_Kos]

Hi @atcodedog05,

I am too tired to check that but we now know that it works 😀

[Pickaxe]

Thanks a lot guys will try out all posted ideas 😊👍