How to display value in 2nd field regardless of Upper or Lower case in value in 1st field?

  • Questions
  • How to display value in 2nd field regardless of Upper or Lower case in value in 1st field?
Question ID: 108513
0
0

Hi,

I am trying to find a process where I can display 2nd field value when I type in mix case value in a 1st field (String Type). Hope someone might have already done this similar scenario or might know how to do it. Your help would be greatly appreciated.

Scenario:

I have a 1st field called "Customer" (String Type field) and 2nd field called "Market" (look up list type field). Now, for Produce and Market field I have hard coded in workflow as follow:

If FieldName= "BG_USER_01" Then ‘CUSTOMER

Select Case Bug_Fields(FieldName).Value

Case "salex" _

Bug_Fields("BG_ USER_02").Value = "local" ‘MARKET

End Select

End If

Note: I choose to do with case statement cause I have several customers and Market list.

In my above code I would like to implement mix case condition. When I have mix case, I do not have to worry how I type in about customer First name initial and complete last name.

Now, When I type in Customer's First name initial and complete last name example: salex or SAlex or Salex in "Customer" field, I should get correct value in my 2nd field which is "Market". The correct value for Market in this case is "local".

So, how I can set up upper-case or lower-case ignorance condition to satisfy my scenario? Please advise.

Marked as spam
Posted by (Questions: 30, Answers: 35)
Asked on July 23, 2018 7:35 pm
3 views
Answers (1)
0
Private answer

You can use the VBScript **UCase** method to convert the value to all upper case and then base your script on the all upper case value.

https://www.w3schools.com/asp/func_ucase.asp

Marked as spam
Posted by (Questions: 2, Answers: 425)
Answered on July 27, 2018 12:04 pm