VB - proper format for this IF statement

Brian Susol

• June 16, 2021 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 ★

  • June 21, 2021 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

  Moderator

  ★ BarTender Hero ★

  • October 18, 2021 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

Please sign in to leave a comment.