Text-to-columns in BAQ

Epicor ERP 10
,
1

We have order line descriptions that contains all the info we need, but I’d like to split it up in different columns. Is there a way to split these up using a calculated field?

Here’s an example -
Part Num - Part Description
12312 - TeamName - 123PACK - 12 (12312)

How would I go by making some calculated fields so that at first it takes everything behind the first “-”, then the second field would be after the first “-”, then the third field would be after the second “-”, etc. ??

2

I can get a field to display anything before the first “-” by using the command:

SUBSTRING(OrderDtl.LineDesc, 0, CHARINDEX(‘-’, OrderDtl.LineDesc, 0))

But I can’t grab the info after the “-” and so on…

3

In the Operators section, Under Ranges, see Entry:

image
image.png1150×750 113 KB

Mark W.

4

That does the trick… Now I think I should try to combine this with another command to get it to the way we need it.

Thanks Mark.