Extract data from multiple lines column

6 years ago
9 May 2017
4 replies
1 view

mkriznja
12 replies

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!

4 replies

Userlevel 4

paul_crawford
Scholar
165 replies
6 years ago
9 May 2017

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

‌ ‌ ‌