Skip to main content
Nintex Community Menu Bar
Solved

Include spaces in your output for set variable from retriving text

  • January 15, 2020
  • 2 replies
  • 42 views
S

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

 

 

 

Best answer by mbalslow

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.

    2 replies

    mbalslow
    • mbalslow
    • 32 replies
    • Answer
    • January 15, 2020

    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.

    S
    • Schmidet
    • Author
    • 2 replies
    • January 16, 2020

    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


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement