In the above image of excel ,i have tried, but didn’t get perfect output what i required.
The output what i want to get is: a,b,c,d,e(between each cell it should be comma)
output 1: a,b,c,d,e
output 2: x,y,z,q,l
can anyone please help me to get output.
how does the input look like currently? when you fetch it from the excel?
basically if you have spaces after or before each letter you can use Stringreplace .net method to replace all spaces with comma
ok tanq for giving hint neonova
You can achieve this by using read data table , then for each row iterate through each column and you can append the string to the previous one like
Var=var+“,”+col(Val)
can u please sent bot file so that i can analyze.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.