Replace within a column

Hi. I need to finda nd replace within a column. For example, if a number is 2055 , I want to replace it with 2025. This is in a vstring field type column. Any help is appreciated. When I try to use the Find Replace tool I am stuck at the find and replace boxes beacuse it says No Valid Fields.

Best Practices

Accepted answers

Felipe_Ribeir0

Hi @AnnDz

Please see the attached workflow.

DA_CH 05_EX 5.2 - Alteryx Solution.yxzp

DA_CH 05_EX 5.2 - Alteryx Solution.yxmd

gyang3

Hey @AnnDz, using a formula tool should help avoid the issues with having the right datatype. Its a simple replace formula to search for 2055 and replace with 2025. See attached workflow

If this helps solves your issue, please mark as solution.

DA_CH 05_EX 5.2 - Alteryx Solution.yxzp

AnnDz

thanks so much for your help!

AnnDz

Thank you so much for your help!

All comments

Felipe_Ribeir0

Hi @AnnDz

It would be better to see the exact table for input/output.

Anyway, see if you can adapt the attached workflow to do the job.

If you cannot, please paste/attach your input/expected output here.

Replace within a column.yxmd

JamesCharnley

@AnnDz I think the most likely explanation if it says no valid fields is your data is the wrong type. Find and Replace is used on strings but the numbers you're trying to replace sound like they are probably being stored in some kind of numerical type.

AnnDz

Here is the file. The date field is a vstring (thats a different question as to how to change that!) . One of the dates says 2055 instead of 2025. I just want to find any fields with 2055 and replace with 2025.

DA_CH 05_EX 5.2 - Alteryx Solution.yxzp

Felipe_Ribeir0

Hi @AnnDz

Please see the attached workflow.

DA_CH 05_EX 5.2 - Alteryx Solution.yxzp

DA_CH 05_EX 5.2 - Alteryx Solution.yxmd

gyang3

Hey @AnnDz, using a formula tool should help avoid the issues with having the right datatype. Its a simple replace formula to search for 2055 and replace with 2025. See attached workflow

If this helps solves your issue, please mark as solution.

DA_CH 05_EX 5.2 - Alteryx Solution.yxzp

AnnDz

thanks so much for your help!

AnnDz

Thank you so much for your help!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335