Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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