Read a tab delimited text file from xslt

Question

Hi everyone,

i need to read a tab delimited text file from xslt. im able to read the text file but im not able to convert the i/p to my desired output format.

the input is like this format.

country  state

USA      Newjersey

USA      Newyork

USA     connecticut

India    Mumbai

India    Delhi

China   Beijing

china   shangai

i want the ouput to be in this following format

USA    Newjersey     Newyork    connecticut

India   delhi         mumbai

china   beijing     shangai

can anyone give me the code for this challenging task. the o/p should be for each country the corresponding state

Answer 1

Hi,

I think you need to use SSIS. in SSIS after you read your data from your source file and think you need to pivot it and then send it to the destination.

http://msdn.microsoft.com/en-us/library/ms140308.aspx

Step by Step examples:

http://www.bimonkey.com/2009/06/the-pivot-transformation/

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_2460-PIVOT-Transformation-SSIS-Complete-Tutorial.html

I hope this is helpful.

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid

MyBlog

Answer 2

in our project there is no SSIS ...there is only XSLT. is there any solution available in XSLT

Answer 3

Hope this link might help you.

http://stackoverflow.com/questions/4912900/modifying-a-xslt-for-converting-xml-to-tab-delimited-text-file