Forum Discussion

vineshparekh's avatar
vineshparekh
Icon for Helper I rankHelper I
2 years ago

Help required to separate the text

Hi Experts,   I have the following messy data and unorganized column extracted from PDF which requires separating the data in [ ] to another column. For example,  AF-20KC - Airframe 20,000 FC Str...
Need Help
Tips and Tricks
vineshparekh's avatar
vineshparekh
Icon for Helper I rankHelper I
2 years ago

Hi dufoq3 

Thank you for the response! 

I am getting this error when I use the M code you provided. This is coming from Ad_GroupHelper step.

Expression.Error: The 'offset' argument is out of range.

dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

vineshparekh, I've edited the code above. Try it now.