In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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