Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Indented values

KoheiS
5 - Atom

Hello.

I have a CSV file, and some fields have values which are indented by white spaces like below.

captured_csv.png

 

When I import this file to alteryx, then all of the indents are removed.
output.png

Is there any way to keep the indents?
Thanks.

5 REPLIES 5
tom_montpool
12 - Quasar

I opened the input using the \0 (non-delimited) option, changed the space to a non-breaking space with a Regex_Replace function, and then used the Run Command tool to output\input the modified file...

 

 

KoheiS
5 - Atom

Hello, Bolide.
Thank you for your quick response and your solution works for me.
But I think this feature, removing indents, is the bug of alteryx...

KoheiS
5 - Atom

I am so sorry that I wrong your name.

patrick_digan
17 - Castor
17 - Castor

@KoheiS don't worry, I'm sure @tom_montpool has been called worse :) 

 

You can always go back to your post, click on the three dots and click Edit. 

tom_montpool
12 - Quasar

@KoheiS -- no problem, but thanks for noticing.

 

...and @patrick_digan...ouch! -- but you're not wrong :)

 

Worst misspelling of my last name: Munkpaal

Labels
Top Solution Authors