Trying to change a word type in BO to another word type

[Former Member]

Below is the formula I am trying to create. It works just fine up to the last elseif statement. What I am trying to do is convert the "Preservation and Access" to JP2 and JPG. Not certain what I am doing wrong. Any suggestions would be greatly appreciated.

=If([Output Type]="Access")Then[Output Type]="JPG"ElseIf([Output Type]="Preservation")Then[Output Type]="JP2"ElseIf([Output Type]="Preservation and Access")Then[Output Type]="JP2"to"JPG"

Thanks,

Roger

[Former Member]

Hi, it seems to me that, in your last statement are too many " , instead of using "JP2"to"JPG", try using

"JP2 to JPG"

Regards,

Rogerio

[amitrathi239]

Hi,

Not very sure what are you trying to achieve.but this is wrong.

Then[Output Type]="JP2"to"JPG"

if you want to change the values  from JP2 to JPG then you can use replace function based on certain condition.

Then replace([Output Type];"JP2";"JPG")

Amit

[Former Member]

ElseIf([Output Type]="Preservation and Access")Then replace([Output Type];"JP2" ;"JPG")

When I run the above formula Preservation and Access are showing up. I would like JP2 and JPG to show up instead.

Thank you for you help.

[amitrathi239]

Hi,

Then use this.

ElseIf([Output Type]="Preservation and Access")Then ([Output Type]="JP2 to JPG")

Amit

[Former Member]

Worked Thank you