Character #83 = Repetition Element Separator   ===>  U

Character #105 = Composite Element Separator      ===>   >

Character #106 = Segment Separator (we need this one)   ====> {

Character #4 = Data...

When they first sent me a record layout it was individual records or that's what they sent. Not until I opened one of the files did I notice it was...

param (
[parameter(mandatory = $true, ValueFromPipelineByPropertyName = $true)][string]$hdr,
[parameter(mandatory = $true, ValueFromPipelineByPropertyName = $true)][string]$date,
[parameter(mandatory = $true, ValueFromPipelineByPropertyName = $true)][string]$recordtype
)

# Get list of files
$fileList = Get-ChildItem -Path c:\ftp_in | Where-Object...

I was thinking of using bat or cmd because to use posh file the user who is requesting the lookup from script would have to how to launch the script...

The Move\Copy file is going to be used as research for customer related issues. I would like to wrap the script in a .cmd

or bat file. That's where I was...

The above lookups are in the 1st record in file using criteria above. I need some help ...

THanks.

SO there is a default format for inbound files

Position 36 of the record contains 1st parm and has a length of 15

Position 71 of record contains 2nd parm and in...

thanks you are correct EDI related files... I'm trying to have a search script to find files in folders based upon the parms passed...

I'll give it a go with the...

I found more info on the file, for an Inbound record it will have this format, so maybe the delimiter is *

I highlited  the 1st and 2nd parm lookups   ...

My data is just text and the date format yymmdd(210310 sample) I don't have any delimiters in the file to be able to deliniate

data records other than the ear marks...

Cool Thanks again!!!!

Data:

src,200,2021,01,01,400.00

xrb,200,2021,01,01,500.00

src,300,2021,02,01,400.00

xrb,300,2021,02,01,500.00

I would like to rollup the data at a monthly level by year entity and channel. If no data reported for the month than 0 displayed

Jan         ...

I want to show current year and previous.. do you have any examples based upon my current query?

Thanks again...

• This reply was modified 4 years, 7 months ago by Bruin.

I would like to be able to run this for a given Year, is that possible using crosstabs?

Thanks again

I was trying to get the days so they would be dynamic rather than having to hard those each month.. I also wanted

the channel to be sub-category of the entity..

Thanks.