I have a text file in which data is in below given format. Its a text delimited file with 10000 lines of data. Main columns are given below though there are many more columns. Supplier_Name|Supplier_Address_1|Supplier_Postcode|VAT_Reg ACCOMMODATION|P O Box 123|3404|11009341296 PROVIDERS|P O Box 5…

@Dave - Its working now… but it is showing results for all supplier’s but my requirement is to see only result for those supplier’s whose VAT_Reg id is below then 11 digit… It is giving result in below format - Party_Identification_No : Company_Number : Company_Name : Suppli…

Please post your current command you are running. Dave’s command should do what you are asking, so we would need to look at the command you are running.

Hi Rob, This is the command what i am running on my workstation. Import-Csv -Path C:\Users\ankit\Downloads\SC\SupplierExtract.txt -Delimiter ‘|’ | Where-Object { $_.VAT_Reg.Length -lt 11 } I have gave path with and without single quotes but both time giving the same results. Thanks Ankit

Ok, so let’s troubleshoot and see what is going on. When importing from a CSV, everything is typically a string, which contains Length property. If for some reason the value is being converted to a different type, (e.g. int) it could be causing your issue. Try running this and see what the output…

Hi Simmers, Apologies for the late reply… I just stuck with this site login problem and it was late night too… really its a weird site… Anyhow i executed your given query but again its giving error You cannot call a method on a null-valued expression. At line:1 char:195 I tried to execute this q…

Try this, as a troubleshooting step. Please post the output here: Import-Csv -Path C:\Users\ankit\Downloads\SC\SupplierExtract.txt -Delimiter '|' | Get-Member

Hi Dave, Please find the below given output… Thanks TypeName: System.Management.Automation.PSCustomObject Name MemberType Definition Equals Method bool Equals(System.Object obj) GetHashCode Method int GetHashCode() GetType …

Ankit, Dave’s code should absolutely do the trick. I copied and pasted your data from the original question into a file called “input.txt”, then ran Dave’s online against it. It seemed to do the trick quite nicely. Here is the Import-Csv before filtering out the ones longer than 11 characters P…

@Dave - Here is the below output by the command you have given…Thanks TypeName: System.Management.Automation.PSCustomObject Name MemberType Definition —- ———- ———- Equals Method bool Equals(System.Object obj) GetHashCode Method int GetHashCode() GetType Method type GetType() ToString Method s…

@Curtis @Dave - Your script is right. I am sorry… I am wrong…I also made one dummy text delimited file and insert only below values to it and it fetched the actual output from the file i.e. only for “PROVIDERS” Supplier_Name Supplier_Address_1 Supplier_Postcode VAT_Reg ACCOMMODATION P O Box 123 3…

How to read and parse a text file

PowerShell Help

ankit-parmar August 13, 2015, 2:45pm 22

yes… exactly what I want … thanks

Topic		Replies	Views
Reading Text Files PowerShell Help	1	151	May 16, 2024
Read Data from .csv PowerShell Help	32	7078	May 16, 2024
Parsing a text file with tab as delimiter PowerShell Help	19	479	May 16, 2024
Join lines with powershell between files PowerShell Help	14	768	May 16, 2024
Extracting Data from Text File PowerShell Help	13	1485	May 16, 2024

How to read and parse a text file

Related topics