Read file excel comma (, )?

File1 :
image

File 2:
image

If I want to read file1 and get data from file1 to read row Column C for read data in column B.

Please guide me about it.

이 소스가 당신의 질문에 맞는 결과인지 확인해 보십시오.

TEST.xaml (10.4 KB)

@sumouse No,
I want to read by rows from file1
I want compare to file2 (Find Column No. = P1) and get data in same row in column File Name

image

Example : first row file1 = P1
I want to find data in Column B(File Name) = Eng

I want output ENG

Please guide me about it.

Hi,

Hope the following helps you.

Sample20210810-2.zip (3.1 KB)

Regards,

Hi @Maria99

Try using multiple for each row in datatable

And second row(“ColumnC”).tostring.split(",".tochararray)

And based on the condition validate

Thanks
Ashwin.S

나의 소스 Test.xaml에는 당신이 원하는 결과가 들어있습니다.
p1인 경우,
ENG를 출력합니다.

1 Like

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