Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
Good morning all,
I have created a BOM drawing with all balloons positioned as I want them. I would like to create a second sheet which is exactly the same but without the "Rev" column in the BOM table as it is for a different audience. Is there a way to copy the position of the balloons from the original drawing?
Thank you.
Not directly.
The way I would do it would be to right mouse on the sheet tab and then use copy sheet and modify by table to remove the column I don't want.
@StephenW wrote:
Not directly.
The way I would do it would be to right mouse on the sheet tab and then use copy sheet and modify by table to remove the column I don't want.
Same what thought of. I used this method plenty of time and it always worked good.
I need to loop through certain files in a given directory and run the following on each file:
copy /b BOMMarker.txt+InputFile.dat OutputFile.txt
This inserts the contents of the BOMMarker.txt file at the start of the InputFile.dat and writes the output to OutputFile.txt
I found this question which explains how I can loop through the folder to load each file into Powershell, but how do I apply the "copy /b" command so that I can get the BOM marker at the start of each file?
Try the following code:
Regards, Dan N.
$dir="c:\temp"
$BomFile="C:\temp\BOMMarker.txt"
foreach ($file in gci $dir -Filter "*.dat")
{
$OutFile=$file -replace(".dat",".txt")
New-Item -ItemType file $OutFile –force
Get-Content $BomFile,$file | Set-Content $OutFile
}
$dir="c:\temp"
$BomFile="C:\temp\BOMMarker.txt"
foreach ($file in gci $dir -Filter "*.dat")