Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Need help replacing Start of Heading unicode with blank space

ktipp
5 - Atom

Is there a way to replace SOH in my csv data file?

 

This start of heading (SOH) is causing my snowflake import to fail.

 

Any quick help very appreciated.

 

Thanks

4 REPLIES 4
BrandonB
Alteryx
Alteryx

How is your workflow currently configured? Are you just reading from a CSV and writing up to Snowflake? You can skip header rows in a CSV by changing the row that the data starts on: 

 

csv import.png

ktipp
5 - Atom

Thanks Brandon.

 

The SOH character is not on the header row, but imbedded in data fields.

 

Notice the screenshot shows SOH, but you cant just look for "SOH' as it is non-printable ASCII start of heading (SOH).

ktipp_0-1593108496070.png

 

BrandonB
Alteryx
Alteryx

You can swap this out using a Regex tool which replaces the character as shown here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Replace-ascii-delimiters/td-p/527463

 

I believe that the SOH code is \x01

ktipp
5 - Atom

Thanks Brandon, that worked as expected.

 

I appreciate the assistance.

Labels