How to use trim in Alteryx

Question

Hi, I have problem in runnnig the Trim command in Alteryx for the following samples of Trim functions used in Excel. =IF(TRIM(UPPER(C4))<>"",TRIM(UPPER(C4)),"noAccount") =IF(TRIM(UPPER(C8))<>"",TRIM(UPPER(C8)),"noAccount") =IF(TRIM(TEXT(A8,"0"))<>"0",TRIM(TEXT(A8,"0")),"noNumber") Appreciate someone can help me. Thank you. Regards Douglas

mst3k · Accepted Answer

trim in Alteryx should work the same as excel, removing both left and right whitespace. in Alteryx, you want to use uppercase() instead of upper()

pdave87 · Accepted Answer

Hi Douglas,

Trim function in Alteryx will return the value after removing unwanted character specified in quotes "" in the expression editor. Let me know if below expression returns the expected value in the output for your use case.

Regards,

Pratik

Priyanka_Ms · Accepted Answer

Hi Douglas,

You can use a data cleansing tool and set the configuration "Remove unwanted characters - Leading and Trailing spaces" as checked.

Also, you can use a formula tool and use the function Trim()

Like Trim(C4)

To convert it to upper case, use the formula Uppercase(), like Uppercase(C4)

Use a " If "  statement for processing conditions.

You can refer the attachment too.

pdave87 · Accepted Answer

@Priyanka_Ms and @mst3k thanks

@DouglasEKL here you go..