Alteryx Designer Desktop Discussions

NiranjanK1 · ‎03-31-2020

Hello All,

From below HTML script i have to filter only data, kindly help me.

The field have only "SSRS" data

Thanks,

NK

DavidP · ‎03-31-2020

This magical formula removes html stuff.

fmvizcaino · ‎03-31-2020

Hi @NiranjanK1 ,

I'm attaching one example that uses the string to know where your data is.

Of course it will only work if you don't have any other occurrence of the same string.

Best,

Fernando Vizcaino

NiranjanK1 · ‎04-01-2020

@fmvizcaino, Thanks a lot for your reply, live data is not replacing dynamically Kindly help me

Actual Data: "Not providing regulatory disclosures, or providing inaccurate, regulatory required confirmations, disclosures, receipts, delay/cancellation notifications, or proof of payment that funds were transferred for Domestic and International transfers, due to manual errors or systemic breaks which can result in operational losses and regulatory impacts (e.g. Reg E, UDAAP)."

<div>

Not providing regulatory disclosures
, or providing inaccurate, regulatory required
confirmations, disclosures, receipts, delay/cancellation notifications, or
proof of payment that funds were transferred for Domestic and International
transfers, due to manual errors or systemic breaks which can result in
operational losses and regulatory impacts (e.g. Reg E, UDAAP).

</div>
</html></div>

NiranjanK1 · ‎04-01-2020

@david, Thanks a lot for your reply, Below HTML format data will change on dynamically for below data im on getting complete information. Kindly help me

Actual Data: "Not providing regulatory disclosures, or providing inaccurate, regulatory required confirmations, disclosures, receipts, delay/cancellation notifications, or proof of payment that funds were transferred for Domestic and International transfers, due to manual errors or systemic breaks which can result in operational losses and regulatory impacts (e.g. Reg E, UDAAP)."

<div>

Not providing regulatory disclosures
, or providing inaccurate, regulatory required
confirmations, disclosures, receipts, delay/cancellation notifications, or
proof of payment that funds were transferred for Domestic and International
transfers, due to manual errors or systemic breaks which can result in
operational losses and regulatory impacts (e.g. Reg E, UDAAP).

</div>
</html></div>

NiranjanK1 · ‎04-01-2020

@fmvizcaino, Thanks a lot for your reply, live data is not replacing dynamically Kindly help me

Actual Data: "Not providing regulatory disclosures, or providing inaccurate, regulatory required confirmations, disclosures, receipts, delay/cancellation notifications, or proof of payment that funds were transferred for Domestic and International transfers, due to manual errors or systemic breaks which can result in operational losses and regulatory impacts (e.g. Reg E, UDAAP)."

<div>

Not providing regulatory disclosures
, or providing inaccurate, regulatory required
confirmations, disclosures, receipts, delay/cancellation notifications, or
proof of payment that funds were transferred for Domestic and International
transfers, due to manual errors or systemic breaks which can result in
operational losses and regulatory impacts (e.g. Reg E, UDAAP).

</div>
</html></div>

NiranjanK1 · ‎04-01-2020

@ fmvizcaino, Thanks a lot for your reply, live data is not replacing dynamically Kindly help me

Actual Data: "Not providing regulatory disclosures, or providing inaccurate, regulatory required confirmations, disclosures, receipts, delay/cancellation notifications, or proof of payment that funds were transferred for Domestic and International transfers, due to manual errors or systemic breaks which can result in operational losses and regulatory impacts (e.g. Reg E, UDAAP)."

<div>

Not providing regulatory disclosures
, or providing inaccurate, regulatory required
confirmations, disclosures, receipts, delay/cancellation notifications, or
proof of payment that funds were transferred for Domestic and International
transfers, due to manual errors or systemic breaks which can result in
operational losses and regulatory impacts (e.g. Reg E, UDAAP).

</div>
</html></div>

NiranjanK1 · ‎04-01-2020

@fmvizcaino, Thanks a lot for your reply, live data is not replacing dynamically Kindly help me

Actual Data: "Not providing regulatory disclosures, or providing inaccurate, regulatory required confirmations, disclosures, receipts, delay/cancellation notifications, or proof of payment that funds were transferred for Domestic and International transfers, due to manual errors or systemic breaks which can result in operational losses and regulatory impacts (e.g. Reg E, UDAAP)."

<div>

Not providing regulatory disclosures
, or providing inaccurate, regulatory required
confirmations, disclosures, receipts, delay/cancellation notifications, or
proof of payment that funds were transferred for Domestic and International
transfers, due to manual errors or systemic breaks which can result in
operational losses and regulatory impacts (e.g. Reg E, UDAAP).

</div>
</html></div>

DavidP · ‎04-01-2020

Try this

NiranjanK1 · ‎04-01-2020

@DavidP Thanks a lot for your quick reply is this works for multiple fields, i have attached multiple fields im download in from the Database.

Alteryx Designer Desktop Discussions

Filter data from HTML data

Zero to Advanced in 20 days

Re: Zero to Advanced in 20 days

Re: Zero to Advanced in 20 days

Passed the Advanced Certification Exam!

Re: Identify duplicates in a specific column, and ...