Topic Options
#57880 - 02/22/21 05:11 PM xml: how to keep what's in <>
sygui Offline
OL Expert

Registered: 11/02/10
Posts: 170
Here is part of my xml. In design or watch, when I select <PaymentAmout>, I get 857.490000. Is there a way I get all of it (with the things in <>) ?

<RemittanceAdviceLine>
<LineNumber>1</LineNumber>
<PaymentAmount currencyID="USD">857.49000</PaymentAmount>
<DiscountTakenAmount currencyID="USD">16.33000</DiscountTakenAmount>
</RemittanceAdviceLine>
<RemittanceAdviceLine>
<LineNumber>2</LineNumber>
<PaymentAmount currencyID="USD">3845.85000</PaymentAmount>
<DiscountTakenAmount currencyID="USD">73.25000</DiscountTakenAmount>
</RemittanceAdviceLine>
</RemittanceAdvice>

Top
#57881 - 02/22/21 07:12 PM Re: xml: how to keep what's in <> [Re: sygui]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 651
Loc: Québec, Canada
You'll need to select the attribute of the node in a different data selection. It will show as a child of the node.
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top
#57882 - 02/23/21 09:24 AM Re: xml: how to keep what's in <> [Re: sygui]
sygui Offline
OL Expert

Registered: 11/02/10
Posts: 170
ok I will try. thks. Is there a way to remove all of
<LineNumber>1</LineNumber> ?

Top
#57884 - 02/23/21 09:47 AM Re: xml: how to keep what's in <> [Re: sygui]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 651
Loc: Québec, Canada
You could do it using the Advance Search and Replace plugin with RegEx.
Something like
Code:
/<lineNumber>\d+<\/lineNumber>/g

should do it
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top
#57885 - 02/23/21 10:55 AM Re: xml: how to keep what's in <> [Re: sygui]
sygui Offline
OL Expert

Registered: 11/02/10
Posts: 170
thks I will try

Top
#57886 - 02/23/21 10:57 AM Re: xml: how to keep what's in <> [Re: sygui]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 651
Loc: Québec, Canada
Oh yeah, you'll need to reset your emulation to Line Printer before you use the Advanced Search and Replace plugin.

The set it back to XML after.
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top
#57894 - 02/24/21 06:00 AM Re: xml: how to keep what's in <> [Re: sygui]
sygui Offline
OL Expert

Registered: 11/02/10
Posts: 170
ok thks

Top
#57895 - 02/24/21 06:13 AM Re: xml: how to keep what's in <> [Re: sygui]
sygui Offline
OL Expert

Registered: 11/02/10
Posts: 170
Jean-Cedric, I have a last question: It goes through a design document and I want to output it to a folder. What is the best way to do that ? Actually, I use output to Print using a windows driver (I have created a file printer using Miraplacid text driver), but I have some speed issues.

Top
#57896 - 02/24/21 08:20 AM Re: xml: how to keep what's in <> [Re: sygui]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 651
Loc: Québec, Canada
Hummm...maybe use the Send to Folder plugin wink
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top