topic ADD Space to text not to numbers in Alteryx Designer Desktop Discussions

ADD Space to text not to numbers

deepakpintya — Mon, 12 Sep 2022 18:12:52 GMT

Hi Team,

I want to add single space to texts and not to numbers. I just need space to text fields.

Luke_C — Mon, 12 Sep 2022 18:14:38 GMT

Assuming you want to add a space after the text, this would work. Otherwise feel free to modify how you see fit:

IF isinteger([Root Cause]) then [Root Cause] Else [Root Cause] + ' ' Endif

IraWatt — Mon, 12 Sep 2022 18:18:26 GMT

Assuming you want to add the text to the beginning you can use the regex match formula like this:

REGEX_Match([Root Cause], "\d+")

This will return True if only digits are present.

Put that in an if statement and you can add a space if it is not only numbers:

IF REGEX_Match([Root Cause], "\d+") THEN [Root Cause] ELSE " " + [Root Cause] ENDIF

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

deepakpintya — Mon, 12 Sep 2022 18:26:47 GMT

Its not worked.

IraWatt — Mon, 12 Sep 2022 18:31:27 GMT

@deepakpintya did you want to add a space to the beginning or end?

deepakpintya — Mon, 12 Sep 2022 18:32:26 GMT

Beginning.

IraWatt — Mon, 12 Sep 2022 18:36:27 GMT

@deepakpintya how did my example workflow not work for you?

deepakpintya — Mon, 12 Sep 2022 18:36:47 GMT

unable to output but regex formula worked. In output its coming without space.

IraWatt — Mon, 12 Sep 2022 18:51:51 GMT

@deepakpintya It does seem to work with CSV just not Excel not sure why (works fine here with CSV):

deepakpintya — Mon, 12 Sep 2022 19:00:09 GMT

I have huge data with many coulmns, if i change to CSV from EXCEL then its not getting reconcile.