Read file excel comma (, )?

[Maria99]

File1 :

File 2:

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.

[sumouse (ChoboIT)]

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

TEST.xaml (10.4 KB)

[Maria99]

@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

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.

[Yoichi]

Hi,

Hope the following helps you.

Sample20210810-2.zip (3.1 KB)

Regards,

[AshwinS2 (Ashwin S)]

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

[sumouse (ChoboIT)]

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