extract specific words and its data from html/xml file Announcing the arrival of Valued...

Antler Helmet: Can it work?

Complexity of many constant time steps with occasional logarithmic steps

Classification of bundles, Postnikov towers, obstruction theory, local coefficients

Stars Make Stars

Can a zero nonce be safely used with AES-GCM if the key is random and never used again?

When communicating altitude with a '9' in it, should it be pronounced "nine hundred" or "niner hundred"?

How can players take actions together that are impossible otherwise?

What LEGO pieces have "real-world" functionality?

If A makes B more likely then B makes A more likely"

Strange behaviour of Check

Passing functions in C++

Can a non-EU citizen traveling with me come with me through the EU passport line?

What is the order of Mitzvot in Rambam's Sefer Hamitzvot?

Why is there no army of Iron-Mans in the MCU?

What can I do if my MacBook isn’t charging but already ran out?

Area of a 2D convex hull

How should I respond to a player wanting to catch a sword between their hands?

How does modal jazz use chord progressions?

Direct Experience of Meditation

Slither Like a Snake

Active filter with series inductor and resistor - do these exist?

Choo-choo! Word trains

What do I do if technical issues prevent me from filing my return on time?

Is there a service that would inform me whenever a new direct route is scheduled from a given airport?

extract specific words and its data from html/xml file

Announcing the arrival of Valued Associate #679: Cesar Manara

Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)

2019 Community Moderator Election Results

Why I closed the “Why is Kali so hard” questionExtract multiple line string from HTML file using specific tagsExtract Values from HTML via HTML parserExtract values from HTML FilesExtract specific value from blocks of dataExtract specific value from block of dataExtract value from XMLExtracting data from tags in XML resultsetHow to extract data from XML FileUsing bash to replace html character entities in the xml fileextract specific words and its data from file

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

sample input is

<bre rt="1600" et="1550794901464" st="1550794899864" tid="8390500116294391399" mh="N" cn="" lc="" ts="N/A" cidc="" IDC="" eidc="BRE-S-TRA-0085418501"/>

    <r1>

        <gr1>

            <a="1" b="smaple data with spaces" c="Created TrasctionInfo" d="1550794901228"/>

            <e="INITIAL" f="2" g="INITIAL_LEGACY" h="1550794901228" i="LegacyToggle is off. Follow Legacy flow"/>

            <lx ets="2019-02-22T00:21:41.228Z" trxn="smaple data with spaces 2 record" rn="Derive data" abc="COT def" def="Season occur" trxn="smaple data with spaces 3rd record" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="smaple data with spaces 5th record" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" trxn="other data with spaces" c="Created Info" d="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" trxn="another record data" rn="Derive data" abc="COT def" trxn="smaple data with spaces record" def="Season occur" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="data with spaces" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" c="Created transaction" b="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" rn="Derive data" abc="COT def" def="Season occur" den="andys and others" kit="Theater - Span day"

             rns="Span day" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

output should be

tid="8390500116294391399"

ts="N/A"

ets="2019-02-22T00:21:41.228Z" 

trxn="smaple data with spaces 2 record"

trxn="smaple data with spaces 3rd record"

trxn="smaple data with spaces 5th record"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z" 

trxn="other data with spaces"

trxn="another record data"

trxn="smaple data with spaces record"

trxn="data with spaces"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z"

I tried like below

sed -e 's/trxn=/ntrxn=/g' -e 's/tid=/ntid=/g' -e 's/ts=/nts=/g'



while IFS= read -r var

do

    if grep -Fxq "$trxn" temp2.txt

    then

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /trxn/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    else

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    fi

done < "$input"

edited 2 mins ago

msp9011

4,61344167

asked 19 mins ago

BNRINBOX

New contributor

add a comment |

sample input is

<bre rt="1600" et="1550794901464" st="1550794899864" tid="8390500116294391399" mh="N" cn="" lc="" ts="N/A" cidc="" IDC="" eidc="BRE-S-TRA-0085418501"/>

    <r1>

        <gr1>

            <a="1" b="smaple data with spaces" c="Created TrasctionInfo" d="1550794901228"/>

            <e="INITIAL" f="2" g="INITIAL_LEGACY" h="1550794901228" i="LegacyToggle is off. Follow Legacy flow"/>

            <lx ets="2019-02-22T00:21:41.228Z" trxn="smaple data with spaces 2 record" rn="Derive data" abc="COT def" def="Season occur" trxn="smaple data with spaces 3rd record" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="smaple data with spaces 5th record" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" trxn="other data with spaces" c="Created Info" d="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" trxn="another record data" rn="Derive data" abc="COT def" trxn="smaple data with spaces record" def="Season occur" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="data with spaces" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" c="Created transaction" b="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" rn="Derive data" abc="COT def" def="Season occur" den="andys and others" kit="Theater - Span day"

             rns="Span day" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

output should be

tid="8390500116294391399"

ts="N/A"

ets="2019-02-22T00:21:41.228Z" 

trxn="smaple data with spaces 2 record"

trxn="smaple data with spaces 3rd record"

trxn="smaple data with spaces 5th record"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z" 

trxn="other data with spaces"

trxn="another record data"

trxn="smaple data with spaces record"

trxn="data with spaces"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z"

I tried like below

sed -e 's/trxn=/ntrxn=/g' -e 's/tid=/ntid=/g' -e 's/ts=/nts=/g'



while IFS= read -r var

do

    if grep -Fxq "$trxn" temp2.txt

    then

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /trxn/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    else

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    fi

done < "$input"

edited 2 mins ago

msp9011

4,61344167

asked 19 mins ago

BNRINBOX

New contributor

add a comment |

sample input is

