-
WSfjohan
AskWoody LoungerHi,
Zeddy
Does the number of rows vary for each Client???? Yes.
Maudibe
And will there always be only 2 clients per text file?
On scrolling the text file i found 2 to 3 records exists.How do we overcome this difficultly.
Thanks
-
WSfjohan
AskWoody LoungerHi Maud,
MARVELLOUS Maud,
It’s perfect and appends the data to cells, only the date ‘Sanction Date’ & ‘Closure Date’ gets converted, will have to maintain to date format.
First record is appended properly and how to append the next record of text file to sheet, the text file contains more records.
Many Thanks.
-
WSfjohan
AskWoody LoungerThanks Paul T for the reply.
The TXT file is not in a format that is easy to import into Excel.
That’s true Paul but only available to me is this and i need to do it.Do you want a record per page? Well if that is possible then manually data cleaning will be easy for me.
Do you want a page listing all people, then another page for their data?
Any other format?
Paul actually i am not in a position to say anything, infact if you have any way please help me.cheers, Paul
p.s. I hope that’s not real data in that sample! Yes, but the format is intact.
One more thing i would like to mention that those xxxxx in data is not required to be appended in sheet.
Hope to have a favourable reply.
-
WSfjohan
AskWoody LoungerThanks Maud,
Yes thats what i wanted, but for sample i had created that if A,B & C match then move to E column, infact there are chances that cell may contain data or may be the next one also so its better that we move to the empty cell instead of fixed cell.
Thanks in advance.
-
WSfjohan
AskWoody LoungerHi Steve,
It creates the transform sheet superbly, Thanks.
One last thing i export this sheet to .pdf format how to set this sheet to A4 size with 3 sets in each sheet.
Code:Sub export() ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=”C:UsersfjohanDesktopformatedlist.pdf” End Sub
-
WSfjohan
AskWoody LoungerJanuary 31, 2014 at 8:46 am in reply to: Search & Replace the contents of text file with batch script #1436629fjohan,
Just for another way here’s a powershell script that will work.
Hi, RetiredGeek,
I tried my hands on your powershell script it show an error on line 26 & 27.
You cannot call a method on a null-valued expression.
At C:AutoSubstText.ps1:26 char:14
+ $x = $line.tostring()
+ ~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNullYou cannot call a method on a null-valued expression.
At C:AutoSubstText.ps1:27 char:14
+ $y = $x.substring(3)
+ ~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull -
WSfjohan
AskWoody LoungerJanuary 30, 2014 at 1:50 pm in reply to: Search & Replace the contents of text file with batch script #1436536Hi,
Thanks a lot for every one for wholeheartedly support.
BATcher it works perfectly, I have edited my second post.
Thanks.
-
WSfjohan
AskWoody LoungerJanuary 30, 2014 at 10:07 am in reply to: Search & Replace the contents of text file with batch script #1436467Hi,
Thanks a lot BATcher for script.
It works perfectly. many Thanks.
-
WSfjohan
AskWoody LoungerHi,
Thanks a lot.
=MID(B1,4,3)Done.
-
WSfjohan
AskWoody LoungerHi,
Thanks to all for your valuable answers, but now i face a new difficulty if suppose the mid part contains a zero then that gets trimmed in col A.
if its 001 then column A has value of only 1, if its 011 then column A has 11. I want to retain that leading zero’s also.
Please suggest. -
WSfjohan
AskWoody LoungerOctober 31, 2013 at 12:54 am in reply to: Parsing data from xml file in folders and subfolders #1420190fjohan,
Challenging project
MaudHi Maud,
Thanks for your efforts on this Challenging project, Highly obliged.Maud, Sorry to say but in-depth search the script fails to generate result on query.
I think the import xml files on tab (file) imports only one xml and searches for our query, whereas it should import all the xml files from the folder and search our query. Please have a look into this.
Thanks in advance. -
WSfjohan
AskWoody LoungerOctober 27, 2013 at 4:38 am in reply to: Parsing data from xml file in folders and subfolders #1419403Thanks Maud,
Sorry for delay reply, I did a test run on it & found it very useful, successful script on query search for which i am thankful to you and highly obliged.
Maud, I need a small change if its possible, when a particular search is given it display the search result is it possible to display the other details of that tag. If like suppose search for SerialNo= ‘000512’ it will also display the Amount, ItemSeqNo,PresentingBankRoutNo,AccountNo in the descending rows.
Thanks -
WSfjohan
AskWoody LoungerOctober 18, 2013 at 1:19 am in reply to: Parsing data from xml file in folders and subfolders #1417297fjohan,
I had set it up to search for all values for a parameter instead of a certain values for a parameter. It makes sense with what you are looking to do. I had assumed that the folder would be a dedicated folder/subfolder for XML files. I will take a look at it tonight.
Maud
Hi Maudibe,
If you have updated the file please forward me.
Thanks in advance.
-
WSfjohan
AskWoody LoungerOctober 18, 2013 at 1:14 am in reply to: Parsing data from xml file in folders and subfolders #1417296fjohan,
I had set it up to search for all values for a parameter instead of a certain values for a parameter. It makes sense with what you are looking to do. I had assumed that the folder would be a dedicated folder/subfolder for XML files. I will take a look at it tonight.
Maud
Hello Maudibe,
If you have updated the file please forward me. -
WSfjohan
AskWoody LoungerOctober 8, 2013 at 12:03 am in reply to: Parsing data from xml file in folders and subfolders #1415697Thanks Maudibe
Its very nice of you and once again i thank you very much for helping me.
Sir, The codes are perfect but for more powerful and to get the dot results i want some small changes to it.1) Search Only .XML files
2) Search based on input value of criteria, search for all .xml files in folder & sub-folder to the last row of each file for getting value.Thanks.
35091-search
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
.NET 8.0 Desktop Runtime (v8.0.16) – Windows x86 Installer
by
WSmeyerbos
12 hours, 17 minutes ago -
Neowin poll : What do you plan to do on Windows 10 EOS
by
Alex5723
8 hours, 1 minute ago -
May 31, 2025—KB5062170 (OS Builds 22621.5415 and 22631.5415 Out-of-band
by
Alex5723
10 hours, 51 minutes ago -
Discover the Best AI Tools for Everything
by
Alex5723
11 hours ago -
Edge Seems To Be Gaining Weight
by
bbearren
1 hour, 9 minutes ago -
Rufus is available from the MSFT Store
by
PL1
9 hours, 12 minutes ago -
Microsoft : Ending USB-C® Port Confusion
by
Alex5723
1 day, 12 hours ago -
KB5061768 update for Intel vPro processor
by
drmark
18 hours, 27 minutes ago -
Outlook 365 classic has exhausted all shared resources
by
drmark
14 hours, 39 minutes ago -
My Simple Word 2010 Macro Is Not Working
by
mbennett555
1 day, 7 hours ago -
Office gets current release
by
Susan Bradley
1 day, 10 hours ago -
FBI: Still Using One of These Old Routers? It’s Vulnerable to Hackers
by
Alex5723
3 days ago -
Windows AI Local Only no NPU required!
by
RetiredGeek
2 days, 9 hours ago -
Stop the OneDrive defaults
by
CWBillow
3 days, 1 hour ago -
Windows 11 Insider Preview build 27868 released to Canary
by
joep517
3 days, 11 hours ago -
X Suspends Encrypted DMs
by
Alex5723
3 days, 13 hours ago -
WSJ : My Robot and Me AI generated movie
by
Alex5723
3 days, 13 hours ago -
Botnet hacks 9,000+ ASUS routers to add persistent SSH backdoor
by
Alex5723
3 days, 14 hours ago -
OpenAI model sabotages shutdown code
by
Cybertooth
3 days, 14 hours ago -
Backup and access old e-mails after company e-mail address is terminated
by
M W Leijendekker
3 days, 3 hours ago -
Enabling Secureboot
by
ITguy
3 days, 10 hours ago -
Windows hosting exposes additional bugs
by
Susan Bradley
3 days, 22 hours ago -
No more rounded corners??
by
CWBillow
3 days, 18 hours ago -
Android 15 and IPV6
by
Win7and10
3 days, 8 hours ago -
KB5058405 might fail to install with recovery error 0xc0000098 in ACPI.sys
by
Susan Bradley
4 days, 11 hours ago -
T-Mobile’s T-Life App has a “Screen Recording Tool” Turned on
by
Alex5723
4 days, 13 hours ago -
Windows 11 Insider Preview Build 26100.4202 (24H2) released to Release Preview
by
joep517
4 days, 8 hours ago -
Windows Update orchestration platform to update all software
by
Alex5723
4 days, 21 hours ago -
May preview updates
by
Susan Bradley
4 days, 8 hours ago -
Microsoft releases KB5061977 Windows 11 24H2, Server 2025 emergency out of band
by
Alex5723
4 days ago
Recent blog posts
Key Links
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.