VB - proper format for this IF statement

Brian Susol

• 2021年06月16日 18:07

Till today, I have gotten away with having a Single Line Expression for my "SetTrack" field. 

The expression was simply:

Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("SetID").Value & "/" & Format.NamedSubStrings("TrackID")

 

However, I am now in need of making an adjustment.  It PMSetID and SetID are the same, Id like to continue down that path, but if different, id like to make an adjustment.  I cant quite figure out the format here. I have the following, any thoughts would be appreciated.

PM = Format.NamedSubStrings("PMSetID").Value
SET = Format.NamedSubStrings("SetID").Value

If PM = SET
Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("SetID").Value & "/" & Format.NamedSubStrings("TrackID")

Else
Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("TrackID")

end if

 

1

• 

  Brian Susol

  ★ BarTender Hero ★

  • 2021年06月21日 11:35

  In case anyone else finds it helpful, I believe I have it working

   

  PM = Format.NamedSubStrings("PMSetID").Value
  SET_ID = Format.NamedSubStrings("SetID").Value

  If PM = SET_ID Then
  Value = Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("TrackID")
  Else
  Value = Format.NamedSubStrings("PMSetID").Value & " " & Format.NamedSubStrings("SetID").Value & "/" & Format.NamedSubStrings("TrackID")
  End If

  0
• 

  Xabier Clemente

  版主

  ★ BarTender Hero ★

  • 2021年10月18日 09:08

  Hi Brian!
  
  Welcome to the BarTender Community!
  
  Thank you for sharing with us the solution you found for this issue! People with the same query will surely find it useful. :)

  0

請登入寫評論。