So first i need to select distinct some of my files. After that i need to add something like (.) in the last of the data.
For example
000000-005133-20171229-004792
000000-005133-20171229-004792
000000-005133-20171229-004792
000000-005133-20171229-004792
I have this set value and after i get the data using select distinct next i want to edit.
Like this
000000-005133-20171229-004792
000000-005133-20171229-004792.
000000-005133-20171229-004792.
000000-005133-20171229-004792.
Save your query results in a text file. Read text file and split by following Environment.NewLine condition.
Please use Split(entirePDF,Environment.NewLine)
this will give each line in an array(0) = “000000-005133-20171229-004792” + (.)
just append each array value with “.” and assign to a global variable in each iteration.
Like this
000000-005133-20171229-004792
000000-005133-20171229-004792.
000000-005133-20171229-004792…
000000-005133-20171229-004792…
I dont know if i can do this. First im read the data using read range. after that using assign to select distinct file. After i get the distinct file what should i do?
im try using solution from @arivu96 but still with no avail results…