<bre rt="1600" et="1550794901464" st="1550794899864" tid="8390500116294391399" mh="N" cn="" lc="" ts="N/A" cidc="" IDC="" eidc="BRE-S-TRA-0085418501"/>

    <r1>

        <gr1>

            <a="1" b="smaple data with spaces" c="Created TrasctionInfo" d="1550794901228"/>

            <e="INITIAL" f="2" g="INITIAL_LEGACY" h="1550794901228" i="LegacyToggle is off. Follow Legacy flow"/>

            <lx ets="2019-02-22T00:21:41.228Z" trxn="smaple data with spaces 2 record" rn="Derive data" abc="COT def" def="Season occur" trxn="smaple data with spaces 3rd record" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="smaple data with spaces 5th record" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" trxn="other data with spaces" c="Created Info" d="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" trxn="another record data" rn="Derive data" abc="COT def" trxn="smaple data with spaces record" def="Season occur" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="data with spaces" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" c="Created transaction" b="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" rn="Derive data" abc="COT def" def="Season occur" den="andys and others" kit="Theater - Span day"

             rns="Span day" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

output should be

tid="8390500116294391399"

ts="N/A"

ets="2019-02-22T00:21:41.228Z" 

trxn="smaple data with spaces 2 record"

trxn="smaple data with spaces 3rd record"

trxn="smaple data with spaces 5th record"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z" 

trxn="other data with spaces"

trxn="another record data"

trxn="smaple data with spaces record"

trxn="data with spaces"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z"

I tried like below

sed -e 's/trxn=/ntrxn=/g' -e 's/tid=/ntid=/g' -e 's/ts=/nts=/g'



while IFS= read -r var

do

    if grep -Fxq "$trxn" temp2.txt

    then

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /trxn/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    else

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    fi

done < "$input"

edited 2 mins ago

msp9011

4,61344167

asked 19 mins ago

BNRINBOX

New contributor

sample input is

<bre rt="1600" et="1550794901464" st="1550794899864" tid="8390500116294391399" mh="N" cn="" lc="" ts="N/A" cidc="" IDC="" eidc="BRE-S-TRA-0085418501"/>

    <r1>

        <gr1>

            <a="1" b="smaple data with spaces" c="Created TrasctionInfo" d="1550794901228"/>

            <e="INITIAL" f="2" g="INITIAL_LEGACY" h="1550794901228" i="LegacyToggle is off. Follow Legacy flow"/>

            <lx ets="2019-02-22T00:21:41.228Z" trxn="smaple data with spaces 2 record" rn="Derive data" abc="COT def" def="Season occur" trxn="smaple data with spaces 3rd record" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="smaple data with spaces 5th record" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" trxn="other data with spaces" c="Created Info" d="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" trxn="another record data" rn="Derive data" abc="COT def" trxn="smaple data with spaces record" def="Season occur" den="andys and others" trxn="smaple data with spaces 4th record" kit="Theater - Span day"

             rns="Span day" trxn="data with spaces" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

<bre rt="1234" et="1234794901464" st="1234794899864" tid="2345500116294391399" mh="Y" cn="At123" lc="" ts="NA" cidc="" IDC="some text value" eidc="abc-def-gh-2385418501"/>

    <r1>

        <gr1>

            <a="1" c="Created transaction" b="3434794545228"/>

            <e="begin" f="2" g="INITIAL_LEGACY" h="1234709901228" i="Toggle hig. Follow toggle flow"/>

            <lx ets="2017-02-22T00:21:41.228Z" rn="Derive data" abc="COT def" def="Season occur" den="andys and others" kit="Theater - Span day"

             rns="Span day" off="|"/>

            <cwl wc="2.0766" tot="16" act="116.28960000000001" CSE="CHE-CSFL" wg1.0" high="1" </cwl>

                </gr1>

            </r1>

</bre>

output should be

tid="8390500116294391399"

ts="N/A"

ets="2019-02-22T00:21:41.228Z" 

trxn="smaple data with spaces 2 record"

trxn="smaple data with spaces 3rd record"

trxn="smaple data with spaces 5th record"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z" 

trxn="other data with spaces"

trxn="another record data"

trxn="smaple data with spaces record"

trxn="data with spaces"

tid="2345500116294391399"

ts="NA"

ets="2017-02-22T00:21:41.228Z"

I tried like below

sed -e 's/trxn=/ntrxn=/g' -e 's/tid=/ntid=/g' -e 's/ts=/nts=/g'



while IFS= read -r var

do

    if grep -Fxq "$trxn" temp2.txt

    then

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /trxn/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    else

      awk -F"=" '/tid/{print VAL=$i} /ts/{print VAL=$i} /ets/{print VAL=$i} /tid/{print VAL=$i;next}' temp2.txt >> out.txt

    fi

done < "$input"

xml text html word-processing words

edited 2 mins ago

msp9011

4,61344167

asked 19 mins ago

BNRINBOX

New contributor

edited 2 mins ago

msp9011

4,61344167

asked 19 mins ago

BNRINBOX

New contributor

edited 2 mins ago

msp9011

4,61344167

edited 2 mins ago

msp9011

4,61344167

edited 2 mins ago

msp9011

4,61344167

asked 19 mins ago

BNRINBOX

New contributor

asked 19 mins ago

BNRINBOX

asked 19 mins ago

BNRINBOX

New contributor

BNRINBOX is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment |

0

active

oldest

votes

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

BNRINBOX is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f512484%2fextract-specific-words-and-its-data-from-html-xml-file%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

0

active

oldest

votes

0

active

oldest

votes

BNRINBOX is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

BNRINBOX is a new contributor. Be nice, and check out our Code of Conduct.

Thanks for contributing an answer to Unix & Linux Stack Exchange!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Mdthbs