How to assign row.item for a line with quotations

Help Studio
, ,
1

Hi Experts,

How would I assign a row.item with a line with quotations. In my case, I am trying to assign a row.item to “Record (Group Share Path/Mapping, Physical Record, Phone Number, Website Address)”, and this INCLUDES the quotations at the beginning and end.

Thanks

2

grafik

3

How would I use an assign with a row.item for this?

4

Also another thing i forgot to mention, this statement is on two lines and there is a space in front of the second line, like this

“Record
(Group Share Path/Mapping, Physical Record, Phone Number, Website Address)”

5

Here we would suggest

use column index or
rename column name for a more easy to handle col name like

grafik

use the corresponding index of the column instead of 1

6

I cant change the column name, is there any way i can assign a row.item for that statement.

7

Why?

8

My Business Users want to keep it that same exact name, I cant change it

9

if internally the bot handle it alternate it will not affect. However if this is a fixed constraint you can do following
Use ColumnIndex
Or
Check the internal representation of the line break by (e.g. within a LogMessage)
YourDataTableVar.Columns(YourColIndex).ColumnName

so we get some more details on it (eg \r or \n is used for the line break)

or assign it to a string variable and use this for access

10

Ok so i used a write line and I got this. How would I make a row.item for a cell with 2 lines like this. There is also one space before the (Group Share Path/Mapping, Physical Record, Phone Number, Website Address).

image

11

@Pranav_KomandurPK - I guess this is the same subject/topic discussed …Please check this post

12

give a try on

String.Format("Record{0}(Group Share Path/Mapping, Physical Record, Phone Number, Website Address)",vbLf)

Or when with space After line break

String.Format("Record{0} (Group Share Path/Mapping, Physical Record, Phone Number, Website Address)",vbLf)

or when with surrounding “”

String.Format("""Record{0} (Group Share Path/Mapping, Physical Record, Phone Number, Website Address)""",vbLf)