Forum Discussion
Post PatronPull 2 words separated by dashes to make new Column
You could try otherwise:
try Text.BetweenDelimiters([PartNumber],"-","-",1,1) otherwise Text.BetweenDelimiters([PartNumber],"-","-",1,1)
It should allow you to find the errors, then you can analyse the reason why it failed and modify your Add Column.
Hi unclejemima,
In your Edit Query follow these steps:
1) Highlight the column you want to separate.
2) Click on "Add Column" tab from your ribbon.
3) Click on the Drop Down for "Column from examples" and select "From Selection"
4) In your first line, type Kaffee-German and press enter.
This should auto fill the rest of your cells to pull the information you want.
Hope this helps!
zapps
unclejemimaThis is cool...let me try!
- unclejemima
I must be doing something wrong...not working. See screenshot...
- unclejemima
I'm assuming its because there are other (many tens of thousands of codes) that don't start with "55-D"
Perhaps I need to make a column that shows them only shows the parts if they start with "55-D"...and then I can apply the "Add Column>from Example> from Selection?"
Thoughts?