String encoding problem: Unable to write symbol " for inch

Help Studio
1

Hi All,

I have a use case I need to read from csv and write it to web

I have a column dimension, it contains dimensions in inch for eg: 16", (12/16"),

The values of column is below:
Sixteen inches
(12")
(16"*16")
… Size: 24"

I wonder my automation skips symbol and write as below using type into activity:

Sixteen inches
(12)
(16*16)
… Size: 24

Any help will be much appreciated

2

Hi,

Can you try as the following?

"16"", (12/16"")"

Regards,

3

Hi @Yoichi ,

Thank you for your response,

The scenario is the data is read from csv and also not all column have to apply " (inch symbol)

For eg the sample values are below
Sixteen inches
(16/16) inches
16"
(12")

Thank you

4

You can check while reading if the row read from csv file contains inches or ", if it does then perform @Yoichi method else do it normally

5

Hi @Quenton_Wayne_Rebello ,

Yes, I already verified these before posting!

Youchi’s method will not work as the data is a column value of huge data table and the symbol " not have to apply on each value please refer the example values are given in question.

6

HI,

Can you share your csv as file? It’s no problem if dummy data.

Regards,

7

Hi @Yoichi,

My csv is a comma separated csv contains a column name asset description, which have details of assets, I can’t share the file because of security restrictions and I’m writing from phone so not able to generate a dummy csv! Sorry. Please find image of data sample attached

IMG_20230719_111447
IMG_20230719_1114471920×2746 982 KB

8

HI,

I think there are mainly 2 possibilities regarding this issue.
First, double quote may be removed when read it from CSV.
Second, double quote may be removed when type into web site.

So do you use TypeInto activity?
If so, to isolate the first cause, can you try to put LogMessage activity just before the TypeInto to print its content.
Next, can you try to change InputMethod property of TypeInto : HardwareEvent, WindowMessages, Simulate, Chromium API
Or try to use Clipboard : SetClipboard activity and Keyboard Shotrcuts activity (Ctrl+v) instead of TypeInto?

Regards,

9

Hi @Yoichi,

The first possiblity was verified already:

Log message and and message box activity gives desired output

The double quotes are removed while typing by type into activity!

Let me try with send window activity and other approach.

Thank you for suggestions

1 Like