데이터테이블을 SQL로 옮길때 이상한문자가 나옵니다

Help Studio
, , , , ,
1

웹에서 데이터 스크랩으로 특정 자료를 스크랩 한 데이터테이블 자료를 mssql로 입력할 때
원하지 않는 ‘?’ 문자가 여러 곳에 입력됩니다.

image
위 이미지와 같이 A? 3.6V? 부분에 원하지 않는 '?'가 발생합니다

image
웹 소스를 확인 결과 ‘&nbsp’ 부분에서 '?'가 발생하여
replace(chr(32),“”)를 적용하여 다시 입력해봐도 '?'가 계속 발생합니다

조언 부탁드립니다

2

Hi @YIA

Welcome to community

Do you want to remove the ? from the image
If yes
Try this below expression
"A? 3.6V? 3400r".Replace("?"," ")

Regards
Gokul

3

image
i already do it first,
but it not work on mssql datatable
thx for reply

4

Can you try to separate this condition into 2 Like

Use Assign activity
LHS - First (Create a variable)
RHS - IRow(“Colummn-0”).tostring.Replace(“”,“”)

Message box - First

Use Assign activity
LHS - Second (Create a variable)
RHS - First.replace(“?”,“”)

Message box - Second

Try this let me know if you face any issue and also if possible share the screenshot
Regards
Gokul

5

image

image
image

on uipath it doesn’t have ‘?’

image
but if i use this to move data to mssql datatable

image

suddenly come out ‘?’ ilke this

6

You can use Query to remove the “?” from the Data Table @YIA

Regards
Gokul

7

image

i think u mean like this but it wasn’t work
maybe it’s not correct query cuz i’m not good at sql query

if any other way or query
plz advice me
thx to spend ur time to me

8

Have a view on this

SELECT REPLACE (MyURLString, ‘GREATERTHAN’, ‘>’) as MyURLString From MyTable

Regards
Gokul

9

thx all time
finally solved it

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.