DSXchange

Hi Kandy, Thanks for the response. The number of lines are not constant and also since there are a large number of files ,i will have multiple StatusCodeText,RequestHeaderSize and other fields names.. For the XML part i tried by looking for the charecter "<" and picking the entire XML till...

hi Shekar,

Thanks for response.
If its possible to read entirely in Datastage then would like to g o ahead with it else will try out you approach too.


Thanks.

Hi Ray, The file as we saw conatins XML content as well. The target table contains columns for whihc data has to be extracted from XML content and the other data. Please see the extract from the file. StatusCode=200 StatusCodeText=OK RequestHeaderSize=301 RequestDataSize=2122 RequestSize=2423 Respon...

Hi Craig,

Do you want any more information or the entire file?

Please help me to read this file.


Thanks.

Hi,

In a file if i have data like this.

Col1
It costs me $100 for books.


How to read from "$" till the end of file?.

Thanks,
Chetan

A sample from the file [env] REQ_BUFFER_ENCODING=UTF-8 REQ_BUFFER_ORIG_ENCODING=UTF-8 RESP_BODY_ENCODING=UTF-8 REQ_BUFFER_ENCODING This should be my column name. UTF-8 -----Data under that coulmn Similarly for all other fileds. Also there is an XML portion in the file. Kindly guide me to read this f...

Hi, I have a file which is like this. How to read this file. [iamie] TLTSID=EC2172542B72102BB5AE2D89C82DEAEC TLTHID=EC2172542B72102BB5AE2D89C82DEAEC CaptureType=1 CaptureVersion=3330 [appdata] [env] REQ_BUFFER_ENCODING=UTF-8 REQ_BUFFER_ORIG_ENCODING=UTF-8 RESP_BODY_ENCODING=UTF-8 [privacy] response|...