Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 28, 2015 at 03:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 03:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded