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.
Solved! Go to Solution.
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.
@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.
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.
thanks so much for your help!
Thank you so much for your help!