Widecard characters in Data-macro

[abrian98]

I am trying to use wildcard characters in Data-Macro. I would appreciate it very much if someone help me with this. First of all, can Data-Macro handle wildcard characters? If so, if I want to find the followings in the column A and would like to enter a certain text (let's say 'true') in the column B, would this work?



Column A Column B
AB12bbc
ABcv11f
AB11111
ABkerun

If [Column A] = 'AB*' THEN
SetField
Name Column B
Value = 'true'

Any input would be very appreciated. HK

[June7]

Use the Like operator with wildcards. Try quote marks instead of apostrophe.

If [Column A] Like "AB*" Then

[abrian98]

Right on! Thanks for the tip.