SHA1_Hash수집

Read Range Workbook

Add Data Colomn - 데이터 테이블 : dtWI5 / 열: / 열 이름 : "hash"

For Each Row in Data Table - dtWI5

 

[추출]

> Assign

- strClientID / CurrentRow("Client ID").ToString.trim

- strInfo / CurrentRow("Client ID").ToString.Trim+" "+CurrentRow("Client Name").ToString.Trim+" "+CurrentRow("Client Country").ToString.Trim

> Use Browser - "http://www.sha1-online.com/"

>> Type Into - strInfo + "[k(Enter)]"

>> Get Text - strHash

 

[가공]

For Each Row in Data Table - dtWI5

[검증]

> If - CurrentRow("Client ID").ToString.Trim.Contains(strClientID)

>> CurrentRow("hash") - strHash

 

[기록]

Write Range Workbook - "경로" / "Hash" / dtWI5