cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
mkriznja
Nintex Newbie

Extract data from multiple lines column

Jump to solution

Hello,


I'm using Nintex 2013, and I would like to make a list to update the daily exchange rates.
Using query XML action I get data from web page LINK. The data I received I wrote in multiple lines text field (plain text) and now I would like to extract currencies into special fields.

 

The data I got looks like this:

088080520170905201713
036AUD001       5,018108       5,033208       5,048308
124CAD001       4,955340       4,970251       4,985162
203CZK001       0,277378       0,278213       0,279048
208DKK001       0,996105       0,999102       1,002099
348HUF100       2,381456       2,388622       2,395788
392JPY100       6,021485       6,039604       6,057723
578NOK001       0,784763       0,787124       0,789485
752SEK001       0,766287       0,768593       0,770899
756CHF001       6,814048       6,834552       6,855056
826GBP001       8,782731       8,809158       8,835585
840USD001       6,774171       6,794555       6,814939
978EUR001       7,408233       7,430525       7,452817
985PLN001       1,763823       1,769130       1,774437

And now I want to extract the name of currency and the middle column of each currency.

Can someone help me? Thanks!

Labels: (2)
0 Kudos
Reply
4 Replies
paul_crawford
Nintex Newbie

Re: Extract data from multiple lines column

Jump to solution

hi

Using the query xml you should save the output into collection variables.

If you query the xml to get the first column (currency) and the third column (rate) you can then do a foreach on the first collection and use a integer variable (default value of 0) which will increment on each pass of the foreach and in the foreach, use a get collection operation based on the index which will return the matching rate.

Have a look at these: 

Let me know if you need any more help

Reply
mkriznja
Nintex Newbie

Re: Extract data from multiple lines column

Jump to solution

Thans for your help !

I have a few more questions. Now my workflow goes like this.

First I Query XML

And then I use Rexular expression - split on vColInfo , but which pattern should I use?

 

And do I have to remove these numbers from the beginning in first row, if yes, how?

 

Thanks a lot!

Reply
paul_crawford
Nintex Newbie

Re: Extract data from multiple lines column

Jump to solution

Hi

Can you post the raw xml so i can see this and help you?

0 Kudos
Reply
mkriznja
Nintex Newbie

Re: Extract data from multiple lines column

Jump to solution

Hi

I did it, thanks for your help!

0 Kudos
Reply