Splitting tilda seperated text into columns

[ckrusen (Calvin Krusen)]

Here’s a hack of a solution (maybe a better one further down in the topic)

String_split in BAQ

To add on to @jdtrent’s comment… Make a sub that returns the top 100 rows(or whatever the max number of fields you expect) of a table that has at least that many rows (parttran always has lots of rows). It only needs 2 fields: Company (just something to link it to the next subquery) Calc field: Name: RowNum Type integer Expression: ROW_NUMBER() OVER(ORDER BY PartTran.TranNum) Now make a subquery with the table containing the field to split , and the above subquery. The Calc field wil…