Yes, that does look like it worked.:Wow:

Thanks Steve for taking the time to review and solve!

Really sorry about the confusion (I know better)!

Here is a data example. I replaced the tab with a pipe '|'.

The item in read is the issue. The other files are...

I tried but in some cases the string is to long and it pulls the # plus a few digits from the next field. I was under the impression that...

Then only element that has a delimiter of '#' is the ID, the ID literally has the '#'.

The file is delimited by Tabs and <cr><lf>.

Anyone with a suggestion?

Does anyone have a suggestion?

Lutz thanks for your time.

The job owner is sa, so that cannot be the issue.

I'll post the code and sample of data.

The sp should calculate AcDedAmtIn as:

MaID ...