Need help replacing Start of Heading unicode with blank space

[ktipp]

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

[BrandonB]

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: 

 

 

[ktipp]

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).

[BrandonB · Accepted solution]

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]

Thanks Brandon, that worked as expected.

I appreciate the assistance.