DSXchange

Hi Guys,

Try to change the Length and Display values.. I think it will work.

Srini
BB

hi all, In excel sheet my source data is in the following format --------------A--------B-----C-----D---- ======================== |Headers----------> Cust1 Cust2 Cust3 | |Row 1--->month01 01d1 01d2 01d3 |Row 2--->month02 02d1 NULL 02d3 |Row 3--->month03 03d1 03d2 NULL |Row 4--->month04 04d1 04d2 04...

hi all, In excel sheet my source data is in the following format --------------A--------B-----C-----D---- ======================== |Headers----------> Cust1 Cust2 Cust3 | |Row 1--->month01 01d1 01d2 01d3 |Row 2--->month02 02d1 NULL 02d3 |Row 3--->month03 03d1 03d2 NULL |Row 4--->month04 04d1 04d2 04...

Can u give the value of "Tab" so that i can pull data when it is seperated by Tab Space. And one more, i am trying to pull data from Excel sheet. Suppose the data is in the following format. ~~~~~ dealer1 dealer2 dealer3 month01 01d1 01d2 01d3 month02 02d1 NULL 02d3 month03 03d1 03d2 NULL ...

Thanks buddy, I tried by using ASCII value 032. Its working. Can u give the value of "Tab" so that i can pull data when it is seperated by Tab Space. And one more, i am trying to pull data from Excel sheet. Suppose the data is in the following format. ~~~~~ dealer1 dealer2 dealer3 month01 ...

Hi to all, Here is Cnu. Dont think that i am asking silly question, but i did more with sequencial stage but i don't know how to get data when the data is seperated with Space . I tried with ASCII value 045 . But it is giving "Too many columns" or "Required col is missing". Can a...