I need to add an "=" to the end of the field if an "=" does not already exist

[bh1789]

I have a field of data that needs to end with an =

sometimes the data comes through without the =

the field can be different lengths

for example here is a field with an = at the end

KamJOVCRBWqqQlWlB16aQZpKc6w=

in this example, there is no = but I need to add an = at the end

khZgNJQWegMisCbODHshBSNh3yM

Thank you for any help, much appreciated!

[Felipe_Ribeir0 · Accepted solution]

Hi @bh1789 

You can use this formula

if Right([Field1], 1) != '=' then [Field1] + '=' else [Field1] endif

[ShankerV]

Hi @bh1789 

One way of doing this.

Input was:

[bh1789]

Thank you very much!

[bh1789]

One more question, is there a way to to formula you provided to not add the = when the field begins with "ECW"?

[Felipe_Ribeir0 · Accepted solution]

Hi @bh1789 

Try this formula

if Right([Field1], 1) != '=' and left([Field1], 3) != 'ECW' then [Field1] + '=' else [Field1] endif

[bh1789]

Thank you very much!