Replace within a column

[AnnDz]

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.

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

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

[Felipe_Ribeir0 · Accepted solution]

Hi @AnnDz 

Please see the attached workflow.

[gyang3 · Accepted solution]

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. 

[AnnDz · Accepted solution]

thanks so much for your help!

[AnnDz · Accepted solution]

Thank you so much for your help!