FILTERING THE BOLD CHARACTERS (STRING)

[dunkindonut7777]

Hi can you help me how to identify the string characters that are in bold. The raw file is in excel.

ID	Description
12333	Fruits
21344	Apple
34554	Mango
43536	Dessert
45565	Cupcake
11233	Ice Cream

I just want to retain the bold ones and filter out those plain. Thank you

[JoeS]

Hi @dunkindonut7777 

When you say you want to retain the ones in bold, I am assuming you mean use the formatting inside Alteryx in a filter to retain them?

If so Alteryx can't natively read the formatting from Excel, it extracts the values instead.

You'd be best to go do the Python route or VBA/VBS to extract the information. Are you familiar with either of those? 

[MartWClimber]

@JoeS Should this be possible with the python tool (with no input attached) 

read in the excel file use python magic in the python tool to extract only the bold strings and than output this to the rest of a WF?

[JoeS]

Yeah that will be possible for sure. 

I'll see if I can find some time to build a quick example 🙂

[dunkindonut7777]

thank you for this!