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

Include spaces in your output for set variable from retriving text

Jump to solution

Hi,

 

Im trying to retrive the information of languages using the Set variable from a text i notes. The text I am trying to extract is the following:

 

Languages

Svenska  (Native or Bilingual)
Engelska  (Professional Working)

Certifications

 

And the Set variable Value I am using are as follows:
[?Between([?Clean([?Remove([%PDFtext],,,True)])],"Languages","Certifications")]

 

Although the value I am retriving is:

Svenska(NativeorBilingual)Engelska(ProfessionalWorking)

Where the retriving text is lacking spaces. How do I retrive the text where its including the blankspaces between the different languages?

 

Thanks in advance!

 

Johan

 

 

 

0 Kudos
Reply
2 Replies
Highlighted
Nintex Newbie

Re: Include spaces in your output for set variable from retriving text

Jump to solution

Hi @Schmidet (Johan),

 

I'm not sure why you are using the "Remove" formula? That is what is getting rid off the spaces.

There are many ways of solving this, it would probably be easiest to use the Regular Expression action under Advanced if you have experience with that. Otherwise, I've made a quick example with some screenshots.

Essentially, the trick is to use something like "|" in your "Clean" formula so that you actually know where the linebreaks where. Then you can use formulas on that. I'm not quite sure what your desired output is, whether you want the languages together in a single variable comma-separated or every language in an individual variable.

Let me know if you are able to solve it with inspiration from these screenshots.

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: Include spaces in your output for set variable from retriving text

Jump to solution

Hi Mathias,

 

thanks for the quick reply. I got it to worke due to your solution, so thats perfect.

If you are in Stockholm in the nere furure hit me up I owe you a cold one.

 

Cheers,

Johan

0 Kudos
Reply