Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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.
Solved! Go to Solution.
Hi @Anonymous
Sure, just manually adjust the script after as per below.
Hi @Anonymous
Sure, just manually adjust the script after as per below.
I swear that was the first thing I wrote but got an error. Probably misspelled something. Thanks!