Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Variable skip by delimiter based on other column

Is there any way in Power Query to reference another column as the number of delimiters to skip?

 

...
#"Inserted Text Between Delimiters" = Table.AddColumn(#"Previous step", "Text Between Delimiters", each Text.BetweenDelimiters([COLUMN_TO_EXTRACT], "#(cr)", "#(cr)", ¿¿COLUMN REFERENCE??, 0), type text),
...

 

 

Best regards.

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Sure, just manually adjust the script after as per below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Sure, just manually adjust the script after as per below.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I swear that was the first thing I wrote but got an error. Probably misspelled something. Thanks!