Delete Dynamic Number of White Space

Hi All

I've tried a couple different variations of the REGEX tool to try this but to no luck. Tried to piece it together and thanks to those that have answered so far.

Have a bit of gnarly data set where I am trying to delete all white space except for a space after each bit of text.

The white space that comes through on this file could be different for each field.

As an example the distance between O and O on the first line could be 12 spaces. Or it could be 15 spaces. Same for AGT at the bottom. Could be one space. Could be 50.

Any help would be greatly appreciated!

Thank you

Parse

Accepted answers

DataNath

Hey @Mike_at_CG, in the Data Cleanse tool, one of the options is to delete duplicate whitespace!

All comments

DataNath

Hey @Mike_at_CG, in the Data Cleanse tool, one of the options is to delete duplicate whitespace!

Mike_at_CG

Spooky fast answer! Much appreciated. And for all of the other answers in the event I need them again someday

DataNath

No problem @Mike_at_CG! Though I would actually pull myself up here - performance-wise the Data Cleanse route isn't fantastic as it's actually a macro and if you just need to do a single fix (out of all the possible configurations) it's certainly overkill to have Alteryx run all of your data through that before returning to your main flow. You'd be better off just handling it within a formula tool, using an expression like the following (which is actually what's going on under the hood of this DC tick box anyway):

Remove duplicate whitespace.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703