What I have is an assign activity strAddress variable as a string and I want to extract data from 2 columns in the DT dt_veritity I used this value row.item(“GRP NAME”).ToString + ("-"c) row.item(“ADD 1”).ToString but I get an error as I need the data to read like this St. Luke’s OB/GYN A Woman’s Place - 306 S. New Street.
Then I’ll use a if and use a get text out of the application to compare the extracted get text variable to the strAddress to see if they match.
Sorry I guess I wasn’t clear.
I have a datatable (dt_veritity) in that table I have 2 columns (GRP NAME and ADD1)
I have to compare the data from the 2 columns to see if it matches the get text data I get from the site. So in column (GRP NAME( I have - St. Luke’s OB/GYN A Woman’s Place and in column (ADD 1) I have 306 S. New Street. In the get text aaname I have St. Luke’s OB/GYN A Woman’s Place - 306 S. New Street.
So my idea was to use assign variable strAddress but I’m not sure how to write the string out in the value? So that is looks like the get text.
So I filter the DT and only get the 2 columns I need (GRP NAME) and (ADD 1) so what can I do to get that data into a string so that is has the same format as what I’m getting out of the get text file? In that field it’s one string and uses a - as a separator. St. Luke’s OB/GYN A Woman’s Place - 306 S. New Street should I use a multiple assign and assign each a variable? or is there a way to write out a string as you mentioned as concatenated?