Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
Stylus Studio Technical Forum
»
One field in multiple lines
Topic
Topic Page
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Prev Topic
Next Topic
next
Subject:
One field in multiple lines
Author:
adriana abegao
Date:
23 Nov 2007 02:25 PM
Hi everybody !
I need convert a flat file with TAB separator in XML. The problem is some of this fields start in one line and finish in other.
For example :
COD. DESCRIPTION DATE
1 TESTXXXXXXXXXXXXXXXXXXX23/11/2007
XXXXXXXXXXXXXXXXXXX
2 TEST2XXXXXXXXXXXXXXX 23/11/2007
I need read field "Description" like if it continue in same line.
Can someone help me ? The file is attached.
Thanks !
NFE3.txt
next
Subject:
One field in multiple lines
Author:
Minollo I.
Date:
23 Nov 2007 04:05 PM
A way to handle it is a combination of XML Converters and XQuery; in Stylus you can try it out:
let $tabDelimited := doc('converter:TAB:first=yes:collapse=no?file:///c:/NFE3.txt')
return
<items>
{
for $row at $pos in $tabDelimited/table/row
return
if (string-length($row/COD.PROD/text()) > 0) then
<item>
<code>
{$row/COD.PROD/text()}
</code>
<description>
{concat($row/DESCRIÇÃO__________________/text(),
if( string-length($tabDelimited/table/row[$pos+1]/COD.PROD/text()) = 0) then
$tabDelimited/table/row[$pos+1]/DESCRIÇÃO__________________/text()
else "")
}
</description>
<ncm>
{$row/NCM/text()}
</ncm>
<cst>
{$row/CST/text()}
</cst>
<cfop>
{$row/CFOP/text()}
</cfop>
</item>
else
()
}
</items>
top
Subject:
One field in multiple lines
Author:
adriana abegao
Date:
26 Nov 2007 01:21 PM
Thank you !
You help me so much.......
Topic Page
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Prev Topic
Next Topic
Powered by
Stylus Studio
, the world's leading
XML IDE
for
XML
,
XSLT
,
XQuery
,
XML Schema
,
DTD
,
XPath
,
WSDL
,
XHTML
,
SQL/XML
, and
XML Mapping
!
Go to Conference:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.