Open the PDF file in LibreOffice Draw and once opened, it appears you can edit nearly everything.
Archives
All posts by phatdee
Data coming from different spreadsheet.
|
1 2 |
=IFERROR(VLOOKUP(B25,IMPORTRANGE("URL","sheet1!a1:e"),3,false)) |
B25 = local cell which you are using for the search
URL = url from separate google sheet
sheet1 = name of other sheet your pulling data from
!a1:e = range of the search
After the search
3 = which column you wish to pull the data from
false = will your results be sorted?
If you get #REF when you first try this, just click your mouse on that and it will bring up a “allow access” dialog. You need to allow access if your pulling data from another spreadsheet.
Here’s how to locally pull data from another sheet. For example, you have a sheet1 and sheet2.
|
1 |
=IFERROR(VLOOKUP(B3,Sheet2!C3:E3,3,false)) |
B3 = cell you want to use for search
Sheet2 = Sheet your pulling data from
!C3:E3 = range you want to pull data from
3 = which column you want data from
false = results will not be sorted.
|
1 |
=iferror(VLOOKUP(B2,Sheet1!C:E,3,false)) |
Vi your file.
|
1 2 |
To Lowercase everything type: ggVGu To Uppercase everything type: ggVGU |
This typically happens if the files (ie pictures) originated from a Windows host. I’ve found it’s much easier to just remove the spaces in the files than to deal with trying to properly quote your escapes in your loops.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
for oldname in * do newname=`echo $oldname | sed -e 's/ /_/g'` if [ "$newname" = "$oldname" ] then continue fi if [ -e "$newname" ] then echo Skipping "$oldname", because "$newname" exists else mv "$oldname" "$newname" fi done |
|
1 |
for f in `find`; do mv -v "$f" "`echo $f | tr '[A-Z]' '[a-z]'`"; done |
