No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
I am trying to load XML files into SQL server database using SQLXML4.0 I have relation defined as such: [code] <xs:annotation> <xs:appinfo> <sql:relationship name="ApplicantPhone" parent="Applicant" parent-key="PQNumber" child="Phone" child-key="PQNumber" /> </xs:appinfo> </xs:annotation> [/code] and then I am using the relations as follows: [code] <xs:element minOccurs="0" maxOccurs="unbounded" name="CustPhone" sql:relation="Phone" sql:relationship="ApplicantPhone"> <xs:complexType> <xs:sequence> …
I want to get out put as folows: [code] 100 HE01 {number of line in this file} {file created on time stamp} 200 LTXS {number of line in this file} {file created on time stamp} (if the file does not exist then it should say FILE NOT AVAILABLE [/code] to …
Have you tried ls and then pipe the out put to sed and replace all spaces with single space?
The End.