I checked the encoding and all are ascii.

The sample I was was just snippet of a file to show characteristics

NB+UNOA:1+UCH:ZZ+XXX:ZZ+YYYYYY:2200+12194++ZZZZZZ'UNH

XXX - is Sender

YYYYYY - Date

ZZZZZZ - RecordType

First record is always...

I ran into another file format for the EDIFACT in files... They all appear to be ASCII files

sample:

UNB+UNOA:1+UCH:ZZ+XXX:ZZ+YYYYYY:2200+12194++ZZZZZZ'UNH

XXX - is Sender

YYYYYY - Date

ZZZZZZ - RecordType

First record is always the UNB...

Cool.

That Insert's as it reads the files correct?

Thanks.

I was running into issue where in original PS was pulling back Sender,Date and RecordType(all working good), but in comparing to database records there an issue with dates. I wanted...

Jeffery,

You seem to know each component that I've been asking questions(SQL-EDI and very good with PowerShell). I have a question since the Interchange table in EDI basically has the information...

I used SP and called from PS script.

$TP = Read-Host "Enter Trading Partner"

$Date = Read-Host "Enter Date (YYMMDD)"

$Doc = Read-Host "Enter Doc Type (2-Digits)"

$QueryText = "exec dbo.usp_sp_get_filenames '88899', '200115','Sh'"

$SqlConnection =...

How can I take the Parms from script and connect to SQL and run a query using the Parms from above?

# Check for at least one parameter selected

if ($Sender -eq...

The table was updated from a SQL script that read interchange table to pull information. Now I want to strip the filename from

table and pass that to PS script to...

SO I created a table in SQL that has many of the key fields

doc_bu

doc_tp

doc_filename

doc_date

doc_type

The doc_filename has the file name that the PS script found, and the pointer on disk. How...

I just needed to include an exclusion for the corrupt files, but other than that it worked great...

I'm going to add a Progress-Bar to keep user informed of the search......

Very cool!!!  I'm going to run it thru the folders and see how it works.

Thanks again, and will report back results...

Okay so I dumped my search folders to a file using out-file, and found that I have 3 different types of encoding.

most are ascii, and I have utf8, and there...

If it hits a file that doesn't match criteria check, instead of dropping a message out to ISE could it just log that file, and continue

searching without throw error's to...

You where correct about encoding of files it hit other files in folders and gave error messages. I know you gave examples of how to check, but not sure I...

The records I have in Inbound won't change, and it made it all the way thru the sub-folders without hitting any errors, I'm going to try and run it with...