Dynamic Filtering where data in different postions

Hi All,

I am trying to filter out certain information where the data is below certain keywords in certain instances and on the same line in other instances. I am trying to extract the data as circled in the attachment.

For example, 'Type/Form'-data is below

'Account Number'-data is below

'Currency'-data is below

'Balance:'- Data is next to

I would really appreciate some assistance with this regard.

Thank you 😄

try.PNG

Data Investigation

Accepted answers

All comments

CharlieS

Is the plan to reorganize that information into a data scheme with field names and rows of data? Something like this:

Otherwise, I don't see a reliable way forward in the current format. The per-record filter method would not correctly associate records without a grouping field, and identifying the appropriate content to filter on would be difficult without a data scheme/structure.

AbhilashR

Hi @zodiac01, I mocked up some data to replicate your source file and built a sample solution for you to build upon.

I hope this helps.

sample.yxmd

zodiac01

Hi @CharlieS ,

Yes this is the exact format I need to get it in, The only issue I have is that all the data is in one field as shown in the picture attached.

Kind regards

zodiac01

Hi @AbhilashR ,

Thank you for your response and for the sample workflow, I really appreciate it! This is the format I need to get it in. However the issue that I have is that all the data is in one fields as shown in the picture attached, I am not sure how to approach that.

Kind regards

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703