I have the following EDI message and have the following statement in a query;
In this particular line, the number of characters is variable until the ','. So what I need to do is bring in 3493 in this case but if it was 99999, then I would need to bring in 99999 and so forth. It is whatever value from the / to the ,.
The above code is bring in characters from the next line. How do you stop at the ','?
I was trying the charindex function but without much luck. Any ideas?